The methods in this class are used by the
Specify password for odbc database connection
Specify Cache Super Server Port for odbc database connection
Specify url for odbc database connection
Specify username for odbc database connection
Find or Add ODBC DSN dsn at System level
Add or verify Gateway Connection
- gcn Gateway Connection Name will be verified or added
- dsn if value passed in we will add it to gcn if missing, but will not verify it at lower level if you need to, call getODBCDSN first to create a dsn at the lower level and pass the name to this function
Return any errors found in log in fnderr list
Write ResultSet out to Stream If verbose=1 then also write column information to Stream with ResultSet space must be 1 for SQLRegression and SQLDataRegression to correctly process tuples in each resultset row.
Connect to ODBC and run SQL from sqlfilename in ANY namespace and return result as %Stream. ODBC DSN is dynamically created by modifying the built-in "User" DSN
Connect to ODBC and run SQL statement in ANY namespace and return result as %Stream. ODBC DSN and SQL Gateway Connection are created if they don't exist, or used if they do. DSN and Gateway name is "
" Username and Password can be passed as argument or as class parameter If verbose is 1 the column information is included in the resultset.