%Library.GTWCatalog

class %Library.GTWCatalog

Gateway Catalog Queries

Method Inventory

Methods

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 ]
classmethod getIndexInfoExecute(ByRef QHandle As %Binary, dsn As %String, tname As %String, schema As %String, nonunique As %Boolean, approximate As %Boolean = "", catalog As %String = "") as %Status [ Language = objectscript ]
classmethod getIndexInfoFetch(ByRef QHandle As %Binary, ByRef Row As %List, AtEnd As %Integer) as %Status [ Language = objectscript ]

Queries

query SQLDataSources(direction As %Integer)
Selects DSN As %String, DESCRIPTION As %String
return list of ODBC datasources

direction could be one of the following: SQL_FETCH_NEXT 1 SQL_FETCH_FIRST 2 SQL_FETCH_FIRST_USER 31 SQL_FETCH_FIRST_SYSTEM 32

query SQLDataSourcesSorted(direction As %Integer)
Selects DSN As %String, DESCRIPTION As %String
return list of ODBC datasources, lexicographically sorted

direction could be one of the following: SQL_FETCH_NEXT 1 SQL_FETCH_FIRST 2 SQL_FETCH_FIRST_USER 31 SQL_FETCH_FIRST_SYSTEM 32

query SQLFields(dsn As %String, tname As %String, schema As %String, catalog As %String = "")
Selects CATALOG_NAME As %String, SCHEMA_NAME As %String, TABLE_NAME As %String, COLUMN_NAME As %String, DATATYPE As %Integer, DATATYPE_NAME As %String, COLUMN_SIZE As %Integer, DECIMAL_DIGITS As %Integer, NULLABLE As %String, REMARKS As %String, SUPPORTED As %Boolean, SQLCOLUMNNUMBER As %Integer
Get a List of all Fields from a table 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

query SQLFieldsJ(dsn As %String, tname As %String, schema As %String, catalog As %String = "")
Selects CATALOG_NAME As %String, SCHEMA_NAME As %String, TABLE_NAME As %String, COLUMN_NAME As %String, DATATYPE As %Integer, DATATYPE_NAME As %String, COLUMN_SIZE As %Integer, DECIMAL_DIGITS As %Integer, NULLABLE As %String, REMARKS As %String, COLUMN_DEF As %String, SUPPORTED As %Boolean, SQLCOLUMNNUMBER As %Integer
Get a List of all fields 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

query SQLForeignKeys(dsn As %String, tname As %String, catalog As %String = "")
Selects PKTABLE_CAT As %String, PKTABLE_SCHEM As %String, PKTABLE_NAME As %String, PKCOLUMN_NAME As %String, FKTABLE_CAT As %String, FKTABLE_SCHEM As %String, FKTABLE_NAME As %String, FKCOLUMN_NAME As %String, KEY_SEQ As %Integer, UPDATE_RULE As %Integer, DELETE_RULE As %Integer, FK_NAME As %String, PK_NAME As %String
Get a List of foreign keys for an ODBC based SQL Gateway connection

dsn is the SQLGateway connection name, tname is the table name in the format SCHEMA_NAME.TABLE_NAME

query SQLForeignKeysJ(dsn As %String, tname As %String, catalog As %String = "")
Selects PKTABLE_CAT As %String, PKTABLE_SCHEM As %String, PKTABLE_NAME As %String, PKCOLUMN_NAME As %String, FKTABLE_CAT As %String, FKTABLE_SCHEM As %String, FKTABLE_NAME As %String, FKCOLUMN_NAME As %String, KEY_SEQ As %Integer, UPDATE_RULE As %Integer, DELETE_RULE As %Integer, FK_NAME As %String, PK_NAME As %String
Get a List of foreign keys for an JDBC based SQL Gateway connection

dsn is the SQLGateway connection name, tname is the table name in the format SCHEMA_NAME.TABLE_NAME

query SQLPrimaryKeys(dsn As %String, tname As %String, catalog As %String = "")
Selects CATALOG_NAME As %String, SCHEMA_NAME As %String, TABLE_NAME As %String, COLUMN_NAME As %String, KE_SEQ As %Integer, PK_NAME As %String
Get a List of primary keys for an ODBC based SQL Gateway connection

