In a superlayer function where you are dealing with an oracle table and you do not use an sql command to select records(using a command inside a SQL ENDSQL block) how does superlayer get the records. Is there anyway to see the sql command that is run to select records?
Dustin
SQL with SEL-ONLY in superlayer functions
Started by Dustin Jorgesen, Jan 20 2003 10:05 PM
1 reply to this topic
#2
Posted 22 January 2003 - 04:31 AM
Hi,
There are 2 traces you can do to get the SQL.
TRACESQL or SQL_DEBUG (unix env vars)
Do a search on posts for this text and there is a post on the 08/05/01 headed 'SQL statement' that explains how to use them.
Rob D.
There are 2 traces you can do to get the SQL.
TRACESQL or SQL_DEBUG (unix env vars)
Do a search on posts for this text and there is a post on the 08/05/01 headed 'SQL statement' that explains how to use them.
Rob D.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users