|
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. |
 |
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. |
| 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. |
| 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)
|
 | 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.
 |
I would appreciate any feedback you may have on this site.
Send mail to tdelia@erols.com or click on the
Octopus. |
 |
Please report any technical difficulties you may encounter to the address
above OR click on the Octopus. Thanks. |
Tony DeLia - Updated July 11, 1999
| 
