Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Need urgent suggestion on DFSORT subratarec DFSORT/ICETOOL 6 Wed Mar 21, 2018 8:46 pm
No new posts JES2 EXIT 6 QUESTION Randy Horowitz All Other Mainframe Topics 30 Tue Feb 06, 2018 5:47 pm
No new posts Formatting using DFsort Guru Nandu DFSORT/ICETOOL 5 Thu Nov 30, 2017 7:33 am
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts Compare and COPY using DFSORT pshongal DFSORT/ICETOOL 3 Fri Nov 17, 2017 9:49 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us