MVSFORUMS.com

[yrcreddy]

Hi,

I have an input file which contains policyno,versionno,timestamp and some otherdata.The length of the input file is 1200 and is a fixed lenth formate.

The layout of the input file is:
PolicyNo ---x(10)--1 to 10
VersionNo --x(05)--11 to 15
TimeStamp ---x(26)--16 to 42
Some other data---------

I need to extract data based on the timestamp.


The input file records are as follow:

[shekar123]

ycreddy,

Is't that your output should be

[kolusu]

yrcreddy,

try this job

[yrcreddy]

Hi kolusu,


Thank you very much for your response.The records order is changed accoding to the above jcl.In my desired output the records order should not be changed.

One more thing i forgot to specify,i want to extract only the records which are having same policy,version and diferrent timestamp.

The output of the above job is:

Q01234 5 2005-07-29-11.23.34.16
Q12345 1 2006-09-29-11.14.42.23
Q13456 1 2005-09-17-11.23.34.16
Q34567 2 2006-05-02-11.44.13.23
Q45678 12 2005-09-17-11.23.34.16
Q78901 4 2005-09-20-11.23.34.16
Q98012 6 2005-08-29-11.23.34.16
Q98075 11 2005-09-17-11.23.34.16


Desired output is:
Q34567 2 2006-05-02-11.44.13.23
Q45678 3 2005-07-29-11.23.34.16
Q78901 4 2005-07-29-11.23.34.16
Q01234 5 2005-07-29-11.23.34.16
Q98012 6 2005-08-29-11.23.34.16
Q12345 1 2006-09-29-11.14.42.23
Q13456 1 2005-09-17-11.23.34.16
Q45678 12 2005-09-17-11.23.34.16
Q98075 11 2005-09-17-11.23.34.16
Q78901 4 2005-09-20-11.23.34.16

For example:
In my first post there are two policies(Q12345&Q78901) having same version no with diferrent timestamp.The policy Q45678 has repeted twice with diferrent version no.i want to retain these records but the order should not be changed.


Can you please help me how to do it.
_________________
Thanks,
Ramachandra Reddy

[coolman]

yrcreddy,

Your inputs and outputs are inconsistent - Take, Q12345, there are 2 records with version nos 1 and 1 - You have retained the record with has the latest timestamp 2006-09-29-11.14.42.23 whereas for Q78901 you have both the records in the output even though they have the same version

Please post a correct set of inputs and outputs inorder for us to suggest you a solution.
________
Vittorio Jano

[kolusu]

ycrreddy,

Try this job. I assumed that your input is 80 bytes LRECL and is of FB recfm. However your specs are confusing. You say you want to pick the latest timestamped record and yet you say the order should not be changed. This does not work for Policy no: Q78901 as it has 2 records with the same version no (record # 4 & 11) .record # 11 has the latest timestamp. Now if we are to retain the order then Q78901 will be at the bottom where as you show it as record #4.

[yrcreddy]

Thank you very much kolusu.
This jcl is working for me what i expected.
_________________
Thanks,
Ramachandra Reddy

[jayram99]

Thanks Kolusu,

I have the following question, How do we get the following result.

1. the order of the policy number should not be changed and the record should be latest record based on timestamp and also removing the duplicates.

2. The order of the policy number should be in ascending order and the record should be latest record based on timestamp and also removing the duplicates.

Thanks in advance.

[kolusu]

jayram99,

Did you try the job posted here in this topic ?

http://www.mvsforums.com/helpboards/viewtopic.php?p=33370#33370

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[jayram99]

Thanks Kolusu,

We can't use the ICETOOL utility but i got the result by using SYNCSORT utility by sorting on Policy number and Timestamp and in the next step removed the duplicates.

Thanks again.

[kolusu]

jayram99,

run the job by changing pgm=icetool to pgm=synctool and see if it works

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[kolusu]

Jayaram99,

If you still get an error try this job.