Passing symbol value using DFSORT to file

Question

Statement: Earlier files were fetched from remote server location to mainframe. Then those files content were get and saved at mainframe in a sequential file. But sometime, some file names contained spaces. Due to this job fails while getting its content.

Now to solve this problem, we fetched all files from server and separated good files and bad files. Now we fetch only good file contents.

Problem: While renaming the files, we add prefix Process_ and Odate(fetched from Control M) to file name. But earlier it was done in jcl as below through unix code.

Pseudo code: print "rename " $1 " " "Process_" %%DAT "_" $1

We are fetching ODATE from a software control-M.

Jcl code:

//JOBNAME JOB (DEE),'Job Desc',CLASS=P,MSGCLASS=J,
//       MSGLEVEL=(1,1),COND=(0,NE)                           
//* %%SET  %%DAT = %%$ODATE
//STEP01 EXEC PROC1

PROC1 code:

//STEP02 EXEC PGM=SORT                                                               
//SORTIN   DD  DSN=DS.FILE1,        
//             DISP=SHR                     
//SORTOUT  DD  DSN=DS.FILE2,     
//             UNIT=SYSSF,                                   
//             DCB=(RECFM=FB,LRECL=80,BLKSIZE=0),            
//             SPACE=(27920,(29,6),RLSE),      
//             DISP=(NEW,CATLG,DELETE)                       
//SYSIN    DD  DSN=DS.PARM(PARM03),DISP=SHR       

PARM03 contains: Here I am creating unix code to rename file:

SORT FIELDS=COPY                                               
OUTFIL BUILD=(1:C'print "get " r_fi',18:SEQNUM, -              
    3,ZD,22:C'" //DD:upload"',/,1:C'print "rename " r_fi',  -
         21:SEQNUM,3,ZD,24:C' ', -                          
25:C' " " "Process_" %%DAT "_" r_fi',53:SEQNUM,3,ZD,80:X)      
/*                                                          

The unix code which I am creating dynamically: Here depending on the number of files p_fi01, p_fi02, p_fi03..... is generated. I am saving the unix code in a dataset and passing it as instream to run.

The problem is, it is not able to get the value in DAT variable. Is there any way, I can pass the value of D from jcl to proc and append it with
"Process_" using sort card in proc.

Example data: File File1.csv contents are fetched and then renamed as Process_20140101_File1.csv

Answer 1

Assuming that the rest of your code is OK, it is fairly simple with DFSORT, using JPn, which is a special DFSORT symbol which allows the separate values of up to 10 parameters to be used in control cards.

Here is an example:

// SET INPARM='ABC' 
//* 
//STEP0100 EXEC PGM=SORT,PARM='JP0"&INPARM"'
//SYSOUT   DD SYSOUT=* 
//SYMNOUT  DD SYSOUT=* 
//SORTOUT  DD SYSOUT=* 
//SYSIN    DD * 
  OPTION COPY 
  INREC BUILD=(JP0) 
//SORTIN   DD * 
IRRELEVANT DATA, JUST AN EXAMPLE 

I have used SET to create a JCL symbol, but you have yours already from CONTROL-M, so just replace &INPARM on the PARM with your CONTROL-M symbol.

JPn means JP0 through JP9. Three separate pieces of data could look like this:

//STEP0100 EXEC PGM=SORT,PARM='JP0"&INPARM1",JP1"&INPARM2",JP2"&INPARM3"'

The SYMNOUNT DD is optional, but very, very useful, as it will show you the translated values of the symbols.

Assuming that the rest of your code is correct, you would make this change:

25:C' " " "Process_"',JP0,C'"_" r_fi',53:SEQNUM,3,ZD,80:X) 

And include a PARM on the EXEC card, PARM='JP0"[yourControl-M-symbol]"'

SyncSort does not have JPn, so that is lucky for you that you have DFSORT. A different technique would be required for SyncSort.