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 Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts Display ZEDLMSG without Pressing F1 &... anandgbe CLIST & REXX 8 Thu Dec 15, 2016 4:20 pm
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts How to find the first monday of the w... abdulrafi COBOL Programming 10 Fri Nov 25, 2016 3:24 pm
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am


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