Generating xls from PeopleCode

You can generate xml in a format that MS Excel will recognise. Refer to the files below.



Refer to http://sourceforge.net/projects/sqr2xml for the original files etc

App Engine & Cobol trace

AE Process Definition - Override options tab
-TRACE 7 -TOOLSTRACEPC 3596 -TOOLSTRACESQL 131 (review peoplebooks on which tracing values you need to place)

Cobol SQL Process Type
.. for the platform you are running on. Enter 255 in the command line field between two forward slashes “//”.
i.e. %%PRCSNAME%% %%DBTYPE%%/%%DBNAME%%/%%OPRID%%/%%OPRPSWD%%/%%RUNCNTLID%%/%%INSTANCE%%/255/%%DBFLAG%%