I want the two output File say FIle2 and FILE4 like below.
File3,the first 6 char should be masked by X in ACCT-NMBR.
File4, the ACCT-NMBR should be displayed with out masking first 6 char.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Here's a DFSORT/ICETOOL job that will do what I think you asked for. I assumed you wanted the output records to have a blank between each field and LRECL=80, but you can change the job as needed.
Thanks. It's working perfectly.
But before perform this process, I have using another sort step to extract the record from the File1 (RECLEN=2000) based on below condition.
Di-code should be 111.
Sub-Div should be 888 and 999
EMP-NAME1 should be start with 'BB'.
i.e 300,2,ch,eq,c'TP'
and acct-status should be 0 0r 1.
Is this possible to include this condition in the above JCL?
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
Quote:
Is this possible to include this condition in the above JCL?
It should be. . .
You can use something like
Code:
INCLUDE COND=(17,07,CH,EQ,C'H190072')
changing the fields to meet your conditions.
Depending on what you have in the code you used to extract the needed records, it may be usable directly. If you post the original "extract code" we will be able to determine.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
EMP-NAME1 should be start with 'BB'.
i.e 300,2,ch,eq,c'TP'
Huh? Why do you say it should start with 'BB' and then show a constant of 'TP'?
At any rate, you can do what you asked for by changing the CTL1CNTL statements to the following (use 'TP' or 'BB' or whatever you need for the constant).