TDAE75
Up

 

 

   Application Engine Analyzer
This useful utility is similar to SQR Analyzer. The user is prompted for the A/E program and the analysis begins. First a listing of the Cache record is produced, then each step is printed with all of its' attributes. An indented process flowchart is then generated illustrating the execution path of the process.
ftfsh01.jpg (9599 bytes) Click on the Tropical Fish to download the A/E Analyzer program. Below you will find sample output and a description of the A/E Analyzer user prompts.
   Note:
This utility was designed/developed using Oracle and SQLBase. In the future a platform-independent version will be posted but it's low on my list of priorities. Customize the program as necessary for incompatible databases.
   Revision (07/11/1999):
DB2 now supported. Outer joins with PSKEYDEFN removed (now called in separate SELECT). Subrecord support on cache record removed (since it's not allowed in A/E anyway). Also versions of A/E prior to 7.5 are supported. You must comment the substitution variable AE_75 to use (found in begin-setup section). When AE_75 commented out the SQR compiler will ignore references to the A/E columns AE_DO_PRODUCT and AE_DO_APPLID.

   Phase 1 - Produce Cache Record Listing
Report ID:  TD_AE75            APPLICATION ENGINE ANALYZER
    Phase:  1
  Program:  AR/PREDICT          Cache Record: PP_AET
================================================================================
Fieldname              Key     Type     Len     Dec     LongName
================================================================================

PROCESS_INSTANCE       Y       Nbr       10             Process Instance
OPRID                  N       Char       8             Operator Id
RUN_CNTL_ID            N       Char      30             Run Control ID
SETID                  N       Char       5             SetID
PP_METHOD              N       Char      15             Payment Predictor Method
EFFDT                  N       Date      10             Effective Date
PP_SEQ_NUM             N       Nbr        3             Sequence
PP_USAGE               N       Char       1             Usage
PP_SORT_SEQ_NUM        N       Nbr        3             Sorting Sequence number
               

   Phase 2 - A/E Steps and Attributes
Report ID:  TD_AE75            APPLICATION ENGINE ANALYZER
    Phase:  2
  Program:  AR/PREDICT
================================================================================
Section  Step      Do         Activity               Type Update Select DO_When
================================================================================

MAIN     INIT      INIT       (DO INIT)              D    N      N      N
MAIN     PREP      PREP       (DO PREP)              D    N      N      Y
MAIN     SBLD      SBLD       (DO SBLD)              D    N      N      Y
MAIN     UPDM      UPDM       (DO UPDM)              D    N      N      Y
MAIN     DOC_SEQ   DOCSEQ     (DO DOCSEQ)            D    N      N      N
MAIN     REALGAIN  REALGAIN   (DO REALGAIN)          D    N      N      N
MAIN     PGEN      PGEN       (DO PGEN)              D    N      N      Y
MAIN     PUPD      PUPD       (DO PUPD)              D    N      N      Y
MAIN     TERMINAT  TERMINAT   (DO TERMINAT)          D    N      N      N

DOC-CBL  FTPDOCAE             (COBOL: FTPDOCAE)      C    N      N      N

STEP     ALGR      #DETAIL    (DO &SECTION:#DETAIL)  D    N      N      Y
                                                           

   Phase 3 - Process Flowchart (Program Execution Path)
Report ID:  TD_AE75            APPLICATION ENGINE ANALYZER
    Phase:  3
  Program:  AR/PREDICT
================================================================================
Process Flow
================================================================================

 ....(MAIN.INIT)  (DO INIT)
 .........(INIT.STARTMSG)  (UPDATE)
 .........(INIT.ROUNDSET)  (SELECT)
 .........(INIT.ROUNDIN3)  (DO ROUNDIN3)
 ..............(ROUNDIN3.DECIMAL3)  (SELECT)
 .........(INIT.REQUESTS)  (UPDATE)
 .........(INIT.CNT)  (SELECT)
 .........(INIT.MSG)  (UPDATE)
 .........(INIT.NONE)  (DO MSG_NONE)
 ..............(MSG_NONE.MESSAGE)  (UPDATE)
 ....(MAIN.PREP)  (DO PREP)
 .........(PREP.CLEARTMP)  (DO CLEARTMP)
 ..............(CLEARTMP.PAYMENT)  (UPDATE)
 ..............(CLEARTMP.CUST)  (UPDATE)
 ..............(CLEARTMP.ITEM)  (UPDATE)
 ..............(CLEARTMP.ITEM2)  (UPDATE)
 ..............(CLEARTMP.MATCH)  (UPDATE)
 .........(PREP.MESSAGE)  (UPDATE)
 .........(PREP.PAYMENTS)  (UPDATE)
 .........(PREP.DOC_SEQ)  (UPDATE)
 .........(PREP.SET_REF)  (UPDATE)
 .........(PREP.ID_ITEM)  (DO ID_ITEM)
 ..............(ID_ITEM.CUSTMP1)  (UPDATE)
 ..............(ID_ITEM.DUPE1)  (DO DUPECUST)
 ...................(DUPECUST.DEL_DUPE)  (UPDATE)
 ...................(DUPECUST.COPYTMP2)  (UPDATE)
 ...................(DUPECUST.CLEANUP)  (UPDATE)
 ..............(ID_ITEM.CUSTMP2)  (UPDATE)
 ..............(ID_ITEM.DUPE2)  (DO DUPECUST)     <Repeated Section>
                                                           
   Notice handling of Dynamic Sections (&SECTION)

 ..............(STEP.ALGR)  (DO &SECTION:#DETAIL)
 ...................(#DETAIL.ALGO_1)  (SELECT)
 ...................(#DETAIL.ADJUST)  (DO ADJUST)
 ........................(ADJUST.INIT)  (UPDATE)
 ........................(ADJUST.ADJ_OVER)  (UPDATE)
 ........................(ADJUST.ADJ_UNDR)  (UPDATE)
 ........................(ADJUST.NAMEOVER)  (DO AUTO_ADJ)     <Repeated Section>
 ........................(ADJUST.NAMEUNDR)  (DO AUTO_ADJ)     <Repeated Section>
 ........................(ADJUST.COPYTMP2)  (DO COPYTMP2)     <Repeated Section>
 ...................(#DETAIL.MATCHTMP)  (UPDATE)
 ...................(#DETAIL.ALGR_B1)  (DO DUPES)
 ........................(DUPES.DUPES)  (DO ALGR_DUP)
 .............................(ALGR_DUP.GET_ONE)  (SELECT)
 .............................(ALGR_DUP.DEL_REST)  (UPDATE)
 ...................(#DETAIL.ALGR_C1)  (DO PYSTATUS)
               
   COBOL and Mass Change programs are identified

 ....(MAIN.DOC_SEQ)  (DO DOCSEQ)
 .........(DOCSEQ.DOC_SEQ)  (DO DOC_SEQ)
 ..............(DOC_SEQ.CHK_SEQ)  (DO DOC-CBL)
 ...................(DOC-CBL.FTPDOCAE)  (COBOL: FTPDOCAE)
 ..............(DOC_SEQ.SETID)  (SELECT)
 ..............(DOC_SEQ.GET_TYPE)  (SELECT)
 ..............(DOC_SEQ.UPD_BU)  (UPDATE)
 ..............(DOC_SEQ.GET_SEQ)  (DO DOC-CBL)     <Repeated Section>
 ....(MAIN.REALGAIN)  (DO REALGAIN)
               

   Sample SQR Screen
tdae75.jpg (23666 bytes)

   User Prompts

Enter Product:

        Enter the Product (AR, PO, AP, etc)

Enter Appl ID:

        Enter the Application Name (PREDICT, POBUILD, etc)

Enter DB Platform <or ENTER>:

        Will cause DB Platform specific statements to be used.

Create A/E Statement File? (Y/N):

        Generates Text file with statements in execution order.

        Import into Word, format and print!

Enter Dynamic DO Section (&SECTION):

        Whenever symbolic &SECTION encountered this prompt appears.

        You can then include the Dynamic Section you are using.

   Feedback
ftoct01.jpg (12389 bytes) I would appreciate any feedback you may have on this site. Send mail to tdelia@erols.com or click on the Octopus.
   Technical difficulties?
pg003.jpg (33446 bytes) Please report any technical difficulties you may encounter to the address above OR click on the Octopus. Thanks.

Tony DeLia - Updated July 11, 1999