View previous topic :: View next topic
|
Author |
Message |
Dhanya Sreevalsam
New User
Joined: 13 Mar 2012 Posts: 7 Location: india
|
|
|
|
hi iam writing a sort job to replace phoneorders with spaces.please find the sort card below.
Code: |
OPTION COPY
OUTREC IFTHEN=(WHEN=(865,11,CH,EQ,C'PHONEORDERS',
AND,910,19,CH,EQ,C'CS.MANDS.AMAZON.COM'),
BUILD=(1:1,864,91X,956:956,443))
|
dfsort version is Z/OS DFSORT V1R10.
lrecl of input file is 1339 and contains about one million records.
could you please guide me whether i should use sortwork datasets for the above since am going to implement this job in production? |
|
Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
you are copying not sorting hence no SORTWK datasets are needed.
Gerry |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
You are going to test it before it goes into production? This will reveal your answer, won't it? |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
Dhanya Sreevalsam,
You are just copying the input to output while editing the contents for a few records, so there is NO need for sort work datasets. However I suggest you use OVERLAY instead of BUILD as you just need to space out the contents at position 865 for a length of 91 bytes.
Code: |
OPTION COPY
OUTREC IFTHEN=(WHEN=(865,11,CH,EQ,C'PHONEORDERS',AND,
910,19,CH,EQ,C'CS.MANDS.AMAZON.COM'),
OVERLAY=(865:91X))
|
|
|
Back to top |
|
|
Dhanya Sreevalsam
New User
Joined: 13 Mar 2012 Posts: 7 Location: india
|
|
|
|
many thanks for all your quick responses |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
COPY operation or not - is not DYNALLOC option is "usually" default these days?
OP has not mentioned about it, so I'll take the benefit of doubt and say just don't code SORTWORK files - is not it true, keeping the first statement of mine in mind? |
|
Back to top |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010 Posts: 577 Location: USA
|
|
|
|
Quote: |
COPY operation or not - is not DYNALLOC option is "usually" default these days |
Not really. It depends on what system admins has DYNAUTO defaulted to. DYNAUTO=IGNWKDD would do that but that's generally not how it is set. [citation needed]
Most cases, DYNAUTO is set to YES so if someone wants SORTWK they can use it that way or else DYNAMIC ALLOCATION. Atleast that's how we have it our system.
Thanks, |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
In general, we recommend not specifying SORTWKdd DD statements so DFSORT can use dynamically allocated work data sets.
However, if you do specify SORTWKdd DD statements, DFSORT will use them and NOT use dynamically allocated work data sets, unless your site has set DYNAUTO=IGNWKDD as the installation default. With DYNAUTO=IGNWKDD, DFSORT deallocates the SORTWKdd DD data sets and use dynamically allocated work data sets.
And, of course, work data sets are only needed for a sort application, not a copy or merge application. |
|
Back to top |
|
|
girishbs13
New User
Joined: 11 Nov 2011 Posts: 24 Location: India
|
|
|
|
Is there any way to check to what value DYNAUTO is set in my system?
I checked DFSORT spool message and was unable to find it. |
|
Back to top |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010 Posts: 577 Location: USA
|
|
|
|
girishbs13,
Run this job and check OUT.
Code: |
//STEP0001 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//OUT DD SYSOUT=*
//TOOLIN DD *
DEFAULTS LIST(OUT)
/* |
Thanks, |
|
Back to top |
|
|
girishbs13
New User
Joined: 11 Nov 2011 Posts: 24 Location: India
|
|
|
|
Thanks sqlcode1 |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Thanks - was curious.
Have a good one, |
|
Back to top |
|
|
|