INCLUDE CONDITION TO SORTOUT DATA FROM VBA FILE



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

INCLUDE CONDITION TO SORTOUT DATA FROM VBA FILE

Postby mvmanish » Fri Mar 11, 2016 2:48 am

i am trying to write a jcl for sorting out data. In my jcl sortin ds is vba file withe 120 byte length and sortout file is alse created with same attributes as sortin. But the problem here is i m using include statment as below.

SORT FIELDS=COPY
INCLUDE COND=(88,14,CH,EQ,C'RECORDS LOADED')

I am getting the error as "INCLUDE/OMIT FIELD BEYOND RECORD"
mvmanish
 
Posts: 10
Joined: Fri Mar 11, 2016 1:25 am
Has thanked: 1 time
Been thanked: 0 time

Re: INCLUDE CONDITION TO SORTOUT DATA FROM VBA FILE

Postby Terry Heinze » Fri Mar 11, 2016 3:47 am

In the future, please post in the appropriate forum: DFSORT, Syncsort, or whatever. And use code tags where applicable.
Are any of your input records less than 101 bytes long?
.... Terry
Terry Heinze
 
Posts: 239
Joined: Wed Dec 04, 2013 11:08 pm
Location: Richfield, MN, USA
Has thanked: 12 times
Been thanked: 11 times

Re: INCLUDE CONDITION TO SORTOUT DATA FROM VBA FILE

Postby BillyBoyo » Fri Mar 11, 2016 4:56 am

Have a look at VLSCMP and VLSHRT in the documentation.

These users thanked the author BillyBoyo for the post:
Terry Heinze (Sat Mar 12, 2016 12:17 am)
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: INCLUDE CONDITION TO SORTOUT DATA FROM VBA FILE

Postby mvmanish » Fri Mar 11, 2016 11:47 pm

Terry,
Sure i will check in future.
Some of the input records are having less than 101 bytes. Please suggest
mvmanish
 
Posts: 10
Joined: Fri Mar 11, 2016 1:25 am
Has thanked: 1 time
Been thanked: 0 time

Re: INCLUDE CONDITION TO SORTOUT DATA FROM VBA FILE

Postby Terry Heinze » Sat Mar 12, 2016 12:17 am

I think BillyBoyo gave you the answer.
.... Terry
Terry Heinze
 
Posts: 239
Joined: Wed Dec 04, 2013 11:08 pm
Location: Richfield, MN, USA
Has thanked: 12 times
Been thanked: 11 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post