Date sort



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Date sort

Postby bhanu1225 » Fri Dec 30, 2011 12:22 pm

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.
bhanu1225
 
Posts: 3
Joined: Thu Nov 25, 2010 4:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Date sort

Postby gokulNmf » Fri Dec 30, 2011 12:43 pm

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?
Cheers,
Gokul
User avatar
gokulNmf
 
Posts: 118
Joined: Sat Mar 28, 2009 6:41 pm
Location: India
Has thanked: 2 times
Been thanked: 0 time

Re: Date sort

Postby bhanu1225 » Fri Dec 30, 2011 1:00 pm

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.
bhanu1225
 
Posts: 3
Joined: Thu Nov 25, 2010 4:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Date sort

Postby BillyBoyo » Fri Dec 30, 2011 1:32 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Date sort

Postby enrico-sorichetti » Fri Dec 30, 2011 3:03 pm

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 )
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post