Re: Application Engine

[Tony DeLia <tdelia@EROLS.COM>]

John,
   If your goal is to view the temp tables you can prevent the tables
from being deleted yourself. Some processes have a switch that disables
the delete step... usually under the business rule definition... OR you
can disable the delete step yourself... just set the statement type to
'Comment' temporarily... it's similar to an SQR program... after your
analysis change it back... You can force an abend at the point you wish
also and look at the results up to that point... of course that's the
simplified version... ALSO I created an Application Engine Analyzer a
while back but haven't had time to customize for 'all databases'...
Currently it's for Oracle and SQLBase... it's similar to my SQR Analyzer
and Wayne Ivory's SQR Tree... You can see a preview at my new site:
http://www.sqrtools.com

                      Tony DeLia

PS - A/E is a pretty neat tool (technically speaking)... For large
processes (AR Update, Payment Predictor, etc) it's cumbersome and
difficult to maintain (and was a poor choice by PeopleSoft)... plus any
modifications cannot be upgraded easily (no-brainer)... One of the
biggest complaints about A/E is that it can't handle File I/O... But...
custom functions could be added easily... I may add a &FILE function...

John Ferguson wrote:
>
> Does anyone know of an SQR that will print out an Application Engine
> application. I am new to App. Engine and would like to see what it is
> doing behind the scenes.  I know that it is all SQL based and that it
> creates tmp tables for it's data handling but when it done it deletes
> the the tmp tables and I would like to be able to see the data.
>
> If anyone could assist me with this I would be grateful.
>
> Thanks,
>
> John Ferguson

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com
http://www.sqrtools.com