The SQL Procedure Pass-Through Facility is an extension of the SQL procedure that enables you to send DBMS-specific statements to a DBMS and to retrieve DBMS data. You specify DBMS SQL syntax instead ...

We have a server with full text searching enabled and another where it is not. We have a stored proc that checks if full text indexing is enabled and runs a search query as appropriate but the issue ...

The RESET statement enables you to add, drop, or change the options in PROC SQL without restarting the procedure. See PROC SQL Statement for a description of the options.