Author |
Message |
Topic: Queries in report creation using syncsort |
gsat
Replies: 8
Views: 6281
|
Forum: Utilities Posted: Thu May 11, 2006 11:24 am Subject: Queries in report creation using syncsort |
Thanks Kolusu.
That was how i had initally coded it. but wanted to try it in two steps but missed it out with the SET parameter.
Thanks a lot for all your help!!
Regards,
gsat |
Topic: Queries in report creation using syncsort |
gsat
Replies: 8
Views: 6281
|
Forum: Utilities Posted: Thu May 11, 2006 10:39 am Subject: Queries in report creation using syncsort |
thanks kolusu. I did that. but have got into another problem.
I used an IDCAMS step to check if the i/p file had just header and trailer rec only and based on the return code I was trying to use th ... |
Topic: Queries in report creation using syncsort |
gsat
Replies: 8
Views: 6281
|
Forum: Utilities Posted: Wed May 10, 2006 11:09 pm Subject: Queries in report creation using syncsort |
Thanks a lot Kolusu. It definitely helped.
Also I did check ur earlier posts on empty file handling and have made use of the logic.
I have one question though, just to handle a different situatio ... |
Topic: Queries in report creation using syncsort |
gsat
Replies: 8
Views: 6281
|
Forum: Utilities Posted: Wed May 10, 2006 9:48 am Subject: Queries in report creation using syncsort |
Kolusu,
The subtotal is the sum of the amount in one page and the Grand Total is the sum of all the subtotals.
Can you please let me know how to do it for Qns 4 and 5 alone (from above) using sync ... |
Topic: Queries in report creation using syncsort |
gsat
Replies: 8
Views: 6281
|
Forum: Utilities Posted: Wed May 10, 2006 7:25 am Subject: Queries in report creation using syncsort |
Hi,
I have given below a sample input file and the output report(s) to be created from that. I have also listed the question regarding that below.
Input file:
12345M25DEPTA0001000
12346F21DEPT ... |
Topic: How to convert a Character field to PD using syncsort |
gsat
Replies: 4
Views: 4155
|
Forum: Utilities Posted: Fri May 05, 2006 3:09 am Subject: How to convert a Character field to PD using syncsort |
Thanks Kolusu. It worked!!
Thanks,
Gsat |
Topic: How to convert a Character field to PD using syncsort |
gsat
Replies: 4
Views: 4155
|
Forum: Utilities Posted: Wed May 03, 2006 6:31 am Subject: How to convert a Character field to PD using syncsort |
Thanks Kolusu.
I will try this oput and get back.
BTW what is this format FS? |
Topic: How to convert a Character field to PD using syncsort |
gsat
Replies: 4
Views: 4155
|
Forum: Utilities Posted: Wed May 03, 2006 4:15 am Subject: How to convert a Character field to PD using syncsort |
I have a field in a record which is 8 bytes long and is alphanumeric.
The data that it holds can be ' -20' or ' -2'. (for example)
I want to capture the value of the numeric in this field ... |
Topic: To replace a string in all members of a PDS |
gsat
Replies: 2
Views: 8960
|
Forum: Utilities Posted: Thu Nov 24, 2005 7:21 am Subject: To replace a string in all members of a PDS |
Hi all,
I need to replace a string in the accounting info in all members (JCLs) in a PDS (JCL LIB).
Is there any way to do it using either Fileaid batch or sort?
If not is there any Rexx utility th ... |
|