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

Building SYMNAMES file, two or more records


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

Active User


Joined: 06 Jun 2009
Posts: 115
Location: UK

PostPosted: Tue May 13, 2014 9:08 pm
Reply with quote

Hi,

Can you some please how can I write more than one record on my SYMNAMES files.

At the moment..

Code:
//STEP001  EXEC PGM=SORT                                             
//SORTIN   DD *                                                     
140512 120514 14132 130514 14133 14129     010010Y 140505140511140506
//SORTOUT  DD DSN=MY OUTPUT.....,                                   
//            DISP=(,CATLG),SPACE=(TRK,(1,1))                       
//SYSIN    DD *                                                     
  OPTION COPY                                                       
  INREC BUILD=(C'MYDATE,''',15,5,C'''',80:X)                         
//SYSOUT   DD SYSOUT=*                                               
//SYSUDUMP DD SYSOUT=*


Output comes out:
Code:
MYDATE,'14132'


I would like to write two lines:
Code:
MYDATE,'14132'
FILEDT,'140512'


Do I need to use HEADER1 and TRAILER1?

Thanks,
zhlad
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Tue May 13, 2014 9:27 pm
Reply with quote

Depends on what you want to do.

HEADER1 and TRAILER1 support the slash operator (/), so you can create multiple lines, but with hard-coded literal values only.

OUTFIL BUILD also supports the slash operator, so you can BUILD multiple records from input and literal values.

OUTFIL REPEAT replicates input, allowing you to use input for multiple, amended, values.

You can also simply have multiple input records on SORTIN, and treat them differently depending on an identifying value with IFTHEN=(WHEN=(logical expression).

I've used JOINKEYS for generating symbols, INREC, OUTREC, OUTFIL then also ICETOOL has some operators which I've found useful for this.

All depends on the actual task. The simpler the symbol, the less code. Easiest is multiple input records, with one-to-one mapping for output.

You should also look at system symbols (as in sticky post in the first page of the DFSORT forum) and JPn symbols, which allow data to be taken from PARM values and used in SORT statements.

Symbols are a whole heap of fun, and help in many ways. There are examples here, though not as many as there could be, as people tend to want the spoon-fed answer they can just do in one copy/paste.
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

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 2
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
Search our Forums:

Back to Top