Hi
My input file is in below shown format. LRECL is 80
*******************************
19881201 20160614
first date is a DOB and the other is effective date . DOB<Eff Date always.
I need output as
*****************
27years 193days
Please help me build this JCL.
Search found 6 matches
- Tue Jun 14, 2016 10:26 pm
- Forum: JCL
- Topic: JCL to calculate age by subtracting 2 dates
- Replies: 1
- Views: 6508
- Fri Nov 27, 2015 10:45 pm
- Forum: JCL
- Topic: Need help in JCL string search
- Replies: 6
- Views: 5827
No. It doesn't always end with 01. And key1 and key2 that i have mentioned is actually time stamp. so there are "-" elsewhere too.Only thing that is common in all the records is that the output i need contains "00000-0000" i.e, first five bytes and last four bytes are always numbers. So is there any...
- Thu Nov 26, 2015 11:29 pm
- Forum: JCL
- Topic: Need help in JCL string search
- Replies: 6
- Views: 5827
- Thu Nov 26, 2015 1:44 pm
- Forum: JCL
- Topic: Need help in JCL string search
- Replies: 6
- Views: 5827
Need help in JCL string search
I have a file with following data. Lrecl -50
Key1 | capgemini 02013-7654
Key2 | morgan stanley 02156-8954
I need output as
Key1 | 02013-7654
Key2 | 02156-8954
Please help me out
Key1 | capgemini 02013-7654
Key2 | morgan stanley 02156-8954
I need output as
Key1 | 02013-7654
Key2 | 02156-8954
Please help me out
- Wed Nov 04, 2015 11:32 pm
- Forum: JCL
- Topic: Complex JCL - please help
- Replies: 2
- Views: 4040
Complex JCL - please help
If suppose i have a file with data as shown below.
input File data:
key1 data1 data2
key1 data3 data4
I need output as shown below
output file data :
key1 data1 data2 data3 data4
Is there any JCL which can get me this output?
input File data:
key1 data1 data2
key1 data3 data4
I need output as shown below
output file data :
key1 data1 data2 data3 data4
Is there any JCL which can get me this output?
- Tue Oct 06, 2015 12:28 pm
- Forum: JCL
- Topic: JCL to check if a file contains only numbers
- Replies: 2
- Views: 3742
JCL to check if a file contains only numbers
Hi. Please help me out. I need jcl code to check if a file contains only numbers or not.
Example: If file A has records
1100223344
110022334A
In this case i want to omit first record having only numbers and move it into a new file.
Example: If file A has records
1100223344
110022334A
In this case i want to omit first record having only numbers and move it into a new file.