MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 9 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Queries in report creation using syncsort
gsat

Replies: 8
Views: 6281

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group