Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to validate month of current date in the sort card

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
diwakaraprasad.sadagopan

New User


Joined: 14 Jun 2010
Posts: 1
Location: Chennai

PostPosted: Tue Aug 31, 2010 11:50 am    Post subject: How to validate month of current date in the sort card
Reply with quote

Hi Friends,

Need your help for one query. We have a Job which runs monthly and need to introduce a new sort card which has to copy data from input to output on some condition only in the month of september. For all other months empty file will be created.

Input file: 200 FB
Output :200 FB

Is there validation can be done on DATE field for checking the month in the include condition?

Please help!!!!
Back to top
View user's profile Send private message

sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Tue Aug 31, 2010 7:27 pm    Post subject:
Reply with quote

Diwakaraprasad,
Quote:
We have a Job which runs monthly and need to introduce a new sort card which has to copy data from input to output on some condition only in the month of september.

Please define your conditions for copying data from input to output. Please show some example of the input and your expected output. What is the position of the DATE field and date format (ccyy-mm-dd or ccyy/mm/dd etc.) in your input file?

Thanks.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Sort numeric fields with trailing spaces sancraig16 SYNCSORT 7 Tue Apr 03, 2018 1:21 am
No new posts Find & Replace string in CA-SORT mrgnndhmk CA Products 1 Fri Mar 30, 2018 12:58 am
No new posts SORT 3 files,extract specific fields ... Kiransr DFSORT/ICETOOL 13 Fri Mar 23, 2018 10:54 am
No new posts How to Generate JCL using Sort naveen katkuri DFSORT/ICETOOL 7 Tue Mar 13, 2018 3:50 pm
No new posts Need better approach to create a sort... Vamshi Veludandi DFSORT/ICETOOL 8 Thu Mar 08, 2018 5:59 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us