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

Syncsort: How to add jobname in the trailer of a report?


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Majid Hussain

New User


Joined: 18 Aug 2007
Posts: 20
Location: Bangalore

PostPosted: Tue Aug 04, 2009 5:00 pm
Reply with quote

Hi,

I have a requirement where I need to add the jobname, the job that is running the sort step to be added in trailer of the report. Can we do this using syncsort? Can you please provide the syntax or any pointers would be much appreciated.

Regards,
Majid
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Tue Aug 04, 2009 5:07 pm
Reply with quote

How will the jobname be identified to SYNCSORT
Back to top
View user's profile Send private message
Majid Hussain

New User


Joined: 18 Aug 2007
Posts: 20
Location: Bangalore

PostPosted: Tue Aug 04, 2009 5:14 pm
Reply with quote

That is what I want to know. Is it possible? because I have seen some syntaxes for ICETOOL where it can read the date, time, jobname and other stuffs fro SMF14RPT dataset. I was wondering if it can be done in syncsort.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Aug 04, 2009 7:45 pm
Reply with quote

Hello,

SMF14RPT is from historical data about previously executed processes. SMF14RPT uses SMF data as input, not the current system info.
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Tue Aug 04, 2009 10:42 pm
Reply with quote

Is it not documented one way or the other in the Syncsort User Manuals? Or, doesn't Syncsort support the SYMNAMES DD in the same manner as DFSORT?
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 496
Location: USA

PostPosted: Tue Aug 04, 2009 10:57 pm
Reply with quote

Majid Hussain wrote:
I have a requirement where I need to add the jobname, the job that is running the sort step to be added in trailer of the report.

Superk - Yes, this can be accomplished using SyncSort's Data Dictionary (SYMNAMES).

For example,
Code:
//STEP1  EXEC PGM=SORT
//SORTIN   DD DSN=input.file
//SORTOUT  DD DSN=output.file
//SYSOUT   DD SYSOUT=*
//SYMNAMES DD *       
JOBNAME,S'&JOBNAME'   
//SYSIN    DD *               
  SORT FIELDS=COPY         
  OUTFIL TRAILER1=(JOBNAME)
/*
Back to top
View user's profile Send private message
Majid Hussain

New User


Joined: 18 Aug 2007
Posts: 20
Location: Bangalore

PostPosted: Wed Aug 05, 2009 10:10 am
Reply with quote

Thanks a lot guys! Appreciate it. I will try it out.
Back to top
View user's profile Send private message
Majid Hussain

New User


Joined: 18 Aug 2007
Posts: 20
Location: Bangalore

PostPosted: Wed Aug 05, 2009 11:09 am
Reply with quote

It worked!! Thanks Alissa. Can you also please tell me the variable name for the JobNumber or if I can get the list of variables in SYMNAMES?
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Wed Aug 05, 2009 3:28 pm
Reply with quote

This is the list of the standard Dynamic System Variables. Job Number is not one of them.
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Using the Jobname parameter in a Qual... ABENDS & Debugging 1
No new posts Need help on formatting a report DFSORT/ICETOOL 14
No new posts Creating Report using SORT DFSORT/ICETOOL 7
No new posts Insert trailer for non empty file only DFSORT/ICETOOL 6
Search our Forums:

Back to Top