Customer unable to do Foreground DB2 Binds within ENDEVOR

Document ID : KB000098959
Last Modified Date : 19/07/2018
Show Technical Document Details
Question:
How do I perform a generate with DB2 bind under foreground Endevor, and display the bind commands to screen and save them in a listing ?

Batch runs fine and the bind commands are saved to file.

Under foreground, I can either display the bind commands to screen or save them in a listing. Is there a way I can both display and save them ? 
Answer:
One way to do this is to use the DSN trace stream. You invoke the trace stream using the DSNTRACE ddname in your CLIST or REXX used in the bind step (BC1PTMP0) in your Endevor processor.

Please see the IBM DB2 documentaion for valid DB2 bind syntax with DSN tracing. 
Additional Information:
See CA Endevor Administoring Processors : 
https://docops.ca.com/ca-endevor-SCM/18-0/en/administrating/processors