Jump to content


Photo
- - - - -

SQL with SEL-ONLY in superlayer functions


1 reply to this topic

#1 Dustin Jorgesen

Dustin Jorgesen

    Member

  • 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?

Dustin

#2 Rob Donovan

Rob Donovan

    rob@proivrc.com

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

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.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users