https://community.hpe.com/t5/operating-system-openvms/dtr-midification-suggestions-please/m-p/4536154#M43168 I am using DTR for querying the records <BR /><BR />The file that I am using is of 1536 bytes length and the copybook associated with that file is having header and detail records<BR />(means Detail records are redefined by header records by redefines clause) <BR />so if I am querying the first 10 records with alt-key-type = "4" and it is displaying both the header and detail records <BR />and If I modify all the queried records with a Header field then the detail records are also getting modified. <BR />I dont know why this is happening I can filter the detail and header records separately for querying but <BR />My doubt is that DTR cannot handle these type of false changes <BR />since it will effect mostly in the testing process.<BR />Is there any other way? <BR />and I am using cobol programs for execution<BR /> Wed, 18 Nov 2009 14:57:18 GMT RAVI KISHORE_1 2009-11-18T14:57:18Z https://community.hpe.com/t5/operating-system-openvms/dtr-midification-suggestions-please/m-p/4536154#M43168 I am using DTR for querying the records <BR /><BR />The file that I am using is of 1536 bytes length and the copybook associated with that file is having header and detail records<BR />(means Detail records are redefined by header records by redefines clause) <BR />so if I am querying the first 10 records with alt-key-type = "4" and it is displaying both the header and detail records <BR />and If I modify all the queried records with a Header field then the detail records are also getting modified. <BR />I dont know why this is happening I can filter the detail and header records separately for querying but <BR />My doubt is that DTR cannot handle these type of false changes <BR />since it will effect mostly in the testing process.<BR />Is there any other way? <BR />and I am using cobol programs for execution<BR /> Wed, 18 Nov 2009 14:57:18 GMT https://community.hpe.com/t5/operating-system-openvms/dtr-midification-suggestions-please/m-p/4536154#M43168 RAVI KISHORE_1 2009-11-18T14:57:18Z https://community.hpe.com/t5/operating-system-openvms/dtr-midification-suggestions-please/m-p/4536155#M43169 You have to find a field (column) in there that allows you to distinguish unambiguously which record is a header, which one a detail.<BR /><BR />For example, there might be a line number which is 0 for the header. In that case your query should be modified to include a selection clause on that column.<BR /><BR />That may look like:<BR /><BR />MODIFY xxx WITH alt-key-type=4 AND line-number=0 USING BEGIN ...<BR /><BR /><BR />If there are no distinguisng columns, only the order, then you may need you nest your queries, selecting the first records first<BR /><BR />FOR FIRST 1 xxx WITH ..<BR /> IF alt-key-type=4 THEN MODIFY ...<BR /><BR />or <BR />FOR outer IN xxx WITH alt-key-type=4 <BR /> FOR FIRST 1 inner IN xxx MODIFY ...<BR /><BR />The presence of RMS keys, total record counts, selected record counts will determine which approach is best.<BR /><BR />For further help you probably need to show us some critical columns (4 o 5) from some (2 or 3 ) example data records, perhaps in a .TXT attachment.<BR />Maybe add output from SHOW xxx_REC ... or at least the first part of that showing the redefine.<BR />Maybe add some record count indication and rms key/index pointers.<BR /><BR />The record bytes length, the only detail you provided so far, is in fact the least interesting attribute of the file!<BR /><BR />Hope this helps some,<BR /><BR />Hein.<BR /><BR /><BR /> Wed, 18 Nov 2009 16:05:08 GMT https://community.hpe.com/t5/operating-system-openvms/dtr-midification-suggestions-please/m-p/4536155#M43169 Hein van den Heuvel 2009-11-18T16:05:08Z