|
View previous topic :: View next topic
|
| Author |
Message |
bodatrinadh
Active User
Joined: 05 Jan 2007
Posts: 101
Location: chennai (India)
|
|
|
|
Hi All,
How can i insert/Add a record in a Flat File using SyncSort ?
For Example
Input File:-
00019890
00019891
00018991
18987611
And my Output file should be :-
00019890
00019891
00018991
18987611
99999999 ==> Need to add '99999999' at the end.
Consider Record Length = 10 and Record Form is FB.
Thanks
Trinadh |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
did You search the forums on how to add a trailer record
( most of the topics will deal with trailer record with some kind of counter ) |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
I am in a very good mood today
here is a snippet
| Code: |
000007 //S1 EXEC PGM=SORT
000008 //SYSPRINT DD SYSOUT=*
000009 //SYSOUT DD SYSOUT=*
000010 //SORTIN DD *
000011 DETAIL 01
000012 DETAIL 02
000013 DETAIL 03
000014 DETAIL 04
000015 DETAIL 05
000016 DETAIL 06
000017 //SORTOUT DD SYSOUT=*,
000018 // DCB=(RECFM=FB,LRECL=80)
000019 //SYSIN DD *
000020 SORT FIELDS=COPY
000021 OUTFIL TRAILER1=(1:C'TRAILR'),REMOVECC |
that will produce
| Code: |
********************************* TOP OF DATA **********************************
DETAIL 01
DETAIL 02
DETAIL 03
DETAIL 04
DETAIL 05
DETAIL 06
TRAILR
******************************** BOTTOM OF DATA ******************************** |
modify according to Your need
anyway nothing that You could not find yourself by searching the forums, or even googling |
|
| Back to top |
|
|
bodatrinadh
Active User
Joined: 05 Jan 2007
Posts: 101
Location: chennai (India)
|
|
|
|
| Thanks Enrico. I used Trailer record concept and it worked. |
|
| Back to top |
|
|
|
|
