Capturing SQL

To examine the SQL produced by PS/nVision, capture the statements in one of two ways:

• Use the Options Trace option on the Excel menu.

  This causes PS/nVision to display each Select statement used for retrieving labels or amounts in a dialog. Select the text with the mouse, copy it to the clipboard, and paste the text into another application such as Notepad or a text editor. Then save the text to a file or work with it within the application.

  Note:

  If you want to capture the SQL but do not want to wait for it to execute, select the Excel Options Simulated Run option. PS/nVision generates all the SQL, but will not execute SELECTs for amounts.

• Select the PeopleTools SQL trace through the Utilities menu.

  This causes all SQL statements executed by PeopleTools to be written to a file called ~DBG0001.TMP in the Windows TEMP directory (often C:\TEMP). This trace shows timings, but does not include SQL that was not executed due to the Simulated Run option.