TDM-how to work with datasets extracted from IMS
search cancel

TDM-how to work with datasets extracted from IMS


Article ID: 186547


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


When using ordered (hierarchical/IMS) input files, the child SYSRECxx.DAT files from GTXTMT contain extra data, causing the BCP to fail.


Steps I did:

  1. Mocked up copybook , making all fields PIC X , just for simplicity in editing – the datatypes are irrelevant to this issue.
  2. Mocked up some data on mainframe, with 3 parent rows, each with 1 child row of each type.
  3. Use File Definition Manager, from 5.4.18 ( (same as 5.4.17),  and described the layout of the file;  I made up data for the segment identifying values as seen in pictures below.  Important – include the PARENT identifier on SEG2 and SEG3, to point to SEG1 as parent.
  4. SEG1 – identified by string “IAMROOT”  in first field. Parent record field is left blank, as this is the root/parent segment.


Release : 4.8

Component : CA Test Data Manager


Workaround:  Modify the generated control file.

 There were 2 options – change the data to remove the extra data, or change the BCP to ignore the extra data.  Changing the BCP format file was 100x easier than trying to mess with data.