| Author |
Message |
Topic: Dropping summary records |
wiprov
Replies: 15
Views: 8565
|
Forum: Utilities Posted: Tue Oct 07, 2014 11:08 am Subject: Dropping summary records |
Thanks a ton, for the logic.
I have used your idea and made the below logic which perfectly worked. Thanks again!
1) INREC - building the key at 11th position followed by sequence number (Col-21:2 ... |
Topic: Dropping summary records |
wiprov
Replies: 15
Views: 8565
|
Forum: Utilities Posted: Fri Oct 03, 2014 10:55 am Subject: Dropping summary records |
I am very sorry, will stick here.
Could you please provide me the sample code? Thanks in advance. |
Topic: Dropping summary records |
wiprov
Replies: 15
Views: 8565
|
Forum: Utilities Posted: Wed Oct 01, 2014 11:59 am Subject: Dropping summary records |
When running the job, i came to know we are using SYNCSORT tool..
Sorry that, i couldn't post the complete error message as all the external websites are blocked (noted in a paper and posted here). |
Topic: Dropping summary records |
wiprov
Replies: 15
Views: 8565
|
Forum: Utilities Posted: Tue Sep 30, 2014 10:47 pm Subject: Dropping summary records |
| And yes, we have to retain the order of i/p records. Thanks |
Topic: Dropping summary records |
wiprov
Replies: 15
Views: 8565
|
Forum: Utilities Posted: Tue Sep 30, 2014 9:22 pm Subject: Dropping summary records |
Yes Kolusu, I have executed the code and it has thrown the below syntax error .
OUTREC IFTHEN=(WHEN=GROUP,KEYBEGIN=(11,10),PUSH=(30:21,8))
... |
Topic: Dropping summary records |
wiprov
Replies: 15
Views: 8565
|
Forum: Utilities Posted: Tue Sep 30, 2014 12:49 pm Subject: Dropping summary records |
Hi,
Sorry, I should have been more clear in my example . ...
My intention is to remove the group, if it contains duplicate header. Slightly modifying my input and sorry again
H4 ... |
Topic: Dropping summary records |
wiprov
Replies: 15
Views: 8565
|
Forum: Utilities Posted: Sat Sep 27, 2014 11:06 pm Subject: Dropping summary records |
Hi,
I have an input file, with 3 groups and each group has header and detail records.
LREC=10, RECFM=FB
First byte -'H' indicator header record. Detail records
are indicated by either '5' or ... |
| |