 |
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 20 matches |
| Author | Message |
|---|---|
 Topic: Replace comma between paired quotes |
|
| Gerd Hofmans Replies: 2 Views: 1869 |
 Forum: Utilities Posted: Mon Jan 23, 2017 2:46 am Subject: Replace comma between paired quotes |
| Thanks for your reply, but i think that you have tested that with a FB file.
The input file is VB, therefor the squeezing starts at position 5. The proposed statement will replace all commas with do ... |
|
| Topic: Replace comma between paired quotes |
|
| Gerd Hofmans Replies: 2 Views: 1869 |
Forum: Utilities Posted: Fri Jan 20, 2017 6:53 am Subject: Replace comma between paired quotes |
| Hi,
an input file contains comma seperated values. The charcter fields are enclosed in double quotes. "EUR",0,"EUR",0,"EUR","060",20160625,20160625,2016070 ... |
|
| Topic: Read a sequential file with SQL |
|
| Gerd Hofmans Replies: 2 Views: 3502 |
Forum: Application Programming Posted: Mon Nov 28, 2016 5:32 am Subject: Read a sequential file with SQL |
| Hi,
I need to read a sequential file on z/OS with SQL, but cannot find a decent manual how to do this, nor the JCL to use for this. Do you have any suggestion where to look? Kind Regards, Gerd. |
|
| Topic: Reading a date as dd.mm.yyyy |
|
| Gerd Hofmans Replies: 2 Views: 2201 |
Forum: Utilities Posted: Wed Jun 22, 2016 12:56 am Subject: Reading a date as dd.mm.yyyy |
| The dates in the input file have the format dd.mm.yyyy, so i read them as :
#START-DATE-DD,00024,00002 #START-DATE-MM,00027,00002 #START-DATE-YYYY,00030,00004 and write them as : @STA ... |
|
| Topic: Reading a date as dd.mm.yyyy |
|
| Gerd Hofmans Replies: 2 Views: 2201 |
Forum: Utilities Posted: Tue Jun 21, 2016 5:12 am Subject: Reading a date as dd.mm.yyyy |
| Hi,
In DFSORT there are a number of possibilities to read a date with formats Y2x or Y4x, but i can't find a format to read a date as dd.mm.yyyy or ddmmyyyy. Is that possible? Kind Regards, Gerd. |
|
| Topic: use of multiple sections and trailer3 |
|
| Gerd Hofmans Replies: 5 Views: 5990 |
Forum: Utilities Posted: Wed Apr 20, 2016 8:01 am Subject: use of multiple sections and trailer3 |
| Hi Kolusu & Bill,
Many thanks for your suggestions (that i carefully implemented). to answer Bill's question : The input data is not sorted. Just for the record : Sorting the entire input file ... |
|
| Topic: use of multiple sections and trailer3 |
|
| Gerd Hofmans Replies: 5 Views: 5990 |
Forum: Utilities Posted: Tue Apr 19, 2016 4:48 am Subject: use of multiple sections and trailer3 |
| Thanks Kolusu!
After some testing, i decided to split the operations into 2 steps because in 1 step it was taking too much CPU (it's a verly large file, and i start with splitting it into 30 subfiles ... |
|
| Topic: use of multiple sections and trailer3 |
|
| Gerd Hofmans Replies: 5 Views: 5990 |
Forum: Utilities Posted: Fri Apr 15, 2016 3:21 am Subject: use of multiple sections and trailer3 |
| What would be the optimal code to count 2 different values in a file, like :
Input 1-5 6-75 ------------- A1 VALUE1 A1 VALUE1 A1 VALUE1 A1 VALUE2 A1 VALUE2 A1 VALUE3 A1 ... |
|
| Topic: How to properly parse and test the parsed field |
|
| Gerd Hofmans Replies: 11 Views: 5809 |
Forum: Utilities Posted: Wed Mar 02, 2016 7:23 am Subject: How to properly parse and test the parsed field |
| Hi, i can see your suggestion, but these are external production files. It is not possible to change them, that's why it takes a lot of effort to make them useable. Thanks for your concern.
Cheers, G ... |
|
| Topic: Submit issued |
|
| Gerd Hofmans Replies: 3 Views: 2501 |
Forum: Utilities Posted: Wed Feb 03, 2016 2:54 am Subject: Submit issued |
| Thank you for your reply.
kind regards, Gerd. |
|
| Topic: Submit issued |
|
| Gerd Hofmans Replies: 3 Views: 2501 |
Forum: Utilities Posted: Tue Feb 02, 2016 7:12 am Subject: Submit issued |
| Hi,
Is there a possibility (SMF record, ...) to see from where a user issued a submit command, i mean the member and pds name. |
|
| Topic: How to properly parse and test the parsed field |
|
| Gerd Hofmans Replies: 11 Views: 5809 |
Forum: Utilities Posted: Tue Jan 26, 2016 1:50 am Subject: How to properly parse and test the parsed field |
| Many thanks for these very nice solutions, not only the code but also the logic!
Ofcourse this is working 
It's part of a bigger conversion logic where a 4th gen language is replaced by DFSORT. B ... |
|
| Topic: How to properly parse and test the parsed field |
|
| Gerd Hofmans Replies: 11 Views: 5809 |
Forum: Utilities Posted: Mon Jan 25, 2016 10:41 am Subject: How to properly parse and test the parsed field |
| Hi, the data (field 60,8 ) does not include spaces. If the non-numeric data is at the left, then, if the whole length is LT 8, pad after the non-numeric data with zeroes, so shift the numeric portion ... | |
| Topic: How to properly parse and test the parsed field |
|
| Gerd Hofmans Replies: 11 Views: 5809 |
Forum: Utilities Posted: Mon Jan 25, 2016 10:28 am Subject: How to properly parse and test the parsed field |
| unfortunately, yes, that's the case. | |
| Topic: How to properly parse and test the parsed field |
|
| Gerd Hofmans Replies: 11 Views: 5809 |
Forum: Utilities Posted: Mon Jan 25, 2016 8:37 am Subject: How to properly parse and test the parsed field |
| Input
-6----+----7----+----8----+----9----+--- A5207 012 02603712 012 04302109 012 03938288 ... |
|
All times are GMT - 5 Hours |