 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 13 matches |
| Author | Message |
|---|---|
 Topic: SYNSORT - aggregate and sum up character (ZD) fields |
|
| ssanthosh Replies: 3 Views: 2270 |
 Forum: Utilities Posted: Tue Feb 16, 2016 8:56 am Subject: SYNSORT - aggregate and sum up character (ZD) fields |
| Bill, Only first few records are sorted not all. I am able to sum the scores (numeric column) but not revenue, since revenue has decimal point. Please advise. | |
| Topic: SYNSORT - aggregate and sum up character (ZD) fields |
|
| ssanthosh Replies: 3 Views: 2270 |
Forum: Utilities Posted: Mon Feb 15, 2016 11:16 pm Subject: SYNSORT - aggregate and sum up character (ZD) fields |
| I have a requirement to SORT and sum 'score' and 'revenue' fields. All the fields are character format.
Sample input record: ----+----1----+----2----+----3----+----4---- 01,XXXXX,2016-02-09,ABC, ... |
|
| Topic: Adding (Appending) date to the file using another file date. |
|
| ssanthosh Replies: 1 Views: 3161 |
Forum: Job Control Language(JCL) Posted: Fri May 15, 2015 2:30 pm Subject: Adding (Appending) date to the file using another file date. |
| I have a requirement to create multiple datasets dynamically where the last node is read and appended from another file (fixed 8 bytes, only 1 row).
E.g: Create file XXXXXX.YYYYYY.<myname> w ... |
|
| Topic: Conversion: Decimal ZD to CHAR |
|
| ssanthosh Replies: 9 Views: 13367 |
Forum: Utilities Posted: Mon May 11, 2009 1:49 pm Subject: Conversion: Decimal ZD to CHAR |
| Kolusu.. The file that I am getting from windows is corrupting the cents field:). Thank you so much. Now we know the root cause. | |
| Topic: Conversion: Decimal ZD to CHAR |
|
| ssanthosh Replies: 9 Views: 13367 |
Forum: Utilities Posted: Mon May 11, 2009 12:16 pm Subject: Conversion: Decimal ZD to CHAR |
| Thank you Kolusu. I am converting the amount (ZD format) to Intermediate format(SFF) so that windows server program accomplish the task. After processing, I get another file from windows server (SFF f ... | |
| Topic: Conversion: Decimal ZD to CHAR |
|
| ssanthosh Replies: 9 Views: 13367 |
Forum: Utilities Posted: Mon May 11, 2009 10:54 am Subject: Conversion: Decimal ZD to CHAR |
| I tried this method. The -ve values looks good, where as for the +ve amounts there is a mismatch in the LSB.
Sample data: ========= Original file: Amount S9(13)V9(2) = 15 bytes: 00000000000535{ ... |
|
| Topic: Conversion: Decimal ZD to CHAR |
|
| ssanthosh Replies: 9 Views: 13367 |
Forum: Utilities Posted: Mon May 11, 2009 10:26 am Subject: Conversion: Decimal ZD to CHAR |
| The conversion from S9(13)V9(2) to SX(13).X(2) worked. Is there a way we convert SX(13).X(2) to S9(13)V9(2) using ICETOOL. | |
| Topic: Conversion: Decimal ZD to CHAR |
|
| ssanthosh Replies: 9 Views: 13367 |
Forum: Utilities Posted: Mon May 11, 2009 10:22 am Subject: Conversion: Decimal ZD to CHAR |
| Thank you. | |
| Topic: Conversion: Decimal ZD to CHAR |
|
| ssanthosh Replies: 9 Views: 13367 |
Forum: Utilities Posted: Mon May 11, 2009 9:49 am Subject: Conversion: Decimal ZD to CHAR |
| I have a dataset with LRECEL=100 where the Amount field is defined as S9(13)V9(02). When we ftp this file to windows server, the data is not in readable format. My aim is to convert the Amount field S ... | |
| Topic: Changing the sign byte and assumed decimal to char |
|
| ssanthosh Replies: 2 Views: 2030 |
Forum: Utilities Posted: Fri Nov 14, 2008 10:10 am Subject: Changing the sign byte and assumed decimal to char |
| Thank you kolusu. It worked. | |
| Topic: Changing the sign byte and assumed decimal to char |
|
| ssanthosh Replies: 2 Views: 2030 |
Forum: Utilities Posted: Thu Nov 13, 2008 4:47 pm Subject: Changing the sign byte and assumed decimal to char |
| We have a dataset where the signed byte is declared as S9(13)V9(02). When we ftp this file to windows server the data is not in readable format.
Our aim is to convert the Amount field S9(13)V9(02) to ... |
|
| Topic: Merge header from one file to another |
|
| ssanthosh Replies: 3 Views: 2389 |
Forum: Utilities Posted: Mon Jun 16, 2008 11:11 am Subject: Merge header from one file to another |
| Thank you. The above JCL works perfect. But i need all the 134 bytes of the header (STEP0100) in the temp file. At present STEP0100 SORTOUT dataset has LRECl=80. I changed the SYSIN to 134:X instead 8 ... | |
| Topic: Merge header from one file to another |
|
| ssanthosh Replies: 3 Views: 2389 |
Forum: Utilities Posted: Fri Jun 13, 2008 9:27 am Subject: Merge header from one file to another |
| I have 2 FBA files (LRECL=134) one with header and one without header. I have a requiremnt to copy ONLY the header from one file to another at the begining of each page.
File1: (with header): Each p ... |
|
All times are GMT - 5 Hours |