Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Display Last Week's Date in each Record using Syncsort(V1.2)

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Raghuraman_New

New User


Joined: 03 Oct 2008
Posts: 43
Location: Chennai,India.

PostPosted: Mon Apr 27, 2009 5:42 pm    Post subject: Display Last Week's Date in each Record using Syncsort(V1.2)
Reply with quote

Hi ,
I ve included only the Last One week's Data from the input data file using the below cntlcard,

INCLUDE COND=(1,18,BI,LE,&DATE4,AND,1,18,BI,GT,&DATE4-7)

This works fine for me icon_lol.gif . But i need to display the Last week's date along with each input record.

Suppose Current Date :- 27-04-2009

Output Record :-

20-04-2009 Input data1
20-04-2009 Input data2
20-04-2009 Input data3
.
.
.

I tried using the cntlcard,

OUTREC FILELDS=(1:&Date4-7,19:Input data)

but it shows me "Syntax error" in OUTREC statement.
Back to top
View user's profile Send private message

genesis786

Active User


Joined: 28 Sep 2005
Posts: 210
Location: St Katherine's Dock London

PostPosted: Mon Apr 27, 2009 6:43 pm    Post subject:
Reply with quote

i think the date4 is 19 long.. so u need to start the next column from 20..

i.e.
Code:

OUTREC FILELDS=(1:&Date4-7,20:Input data)
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Mon Apr 27, 2009 7:19 pm    Post subject:
Reply with quote

Quote:
but it shows me "Syntax error" in OUTREC statement.

Please post the sysouts......
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 5 Wed Jul 26, 2017 7:35 pm
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts Display upon console bipinpeter COBOL Programming 1 Thu Jun 22, 2017 12:35 am
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us