classmethod GetInfo(dsn As %String, infoType As %Integer, ByRef info As %String) as %Status [ Language = objectscript ]
Calls SQLGriverConnect and SQLGetInfo for the corresponding datasource;
dsn is the DSN, infoType is the info type
classmethod SQLDataSourcesClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLDataSourcesExecute(ByRef QHandle As %Binary, direction As %Integer) as %Status [ Language = objectscript ]
classmethod SQLDataSourcesFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLDataSourcesSortedClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLDataSourcesSortedExecute(ByRef QHandle As %Binary, direction As %Integer) as %Status [ Language = objectscript ]
classmethod SQLDataSourcesSortedFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLFieldsClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLFieldsExecute(ByRef QHandle As %Binary, dsn As %String, tname As %String, schema As %String, catalog As %String = "") as %Status [ Language = objectscript ]
classmethod SQLFieldsFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLFieldsJClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLFieldsJExecute(ByRef QHandle As %Binary, dsn As %String, tname As %String, schema As %String, catalog As %String = "") as %Status [ Language = objectscript ]
classmethod SQLFieldsJFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLForeignKeysClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLForeignKeysExecute(ByRef QHandle As %Binary, dsn As %String, tname As %String, catalog As %String = "") as %Status [ Language = objectscript ]
classmethod SQLForeignKeysFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLForeignKeysJClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLForeignKeysJExecute(ByRef QHandle As %Binary, dsn As %String, tname As %String, catalog As %String = "") as %Status [ Language = objectscript ]
classmethod SQLForeignKeysJFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLPrimaryKeysClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLPrimaryKeysExecute(ByRef QHandle As %Binary, dsn As %String, tname As %String, catalog As %String = "") as %Status [ Language = objectscript ]
classmethod SQLPrimaryKeysFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLPrimaryKeysJClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLPrimaryKeysJExecute(ByRef QHandle As %Binary, dsn As %String, tname As %String, catalog As %String = "") as %Status [ Language = objectscript ]
classmethod SQLPrimaryKeysJFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLProcedureColumnsClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLProcedureColumnsExecute(ByRef QHandle As %Binary, dsn As %String, schname As %String, procname As %String, catalog As %String = "") as %Status [ Language = objectscript ]
Get a List of all procedures
classmethod SQLProcedureColumnsFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLProcedureColumnsJClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLProcedureColumnsJExecute(ByRef QHandle As %Binary, dsn As %String, schname As %String, procname As %String, catalog As %String = "") as %Status [ Language = objectscript ]
classmethod SQLProcedureColumnsJFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLProceduresClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLProceduresExecute(ByRef QHandle As %Binary, dsn As %String, pname As %String, schname As %String = "", catalog As %String = "") as %Status [ Language = objectscript ]
classmethod SQLProceduresFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLProceduresJClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLProceduresJExecute(ByRef QHandle As %Binary, dsn As %String, pname As %String, schname As %String, catalog As %String = "") as %Status [ Language = objectscript ]
classmethod SQLProceduresJFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLSpecialColumnsClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLSpecialColumnsExecute(ByRef QHandle As %Binary, dsn As %String, tname As %String, catalog As %String = "") as %Status [ Language = objectscript ]
classmethod SQLSpecialColumnsFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLTablesClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLTablesExecute(ByRef QHandle As %Binary, dsn As %String, tname As %String = "", ttype As %String = "", schema As %String = "", catalog As %String = "") as %Status [ Language = objectscript ]
classmethod SQLTablesFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod SQLTablesJClose(QHandle As %Binary) as %Status [ Language = objectscript ]
classmethod SQLTablesJExecute(ByRef QHandle As %Binary, dsn As %String, tname As %String = "", ttype As %String = "", schema As %String = "", catalog As %String = "") as %Status [ Language = objectscript ]
classmethod SQLTablesJFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]
classmethod getIndexInfoClose(QHandle As %Binary) as %Status [ Language = objectscript ]
Get a List of all tables for an ODBC based SQL Gateway connection;
dsn is the SQLGateway connection name, tname is the string search pattern for table names,
schema is the string search pattern for schema names, ttype - list of table types to match
Get a List of all tables for a JDBC based SQL Gateway connection
dsn is the SQLGateway connection name, tname is the string search pattern for table names,
schema is the string search pattern for schema names, ttype - list of table types to match
Selects TABLE_CAT As %String(MAXLEN=128), TABLE_SCHEM As %String(MAXLEN=128), TABLE_NAME As %String(MAXLEN=128), NON_UNIQUE As %SmallInt, INDEX_QUALIFIER As %String(MAXLEN=128), INDEX_NAME As %String(MAXLEN=128), TYPE As %SmallInt, ORDINAL_POSITION As %SmallInt, COLUMN_NAME As %String(MAXLEN=128), ASC_OR_DESC As %String(MAXLEN=1), CARDINALITY As %Integer, PAGES As %Integer, FILTER_CONDITION As %String(MAXLEN=128)
Get a List of all indices in a table for a JDBC based SQL Gateway connection
dsn is the SQLGateway connection name, tname is the string search pattern for table names,
schema is the string search pattern for schema names