|
|
| Author |
Message |
sangiah
Active User
Joined: 10 Jun 2005
Posts: 62
|
|
|
|
ICETOOL filter records based on file1 variable.
I have 2 files
File-1
2005121
file-2
0001 2005121 9999 8888 1111
0002 2005111 8888 9999 2222
0003 2005121 7777 1111 3333
The output file should be (omit recors where 6,7 = file-1 1,7)
0001 2005121 9999 8888 1111
0003 2005121 7777 1111 3333 |
|
| Back to top |
|
 |
References
|
 Posted: Wed Jun 15, 2005 9:05 am Post subject: Re: ICETOOL filter records based on file1 variable |
|
|
|
|
Alain Benveniste
Active User
Joined: 14 Feb 2005
Posts: 89
|
|
| Back to top |
|
|
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 4236
Location: San Jose, CA
|
|
|
|
Actually, in this case it's easier and more efficient to use a DFSORT job like this:
| Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
2005121
/*
//SORTOUT DD DSN=&&S1,UNIT=SYSDA,SPACE=(TRK,(1,1)),DISP=(,PASS)
//SYSIN DD *
OPTION COPY
* Create DFSORT symbol as follows:
* MYDATE,'yyyyddd'
OUTREC FIELDS=(C'MYDATE,''',1,7,C'''',80:X)
/*
//S2 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SYMNAMES DD DSN=&&S1,DISP=(OLD,PASS)
//SORTIN DD *
0001 2005121 9999 8888 1111
0002 2005111 8888 9999 2222
0003 2005121 7777 1111 3333
/*
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION COPY
* Use MYDATE symbol in INCLUDE statement.
INCLUDE COND=(6,7,CH,EQ,MYDATE)
/*
|
| Quote: |
| omit recors where 6,7 = file-1 1,7 |
Actually, your output shows that you're using include, not omit. |
|
| Back to top |
|
|
Alain Benveniste
Active User
Joined: 14 Feb 2005
Posts: 89
|
|
|
|
| Oh yes, I hadn't envisaged that file 1 could have only one record... |
|
| Back to top |
|
|
|
|
|
