Page 1 of 1

Date sort

PostPosted: Fri Dec 30, 2011 12:22 pm
by bhanu1225
Hi,

I have an input file contains accounts and dates.

Positions (7 to 25) (26 to 29)
0000000000XXXXXXXXX 2013217
0000000000DDDDDDDD 2013248
0000000000YYYYYYYYY 2013278
0000000000TTTTTTTT 2013309

having so many records.

Now i want do sort by dates like,

what are the accounts on March 1st , on Marh 2nd till March 31st.

and should be in one output file.

Really Appreciated for the response.
Fast response is needed.
Thanks,

Bhanu.

Re: Date sort

PostPosted: Fri Dec 30, 2011 12:43 pm
by gokulNmf
1. what dose position 7-25 & 26-29 have?
2. what is the position of date and account.
3. can you also post the input DS data?

Re: Date sort

PostPosted: Fri Dec 30, 2011 1:00 pm
by bhanu1225
Positions 7 to 25 has accounts and positions 26-29 has dates which i mentioned.

Input dataset has

positions : 1-3 4-6 7-25 26-29
org logo acct date

mentioned the acct no's and dates in the previous post.


Thanks for the response.

Re: Date sort

PostPosted: Fri Dec 30, 2011 1:32 pm
by BillyBoyo
bhanu1225 wrote:Hi,

I have an input file contains accounts and dates.

Positions (7 to 25)                    (26 to 29)
0000000000XXXXXXXXX              2013217
0000000000DDDDDDDD              2013248
0000000000YYYYYYYYY              2013278
0000000000TTTTTTTT              2013309

having so many records.

Now i want do sort by dates like,

what are the accounts on March 1st , on Marh 2nd till March 31st.

and should be in one output file.

Really Appreciated for the response.
Fast response is needed.
Thanks,

Bhanu.


Please use the Code button to keep the formatting of you data.

Please explain how the four bytes that you mention represent a date.

Please confirm that you want the whole file in date order, once we can make sense of the date.

Re: Date sort

PostPosted: Fri Dec 30, 2011 3:03 pm
by enrico-sorichetti
Fast response is needed.

stupid requirement... urgency is your problem, not ours
replying on a forum is on
voluntary base
free of charge

in plain words when and if we feel like
if You have time constraint You should consider hiring a paid consultant.

it would have been wiser to post all the needed info to start with
for example You say date 26-29 but that' s 4 bytes, the sample data shows 7 bytes, ( in a format wich looks like YYYYDDDD )

the only urgent thing is for You how to learn to ask questions in a better way :geek:

jcl in se will do nothing,
since you talk about SORT You should have been able to choose a better forum to ask
DFSORT ( messages prefixed with ICE )
SYNCSORT ( messages prefixed with WER )