To use pass-through SQL from within sanScript, you must create a pass-through SQL connection. Before you can do this, your application must be logged in to a SQL data source. Then you will use the SQL_Connect() function to create the pass-through SQL connection. The login information for the current SQL login will be used for the new pass-through SQL connection.
A pass-through SQL connection is used only for executing SQL statements from sanScript. It is completely separate from the other connections used by Dexterity to access SQL data.
A pass-through SQL connection remains active until you use the SQL_Terminate() function to terminate it. Creating a pass-through SQL connection can take a significant amount of time, so to optimize performance, you may want to create a connection, leave it open until you have finished executing SQL statements, then terminate it.