Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Question in DFSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Thu Oct 24, 2013 8:40 pm    Post subject: Question in DFSORT
Reply with quote

Hi,

I am trying to extract few records (based on condition) from a file using sort step. The field is packed decimal type (newly added field). This field also has value spaces in this field for the existing records. (X'4040404040' is displayed in the field when i view in fileaid).

When I use sort, the o/p also includes records with spaces.

Field name - Field-1; Field type - Packed decimal, Field length - 5. Required condition is Field-1 is greater than zero.

When i try the following condition, the o/p also includes the records with value spaces in this field.

SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(100,5,PD,GT,0)


I am able to skip the records with spaces using the below condition, but I am not sure if this is the best approach. Is there any other way I can skip the records with spaces in this field.

SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(100,5,CH,NE,X'4040404040',AND,100,5,PD,GT,0)

Thanks in Advance for you suggestions.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Oct 24, 2013 9:04 pm    Post subject:
Reply with quote

Hello,

If the data will be that inconsistent, that code should do what you want.

Why is the data inconsistent? Do those data positions have different usage for different record types?
Back to top
View user's profile Send private message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Thu Oct 24, 2013 9:10 pm    Post subject: Reply to: Question in DFSORT
Reply with quote

This is a new field. I am replacing a FILLER with this new field. Just now i realised that this field (Used to be filler) also has spaces for existing records.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Oct 24, 2013 11:39 pm    Post subject:
Reply with quote

Hello,

Then you need to initialize the field as part of making it "named" instead of filler.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Asynchronous CICS Processing Question moezbud CICS 0 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm
No new posts How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us