Capture of PS/nVision SQL

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

• Use the Show Report SQL option in the PeopleSoft nVision Options dialog box. This option causes PS/nVision to display each Select statement used to retrieve labels or amounts in a dialog box. You can select the text with the mouse, then copy (CTRL+C) it to the Clipboard, then paste (CTRL+V) the text into another application, such as Notepad, WordPad, an interactive SQL tool, or a text editor. You can then save the text to a file or work with it within the application.

  Note:

  To capture the SQL without waiting for it to execute, you can also select the Suppress Amount Retrieval option. PS/nVision generates all the SQL but does not execute Select statements for amounts.

• Turn on the PeopleTools SQL trace through the Trace tab on the Configuration Manager. The SQL statements executed by PeopleTools will be written to a file that you specify.