ZZUtils - ZZADACMD

Back in 1986 or so Joe Leighty of Colorado Gas distributed a utility program which listed ADABAS commands embedded in a Natural object module.  Thanks, Joe!  Like many other DBA's, I immediately enhanced, customized, and improved (?) this program, and have been using it ever since.

ZZADACMD interrogates catalogued Natural modules and displays imbedded ADABAS calls.  The display includes the module line number, ADABAS command code, ADABAS command description, ADABAS file number, and ADABAS file name.  Optionally the data base ID and search buffer contents may be displayed.  Natural does not provide the line number for all commands, such as END TRANSACTION.  In these cases ZZADACMD displays blanks.  The file name is retrieved from Predict using the file number.

The utility requests an application library name and a range of module names.  A blank end-of-range value defaults to the start-of-range value.  The report may be limited to a specific file number and/or a specific ADABAS command.

ZZADACMD may be executed on-line or in batch.  If in batch, a work file may be user-requested for further processing.  For example, reports may be produced by file number, file name, or descriptor.  See ZZADAR01 and ZZADAR02 for examples.

A sample selection screen and a sample detail report follow, or you can download a PowerPoint file of actual screen shots.


ZZADACMD Selection Screen:
 
 ZZADACMD Natural Utilities                                      98-02-28 14:49
          Natural Module ADABAS Command Analysis

     Required:               Library name: ZZUTIL__
                    Starting program name: ZZUTIL03
 

     Optional:        Ending program name: ________
                           ADABAS Command: __
                              ADABAS File: ___
                             DBID display: Y
                    Search Buffer display: Y
                                WORK file: N
 
 

          Commands reported:  A1/A4          L1/L2/L3/L4/L5/L6/L9
                              BT             N1/N2
                              E1/E4          RE
                              ET             S1/S2/S4/S8/S9

     PF3/PF15 Stop       PF11/PF23 Author
 

ZZADACMD Detail Screen:
 

 ZZADACMD Natural Utilities                                      98-02-28 14:49
          Natural Module ADABAS Command Analysis                       Page:  1
          Library: ZZUTIL    Programs: ZZUTIL03 - ZZUTIL03  Parms: ,0,Y,Y,N

 Program  Line ADABAS Command          File                      Search Buffer

 ZZUTIL03 4020 L3 Read Logical         255/  0 System/FUSER      LL,018,A.
          4890 S1 Find                 255/253 System/FDIC       AR,003,U.
                       -----  End of Command List  -----
 
 
 
 
 
 
 
 
 
 
 
 

 Press ENTER for a new selection or PF3/PF15 to Stop
 


ZZADACMD is in the object module section of ZZUtils, a collection of Natural utilities.

Return to top.

Return to Ralph G. Zbrog's home page.

Last updated November 18, 2001, by Ralph G. Zbrog.