Search found 8 matches

by Srikrishna116
Tue Feb 02, 2016 7:31 am
Forum: DFSORT , ICETOOL & Utilities
Topic: PARSE more than 100 fields
Replies: 6
Views: 6185

William Collins,
Thanks for your response. But am sorry that I didnt mention that I am using SYNCSORT utility..I tried using %998,%999 but got an error "NUMERIC FIELD ERROR"
by Srikrishna116
Mon Feb 01, 2016 8:38 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: PARSE more than 100 fields
Replies: 6
Views: 6185

Correction of SORT card of my previous post

OUTREC PARSE=(%1=(ENDBEFR=C'~',FIXLEN=24,REPEAT=8 ),

BUILD=(%1,%2,%3,%4,%5,%6,%7,%8 )
by Srikrishna116
Mon Feb 01, 2016 8:37 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: PARSE more than 100 fields
Replies: 6
Views: 6185

PARSE more than 100 fields

Hi, Can someone please help me regarding my below query? I got stuck with the parsing of below copybook layout. 01 EX-Field OCCURS 75 times. 10 Field3 PIC X(04). 10 Field4 PIC 9(10). 10 Field5 PIC X(24). 10 Field6 PIC X(17). My input file has data like below: HeaderYYYYMMDD NField1~Field2~Field3(1)~...
by Srikrishna116
Fri Jan 29, 2016 6:17 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Parse fields of different lengths defined under single array
Replies: 5
Views: 4700

Thank you William Collins for your response.

I had given OCCURS 2 for an example. But in my original copybook layout, there are 3 to 4 arrays defined with more number of occurrences(like 50 to 75) & fields(10 to 20) of different lengths.
by Srikrishna116
Fri Jan 29, 2016 5:10 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Parse fields of different lengths defined under single array
Replies: 5
Views: 4700

Parse fields of different lengths defined under single array

Hi, Can someone please help me regarding my below query? I got stuck with the parsing of below copybook layout. 01 EX-Field OCCURS 2 times. 10 Field3 PIC X(04). 10 Field4 PIC X(10). My input file has data like below: HeaderYYYYMMDD NField1~Field2~Field3(1)~Field4(1)~Field3(2)~Field4(2) VField1Dataty...
by Srikrishna116
Fri Jan 29, 2016 12:25 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Write data to array using SORT/SYNCSORT JCL
Replies: 3
Views: 4310

Thanks a ton William Collins . REPEAT worked in SYNCSORT. Your suggestion means a lot for me. But surprisingly I faced one more scenario now. Case 3: Got stuck with the parsing of below copybook layout. 01 EX-Field OCCURS 2 times. 10 Field3 PIC X(04). 10 Field4 PIC X(10). My input file has data like...
by Srikrishna116
Thu Jan 28, 2016 4:23 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Write data to array using SORT/SYNCSORT JCL
Replies: 3
Views: 4310

Write data to array using SORT/SYNCSORT JCL

Hi, Can someone please help me regarding my below query? Case1: My input FB file has data like below: HeaderYYYYMMDD NField1~Field2~Field3 VField1Datatype~Field2Datatype~Field3Datatype D111~abcd~G12 D2222~abc~G443 Trailer0002 In this case, I have removed Header, trailer records,delimiters '~' by wri...
by Srikrishna116
Thu Jan 28, 2016 4:15 pm
Forum: JCL
Topic: Write data to array using SORT/SYNCSORT JCL
Replies: 1
Views: 3126

Write data to array using SORT/SYNCSORT JCL

Hi, Can someone please help me regarding my below query? Case1: My input FB file has data like below: HeaderYYYYMMDD NField1~Field2~Field3 VField1Datatype~Field2Datatype~Field3Datatype D111~abcd~G12 D2222~abc~G443 Trailer0002 In this case, I have removed Header, trailer records,delimiters '~' by wri...