13-19 and 42-51 position are date fields.
i need to comare these two date fields.
13-19 pos date format is CYYMMDD
if C=1(13 th position) then i should take it as '20' and if C='0' then it will be '19'.
i need to compare this field with YYYY-MM-DD (42-51 position).
how can i do this using DFSORT or ICETOOL.
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
Because the solution for sort related questions may vary from product to product, please ensure that you state clearly which sort product you are using.
If you are not sure, then by running a simple sort step shown below, you will be able to find out for yourself.
If the messages start with ICE then your product is DFSORT. Please also post the output of the complete line which has a message code ICE201I, as this will enable our DFSORT experts to determine which release of DFSORT that you have installed. This may also affect the solution offered.
If the messages start with WER or SYT then the product is SYNCSORT and the topic will be moved into the JCL forum by one of the moderators. Please also post the information telling which version of SYNCSORT is installed, as this may also affect the solution offered.
Thank you for taking your time to ensure that the valuable time of others is not wasted by offering inappropriate solutions which are not relevant due to the sort product being used and/or the release that is installed in your site.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
i need to accumulate records with unequal dates into output file.
It's not clear what you mean by this. "Accumulate records" - what does that mean exactly? Do you mean you want a count of the number of records with unequal dates, or a total of some field in the records (which field), or what? You need to describe your requirement in a way that people can understand before anyone can help you.
Please show an example of the records your input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field.
