Area Sweeps & Eztrieve



Unicenter CA-Easytrieve Plus Report Generator: CA's information retrieval and data management tool

Area Sweeps & Eztrieve

Postby madmartinson » Fri May 06, 2011 8:00 pm

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:
madmartinson
 
Posts: 3
Joined: Thu Dec 09, 2010 9:08 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Area Sweeps & Eztrieve

 

Re: Area Sweeps & Eztrieve

Postby Robert Sample » Fri May 06, 2011 8:35 pm

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.
Robert Sample
Global moderator
 
Posts: 3649
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 268 times

Re: Area Sweeps & Eztrieve

Postby madmartinson » Fri May 06, 2011 10:22 pm

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.
madmartinson
 
Posts: 3
Joined: Thu Dec 09, 2010 9:08 pm
Has thanked: 0 time
Been thanked: 0 time


Return to CA-Easytrieve

 


  • Related topics
    Replies
    Views
    Last post