Am using TDM 4.7 , and trying to subset some files extracted from IMS as flat files.
The data set I am reading has multiple record types in it.
I have the copybooks and I can extract single records for one segment type, but I want to output all segments belonging to some set of keys, and i can't figure out how to do it.
example
suppose seg1 is a customer segment, seg2 is address , and seg3 is phone
And suppose in this 'data' below, the first field is a key, this would be like what's in my data file
eg: key custname custtype flag flag code (pseudo copybook for SEG1)
seg1: foo1 Foo Barrett IND Y Y 123
seg2: foo1 555 main st anywhere UT
seg3: foo1 555-1212
seg1: bus1 testdata.com BUS Y Y 444
seg2: bus1 1066 Testing St. anywhere VA
seg3: bus1 555-5555
seg1: abc3 Any Customer IND Y Y 123
seg2: abc3 222 main st anywhere UT
seg3: abc3 555-2222
Suppose i want to only extract data for cases where the custtype value in seg1 is 'IND' .
My desired output file would have all 3 segments for key foo1 and abc3, but not the ones for bus1.
So far I can get all the seg1 rows output for all custtypes, OR all the seg1 for IND , but not seg1,2&3 for IND.
Reading the docs, maybe I need to use the SUBSETLIST functions, but I can't find any info how to use those functions and how to populate the GTSCR_SUBSET table in DB2. Or maybe this is totally wrong path.
Just need some guidance, thanks