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

Need to write 3 output files


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Fri Jan 05, 2007 7:04 pm
Reply with quote

Assuming this:
Code:
OUTFIL FNAMES=OUT12,INCLUDE=....
OUTFIL FNAMES=OUT1,INCLUDE=....
OUTFIL FNAMES=OUT2,INCLUDE=....
And this:
Code:
COPY FROM(IN1)....
COPY FROM(IN1)....
The DDs would something like this:
Code:
IN1     DD DSN=SAMBA.RA186.SORTOUT.SQLA6.Y120619,DISP=OLD
IN2     DD DSN=SAMBA.RA186.SRTOUT.NOVBARC.Y120629,DISP=OLD
OUT12 DD DSN=SAMBA.SRTOT.OUT12.DEL365,
        DISP=(NEW,CATLG,CATLG),
        UNIT=DEVPOOL,
        SPACE=(CYL,(10,15),RLSE),
        DCB=(LRECL=91,BLKSIZE=0,RECFM=FB)
OUT1  DD DSN=SAMBA.SRTOT.OUT12.DEL365,
        DISP=(NEW,CATLG,CATLG),
        UNIT=DEVPOOL,
        SPACE=(CYL,(10,15),RLSE),
        DCB=(LRECL=91,BLKSIZE=0,RECFM=FB)
OUT2  DD DSN=SAMBA.SRTOT.OUT12.DEL365,
        DISP=(NEW,CATLG,CATLG),
        UNIT=DEVPOOL,
        SPACE=(CYL,(10,15),RLSE),
        DCB=(LRECL=91,BLKSIZE=0,RECFM=FB)
Back to top
View user's profile Send private message
sambasivarao

New User


Joined: 10 Jul 2006
Posts: 47
Location: Bangalore

PostPosted: Fri Jan 05, 2007 7:18 pm
Reply with quote

Hi,

Thanks a lot for quicke response..

Could you please let me know what is the use of the below statement.

//T1 DD DSN=&&T1,UNIT=SYSDA,SPACE=(TRK,(5,5)),
// DISP=(MOD,PASS)

Thanks in advance for your help.

Cheers,
Samba.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Fri Jan 05, 2007 7:25 pm
Reply with quote

That is a sort of temporary file for holding intermediate data referred to in these:
Code:
COPY FROM(IN2) TO(T1)....
.
.
SPLICE FROM(T1) TO(OUT12)....
Back to top
View user's profile Send private message
sambasivarao

New User


Joined: 10 Jul 2006
Posts: 47
Location: Bangalore

PostPosted: Fri Jan 05, 2007 7:44 pm
Reply with quote

Hi,

Thanks for the quick response.

Could you please let me know what is the significance of below statement.

INREC OVERLAY=(12:C'11')

Thanks for patience and prompt answers.

Thanks in advance for your help.

Cheers,
Samba.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Fri Jan 05, 2007 7:50 pm
Reply with quote

Frank Yaeger wrote:
Quote:
Using the SPLICE parameter 11, 12 and 22 adding as identifiers.

Why we are doing this one.


Samba,

I actually explained that in the discussion of that Topic:

Quote:
The trick here is to add an identifier of '11' to the File1 records, add an identifier of '22' to the File2 records, and splice the second id byte for matching records so we get '12' for names in both files, '11' for names only in File1 and '22' for names only in File2.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Fri Jan 05, 2007 9:49 pm
Reply with quote

Samba,

Since you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

Use [URL] BBCode for External Links

Getting Started explains OVERLAY, BUILD, and all of the other DFSORT and ICETOOL functions, as well as the JCL needed for DFSORT and ICETOOL jobs.
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 -> DFSORT/ICETOOL Goto page 1, 2  Next

 


Similar Topics
Topic Forum Replies
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts Joinkeys - 5 output files DFSORT/ICETOOL 7
Search our Forums:

Back to Top