dsn is the SQLGateway connection name, tname is the table name in the format SCHEMA_NAME.TABLE_NAME

query SQLPrimaryKeysJ(dsn As %String, tname As %String, catalog As %String = "")
Selects CATALOG_NAME As %String, SCHEMA_NAME As %String, TABLE_NAME As %String, COLUMN_NAME As %String, KE_SEQ As %Integer, PK_NAME As %String
Get a List of primary keys for a JDBC based SQL Gateway connection

dsn is the SQLGateway connection name, tname is the table name in the format SCHEMA_NAME.TABLE_NAME

query SQLProcedureColumns(dsn As %String, schname As %String, procname As %String, catalog As %String = "")
Selects CATALOG_NAME As %String, SCHEMA_NAME As %String, PROC_NAME As %String, COL_NAME As %String, COL_TYPE As %Integer, DATA_TYPE As %Integer, TYPE_NAME As %String, COL_SIZE As %Integer, DEC_DIGITS As %Integer, RADIX As %Integer, NULLABLE As %Integer, REMARKS As %String, SUPPORTED As %Boolean
return a list of the procedure columns for an ODBC based SQL Gateway connection

dsn is the SQLGateway connection name, procname is the string search pattern for procedure names, schema is the string search pattern for schema names

query SQLProcedureColumnsJ(dsn As %String, schname As %String, procname As %String, catalog As %String = "")
Selects CATALOG_NAME As %String, SCHEMA_NAME As %String, PROC_NAME As %String, COL_NAME As %String, COL_TYPE As %Integer, DATA_TYPE As %Integer, TYPE_NAME As %String, COL_SIZE As %Integer, DEC_DIGITS As %Integer, RADIX As %Integer, NULLABLE As %Integer, REMARKS As %String, COLUMN_DEF As %String, SUPPORTED As %Boolean
return a list of the procedure columns for a JDBC based SQL Gateway connection

dsn is the SQLGateway connection name, procname is the string search pattern for procedure names, schema is the string search pattern for schema names

query SQLProcedures(dsn As %String, pname As %String, schname As %String, catalog As %String = "")
Selects CATALOG_NAME As %String, SCHEMA_NAME As %String, PROC_NAME As %String, PROC_TYPE As %Integer, REMARKS As %String
Get a List of all procedures for an ODBC based SQL Gateway connection

dsn is the SQLGateway connection name, pname is the string search pattern for procedure names, schema is the string search pattern for schema names

query SQLProceduresJ(dsn As %String, pname As %String, schname As %String, catalog As %String = "")
Selects CATALOG_NAME As %String, SCHEMA_NAME As %String, PROC_NAME As %String, PROC_TYPE As %Integer, REMARKS As %String
Get a List of all procedures for a JDBC based SQL Gateway connection

dsn is the SQLGateway connection name, pname is the string search pattern for procedure names, schema is the string search pattern for schema names

query SQLSpecialColumns(dsn As %String, tname As %String, catalog As %String = "")
Selects SCOPE As %Integer, DATATYPE As %Integer, TYPE_NAME As %String, COLUMN_SIZE As %Integer, BUFFER_LENGTH As %Integer, DECIMAL_DIGITS As %Integer, PSEUDO_COLUMN As %Integer, UPDATE_RULE As %Integer
Get a List of special columns for an ODBC based SQL Gateway connection

dsn is the SQLGateway connection name, tname is the table name in the format SCHEMA_NAME.TABLE_NAME

query SQLTables(dsn As %String, tname As %String = "", ttype As %String = "", schema As %String = "", catalog As %String = "")
Selects CATALOG_NAME As %String, SCHEMA_NAME As %String, TABLE_NAME As %String, TABLE_TYPE As %String, REMARKS As %String
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

query SQLTablesJ(dsn As %String, tname As %String, ttype As %String, schema As %String, catalog As %String = "")
Selects CATALOG_NAME As %String, SCHEMA_NAME As %String, TABLE_NAME As %String, TABLE_TYPE As %String, REMARKS As %String
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

query getIndexInfo(dsn As %String, tname As %String, schema As %String, nonunique As %SmallInt, catalog As %String = "")
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

Feedback