Page 1 of 1

Area Sweeps & Eztrieve

PostPosted: Fri May 06, 2011 8:00 pm
by madmartinson
hi,
New to EZT here. I am being asked to use EZT to get several fields from an area of the IDMS DB for cross validation (counts, amts, subtotals etc.) from the MF into another system. I have convinced the boss that it would be a grand idea to get the whole record and its many to many relationships because everybody knows they will want something else to make them and their cronies look less confused or maybe even competant. In the past i wrote area sweeps to accomplish this but security is a mess and apparently EZT is the ticket out.

So, question is, is there a Utility under EZT or some open ended program where you indicate the schema, sub schema, area that you want and request or set a flag that indicates 'gimme it all Dood' ?
thanks. :lol:

Re: Area Sweeps & Eztrieve

PostPosted: Fri May 06, 2011 8:35 pm
by Robert Sample
Google is your friend. Googling easytrieve idms returns 20,500 hits and one on the very first page references the interface manual you need to find and read.

Re: Area Sweeps & Eztrieve

PostPosted: Fri May 06, 2011 10:22 pm
by madmartinson
great. turns out right after i hung up the phone ( as always it seems ) I found this on site.

//STEP010 EXEC PROC=EZTIDMSL,ENVNODE='.QA',       
//             MEMB='NSCQDICT',SYST=51             
//*                                               
-  -  -  -  -  -  -  -  -  -  -  -  -  -  -  - 99 L
*========================                         
*                                                 
*------------------------                         
 OBTAIN-FIRST-OPEN-ITEM. PROC                     
*------------------------                         
 IDMS OBTAIN FIRST RECORD 'OPEN-ORDER-ITEMS' +     
                     AREA 'MTLM-OPNORD-REG'       
 IF IDMSSTATUS NE WS-IDMS-SUCCESSFUL               
    DISPLAY 'FIRST OBTAIN ERROR'                   
 END-IF                                           
 PERFORM IDMS-STATUS-CHECK                         
*                                                 
 END-PROC                                         


it is all the same as before but under EZT. Thanks for reply Sir Robert. Be back soon.