Search found 6 matches

by varad.raikar
Tue Jun 14, 2016 10:26 pm
Forum: JCL
Topic: JCL to calculate age by subtracting 2 dates
Replies: 1
Views: 6508

JCL to calculate age by subtracting 2 dates

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.
by varad.raikar
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...
by varad.raikar
Thu Nov 26, 2015 11:29 pm
Forum: JCL
Topic: Need help in JCL string search
Replies: 6
Views: 5827

That worked!!. Thanks william.

Wat if the scenario is
Input
Key1 | capgemini 02013-7654 india01
Key2 | morgan stanley 02156-8954 ny01

how do i get the output as
Key1 | 02013-7654
Key2 | 02156-8954
by varad.raikar
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
by varad.raikar
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?
by varad.raikar
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.