Jump to content

- - - - -

SQL with SEL-ONLY in superlayer functions

1 reply to this topic

#1 Dustin Jorgesen

Dustin Jorgesen


  • Members
  • PipPip
  • 12 posts
  • Gender:Male
  • Location:Lakeland, United States

Posted 20 January 2003 - 10:05 PM

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?


#2 Rob Donovan

Rob Donovan


  • Admin
  • 1,647 posts
  • Gender:Male
  • Location:Spain

Posted 22 January 2003 - 04:31 AM


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