Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Tue Jan 27, 2009 11:18 am Post subject:
I'm just using a trick to allow generation of the control statements. For each input line, the BUILD operand generates a comparison of the form:
Code:
19,6,CH,EQ,C'cccccc',OR,
In order to have a valid INCLUDE statement using those comparisons, we need to have:
Code:
INCLUDE COND=(...., <------- starting line
build_comparison1,
build_comparison2,
...
...) <------- ending line
Note that we need to surround the build_comparisons with a starting and ending line for correct syntax.
I'm using HEADER1 to generate:
Code:
INCLUDE COND=(1,1,CH,NE,11,CH,OR,
and TRAILER1 to generate:
Code:
1,1,CH,NE,1,1,CH)
1,1,CH,NE,1,1,CH is essentially a NOP ... it can never be true so it doesn't include any records.
We could get fancier and not use the NOPs, but that would require more coding to identify the first and last build lines. The use of NOPs is a simpler solution. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
All times are GMT - 5 Hours Goto page Previous1, 2
Page 2 of 2
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum