MVSFORUMS.com

[puttu]

Hi All,

I need to do subtraction using sort or icetool.

Please find the below details of my complete requirement.

I'm having one input file with 80 record length.Kindly find input file structure.
1st position to 16th position Time (2010080616342321)
17th & 18th position spaces
19th position to 34th position again Time (2010080613243121).

Now i need to subtraction 19th position to 34th position date to -4000000
(example: 2010080613243121 - 4000000) and result i need to put in output file.

My output file should be
1st position to 16th position Time (2010080616342321)
17th & 18th position spaces
19th position to 34th position again Time (2010080613243121).
40th position to 56th position which we got result using subtraction.

Rgds,
Puttu

[kolusu]

puttu,

Sort Products do NOT have the ability to subtract days from a date.
_________________
Kolusu
www.linkedin.com/in/kolusu

[puttu]

Hi Kolusu,

Its is not to subtract days.
We need to do subtraction Time.

Please find the details:
(Example: 2010080613243121 - 4000000)
For above example 2010080613243121 - YYYYMMDDHHMMSSMS
4000000 - Time i converted from GST.

Example:(13243121 - 4000000) and result i need to put in output file as i told previously.

[kolusu]

puttu,

What is the expected result of 13243121 - 4000000?

I am sure it is not plain math subtraction because if you are doing that it would result in a invalid time 9243121.

What is 4000000? is it seconds or minutes or hours or milliseconds or microseconds?

A single day(24 hours) has 86400 seconds and you are trying to subtract 4000000?

You need to do a better job of describing what you are trying to do.
_________________
Kolusu
www.linkedin.com/in/kolusu