View previous topic :: View next topic
|
Author |
Message |
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Hi,
I have a requirement where I have to capture the SYSUID in the SORTOUT dataset.
Please advice. |
|
Back to top |
|
|
Garry Carroll
Senior Member
Joined: 08 May 2006 Posts: 1193 Location: Dublin, Ireland
|
|
|
|
Research SYMNAMES & system symbols.
Garry. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Hi Garry,
Can you please let me know link on the the same. |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Thanks Dick...
I am able to find &JOBNAME symbol name but I didn't found any thing related to SYSUID. |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Google on : DFSORT SYSUID |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Hi Peter,
We dont have DFSORT in out shop... We are using Syncsort. |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Hi Peter,
We dont have DFSORT in out shop... We are using Syncsort. |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Oops, missed that. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
gylbharat,
Are all your recent queries related to the same requirement?
I'm just wondering if a Cobol program(s) might be a better idea for collecting and formatting the data, rather than trying to lever it all into Syncsort? |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Bill,
All the recent queries are different... |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
OK, you're busy then! |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
See (look in the manual) if Syncsort can take a PARM associated to a name (like DFSORT can).
If not, look for something which can take a parm, write it to a single-record file and try to incorporate that? |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
yeah... I tried the below sort...
Code: |
//S1 EXEC PGM=SORT,PARM='&SYSUID'
//SYSOUT DD DSN=&TEMP,DISP=(NEW,PASS,KEEP)
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN DD *
OPTION COPY
/*
//S2 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=&TEMP,DISP=(OLD,DELETE,DELETE)
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(3,7,CH,EQ,C'WER131I')
OUTREC FIELDS=(1:30,8)
/*
|
But was wondering how this can be done in a single sort. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
That's thinking, that is :-)
I have no Syncsort manual, but maybe someone can now tighten it up. I wouldn't worry too much if they can't, it might be two steps but they don't exactly do a lot.
If you go with this, make sure you document it for others at your site to ease their understanding. Someone doing support/maintenance probably won't get it first time. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Can you explain something to me,
Do you need the SYSUID in the dataset name or as part of the data |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
The file is used to load the DB2 table using load utility and Table has USER ID column. |
|
Back to top |
|
|
|