IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Can we do this using SORT Utility?


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mainframeraja

New User


Joined: 09 Mar 2005
Posts: 6

PostPosted: Thu Nov 24, 2005 12:44 pm
Reply with quote

I have a requirement.
This program/utility will run 7th of every month.What it should do is copy all records of GDG genertions which is having the last month dates as its one of the fields.
Example. GDG record contains a date field.Based on this we have to copy it to another file.Assume that the program runs on DEC 7th.if date field contain 20051123 we have to copy it to another file.if the date is 2001202 discard it.We can do this by comparing '11'(month field).But I want to run this program every month (and it should copy the records containing previous month dates) without changing anything.Can we do this using SORT/ICETOOL utility?
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 677
Location: NJ

PostPosted: Thu Nov 24, 2005 3:04 pm
Reply with quote

hi frnd,
so u have finished to write the program to compare the date and sortings etc,

Quote:
I want to run this program every month


so for this use this line
Code:
//*MAIN DEADLINE=(TIME,B,DATE)

DATE=012086 or 01/20/2000 like wise u can use the format.

Quote:
Can we do this using SORT/ICETOOL utility?


to sort the file u need SORT utility.. i have not worked with ICETOOL my frnd, i dont know many thing about that. i m sorry.
Back to top
View user's profile Send private message
mainframeraja

New User


Joined: 09 Mar 2005
Posts: 6

PostPosted: Thu Nov 24, 2005 4:03 pm
Reply with quote

Hi friend,
I didn't mean I have completed the program.I am expecting a solution using the utilities.I can handle it through the COBOL program no problem.
f I can handle it through utilities it will be good.That is why I posted the question.
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 677
Location: NJ

PostPosted: Thu Nov 24, 2005 4:08 pm
Reply with quote

hi frnd,
To compare and do , i think going for cobol will help u more. its my suggession. and those utility can b used up to certain limit only. u cant get the o/p as u think. for sorting and the other thing u go for the utility and for the checking the date and other manipulation app prog will be less headache for u. Got it.
Back to top
View user's profile Send private message
sonipankaj

New User


Joined: 23 Nov 2005
Posts: 10

PostPosted: Thu Nov 24, 2005 5:26 pm
Reply with quote

Create a Job which runs on every 7th of the month. That JOb will accepts the run a rexx step. This rexx will scan the version name of all the GDGs & prepare your JCL with previous month versions. After that it will submit that JCL.

By that your problem will get solved i think.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Thu Nov 24, 2005 10:18 pm
Reply with quote

mainframeraja,

Yes, you can do this with DFSORT.

What is the starting position, length and format of the yyyymmdd date field?

What is the RECFM and LRECL of the input file?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts REASON 00D70014 in load utility DB2 6
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
Search our Forums:

Back to Top