public class Db2Metadata extends JdbcMetadata
JdbcMetadata.DbMetadata
Modifier and Type | Field and Description |
---|---|
protected static Map<String,String> |
DB2_METADATA_METHODS
The DB2 metadata methods.
|
protected static Map<String,String> |
DB2_TYPE_SUPPORT_AS_TEXT
The DB2 object types which support asText.
|
protected static Map<String,String> |
DB2_TYPE_SUPPORT_EXECUTE_AS_TEXT
The db2 type support execute as text map.
|
protected static Map<String,String> |
DB2_TYPES_BY_PARENT
The DB2 types by parent.
|
ALLOWED_FOR_SCHEMA_CATALOG, ALLOWED_FOR_TABLE, ALLOWED_TOP_LEVEL, METADATA_METHODS, TYPE_METHODS, TYPE_SUPPORT_AS_TEXT, TYPE_SUPPORT_DROP_AS_TEXT, TYPES_BY_PARENT
TYPES_SUPPORT_REFRESH
ALL_REFS, ALL_TYPES, BASE_CLASS_PATH, DB_DELIMITER, DEFAULT_METHOD, DEFAULT_TYPE, ID_FIELD, METADATA_DELIMITER, SYNONYMS_DATASET_TYPE, TABLE_PRIV, TABLE_PRIVS, TABLES_DATASET_TYPE, TYPE_ALIAS, TYPE_ALIASES, TYPE_ASSEMBLIES, TYPE_ASSEMBLY, TYPE_CATALOG, TYPE_CLASS, TYPE_COLUMN, TYPE_COLUMNS, TYPE_CONSTRAINTS, TYPE_DATA_SET, TYPE_DB_LINK, TYPE_DB_LINKS, TYPE_DBFUNCT, TYPE_DBFUNCTIONS, TYPE_DBINFO, TYPE_DBPROP, TYPE_DBPROPS, TYPE_DIRECTORIES, TYPE_DIRECTORY, TYPE_EK, TYPE_EK_COLUMN, TYPE_EK_COLUMNS, TYPE_EKS, TYPE_EXEC_METHOD, TYPE_EXEC_METHODS, TYPE_FILE, TYPE_FK, TYPE_FK_COLUMN, TYPE_FK_COLUMNS, TYPE_FKS, TYPE_FUNCT, TYPE_FUNCT_PARAMETERS, TYPE_FUNCTS, TYPE_GLOBAL_TEMPORARIES, TYPE_INDEX, TYPE_INDEX_COLUMN, TYPE_INDEX_COLUMNS, TYPE_INDEXES, TYPE_JAVA_CLASSES, TYPE_LOCAL_TEMPORARIES, TYPE_NICKNAME, TYPE_PACKAGE, TYPE_PACKAGE_BODY, TYPE_PACKAGES, TYPE_PARAMETER, TYPE_PARAMETERS, TYPE_PK, TYPE_PK_COLUMN, TYPE_PK_COLUMNS, TYPE_PKS, TYPE_PROC, TYPE_PROC_PARAMETERS, TYPE_PROCS, TYPE_PROCS_FUNCS, TYPE_QUEUE, TYPE_QUEUE_TABLE, TYPE_QUEUE_TABLES, TYPE_QUEUES, TYPE_RECYCLE_BIN, TYPE_RECYCLE_BIN_ITEM, TYPE_SCHEMA, TYPE_SEQUENCE, TYPE_SEQUENCES, TYPE_SYNONYM, TYPE_SYNONYMS, TYPE_SYSTEM_TABLES, TYPE_SYSTEM_VIEWS, TYPE_TABLE, TYPE_TABLES, TYPE_TEMPORARY_TABLES, TYPE_TEMPORARY_VIEWS, TYPE_TRIGGER, TYPE_TRIGGERS, TYPE_TYPE, TYPE_TYPES, TYPE_USER_TYPE, TYPE_USER_TYPES, TYPE_VIEW, TYPE_VIEWS, TYPE_WORKSHEET, TYPE_WORKSHEETS, TYPE_XML_SCHEMA, TYPE_XML_SCHEMAS, VIEWS_DATASET_TYPE
APP, COMMAND, ETL_DRIVER, FORMATTER, IDE_NODE, NO_RANK, WIDGET
Constructor and Description |
---|
Db2Metadata() |
Modifier and Type | Method and Description |
---|---|
String |
asTextMethod(String type)
asText method name for the type.
|
String |
executeAsText(String catalog,
String schema,
String pattern,
String type,
String metadataId)
Shows object execute SQL.
|
DataSet |
getConstraints(String catalog,
String schema,
String pattern,
String type)
Gets table constraints.
|
static String |
getConstraintType(Object type)
Gets the constraint type.
|
List<String> |
getDbObjectTypes()
Gets the database object types.
|
String |
getDropFunctionAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop function SQL.
|
String |
getDropPackageAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop package SQL.
|
String |
getDropProcAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop procedure SQL.
|
DataSet |
getFunctParameters(String catalog,
String schema,
String pattern,
String type)
Gets the function parameters.
|
DataSet |
getFuncts(String catalog,
String schema,
String pattern,
String type)
Gets the functions.
|
DataSet |
getIndexColumns(String catalog,
String schema,
String pattern,
String type)
Gets the index columns.
|
String |
getLicensePropertyName()
Gets the name of the license property.
|
Map<String,String> |
getMetadataMethods()
Gets the metadata methods.
|
String |
getName()
Gets the name.
|
KeyValue[] |
getObjectTypes()
Gets the object types.
|
String |
getPackageAsText(String catalog,
String schema,
String pattern,
String type)
Gets the package as text.
|
DataSet |
getPackages(String catalog,
String schema,
String pattern,
String type)
Gets the packages.
|
String |
getProcAsText(String catalog,
String schema,
String pattern,
String type)
Gets the procedure as text.
|
DataSet |
getProcParameters(String catalog,
String schema,
String pattern,
String type)
Gets the procedure parameters.
|
DataSet |
getProcs(String catalog,
String schema,
String pattern,
String type)
Gets the procedures.
|
DataSet |
getSequences(String catalog,
String schema,
String pattern,
String type)
Gets the sequences.
|
DataSet |
getTableIndexes(String catalog,
String schema,
String pattern,
String type)
Gets the table indexes.
|
List<String> |
getTableMetadataTypes()
Gets the table metadata types.
|
DataSet |
getTablesByType(String catalog,
String schema,
String pattern,
String type)
Gets the tables by type.
|
String |
getTriggerAsText(String catalog,
String schema,
String pattern,
String type)
Gets the trigger as text.
|
DataSet |
getTriggers(String catalog,
String schema,
String pattern,
String type)
Gets the triggers.
|
Map<String,String> |
getTypesByParent()
Gets the types by parent.
|
DataSet |
getUserTypes(String catalog,
String schema,
String pattern,
String type)
Gets the user defined types.
|
String |
getViewAsText(String catalog,
String schema,
String pattern,
String type)
Gets the view as text.
|
DataSet |
getXmlSchemas(String catalog,
String schema,
String pattern,
String type)
Gets the xml schemas.
|
DataSet |
searchDatabase(DatabaseFilter filter)
Search database objects.
|
boolean |
supportsAsText(String type)
Checks if metadata driver supports asText method for the type.
|
boolean |
supportsExecute(String type)
Checks if metadata driver supports executeAsText method for the type.
|
boolean |
supportsSearchDatabase()
Checks if metadata driver supports search database.
|
allowNotDefault, asText, chooseBestIndex, createAsText, discoverDatabaseTypes, dropAsText, dropAsTextMethod, free, getAllowedSchema, getAllRefs, getCatalogs, getCatalogSchemaAndPattern, getCatalogSchemaMetadataAllowed, getDbFunctions, getDbInfoObjects, getDbMetadata, getDbObjectsByWildcard, getDbProps, getDeleteRule, getDropAliasAsText, getDropAssemblyAsText, getDropDbLinkAsText, getDropIndexAsText, getDropSequenceAsText, getDropSynonymAsText, getDropTableAsText, getDropTriggerAsText, getDropTypeAsText, getDropViewAsText, getEKColumns, getEKMetadataTypes, getFKColumns, getFkDefinitionAsText, getFKMetadataTypes, getFksAsText, getFuncParamNameForNull, getFuncParamType, getFuncRetType, getFunctMetadataTypes, getIndexDefinitionAsText, getIndexesAsText, getIndexMetadataTypes, getOwners, getParameters, getPkAsText, getPKColumns, getPKMetadataTypes, getProcMetadataTypes, getProcsRetType, getSchemas, getSuggestedKeyFields, getTableAsText, getTableColumns, getTableEKs, getTableEKs, getTableFKs, getTableMetadataAllowed, getTableNameAsText, getTablePKs, getTablePrivs, getTableTypes, getTopLevelAllowed, getTopLevelDbObjects, getTransIsolation, getTypeByTypeFieldValue, getTypeField, getTypeMethods, getTypes, getUpdateRule, getVendor, getVersion, getViewMetadataTypes, isOutParam, isUnique, needToPopulate, populateTables, supportsDrop
compareTo, getColumns, getConfigFileName, getConnectionFactory, getConnectionParamsProvider, getCurrentDatabase, getDefaultColumns, getDisplayName, getDriver, getExtensionRank, getFullObjectName, getIconPath, getLocalUnitClassPath, getMetadataByType, getMetadataByTypePreserveException, getMetadataTypeByParentType, getMetadataTypes, getObjectName, getObjectOwnerName, getType, getXmlConfigFileName, hasCatalogs, hasMetadataTypes, hasSchemas, init, isDatabaseCurrent, setCurrentDatabase, setHasCatalogs, setHasSchemas, supportsRefresh
protected static Map<String,String> DB2_METADATA_METHODS
protected static Map<String,String> DB2_TYPES_BY_PARENT
protected static Map<String,String> DB2_TYPE_SUPPORT_AS_TEXT
protected static Map<String,String> DB2_TYPE_SUPPORT_EXECUTE_AS_TEXT
public static String getConstraintType(Object type)
type
- the typepublic String asTextMethod(String type)
JdbcMetadata
asTextMethod
in class JdbcMetadata
type
- the typepublic String executeAsText(String catalog, String schema, String pattern, String type, String metadataId) throws Exception
Metadata
executeAsText
in interface Metadata
executeAsText
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typemetadataId
- the metadata idException
- in case of any errorpublic DataSet getConstraints(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic List<String> getDbObjectTypes() throws Exception
JdbcMetadata
getDbObjectTypes
in class JdbcMetadata
Exception
- in case of any errorpublic String getDropFunctionAsText(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getDropFunctionAsText
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropPackageAsText(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getDropPackageAsText
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropProcAsText(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getDropProcAsText
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic DataSet getFunctParameters(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getFunctParameters
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getFuncts(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getFuncts
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getIndexColumns(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getIndexColumns
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getLicensePropertyName()
ExtensionModule
getLicensePropertyName
in interface ExtensionModule
getLicensePropertyName
in class JdbcMetadata
public Map<String,String> getMetadataMethods()
BaseMetadata
getMetadataMethods
in class JdbcMetadata
public String getName()
Metadata
getName
in interface Metadata
getName
in class JdbcMetadata
public KeyValue[] getObjectTypes()
Metadata
getObjectTypes
in interface Metadata
getObjectTypes
in class BaseMetadata
public String getPackageAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getPackages(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getProcAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getProcParameters(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getProcParameters
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getProcs(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getProcs
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getSequences(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getTableIndexes(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getTableIndexes
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<String> getTableMetadataTypes()
JdbcMetadata
getTableMetadataTypes
in class JdbcMetadata
public String getTriggerAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getTriggers(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic Map<String,String> getTypesByParent()
BaseMetadata
getTypesByParent
in class JdbcMetadata
public DataSet getUserTypes(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getViewAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getXmlSchemas(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet searchDatabase(DatabaseFilter filter) throws Exception
Metadata
searchDatabase
in interface Metadata
searchDatabase
in class BaseMetadata
filter
- the search filterException
- in case of any errorpublic boolean supportsAsText(String type)
Metadata
supportsAsText
in interface Metadata
supportsAsText
in class JdbcMetadata
type
- the typepublic boolean supportsExecute(String type)
Metadata
supportsExecute
in interface Metadata
supportsExecute
in class JdbcMetadata
type
- the typepublic boolean supportsSearchDatabase()
Metadata
supportsSearchDatabase
in interface Metadata
supportsSearchDatabase
in class BaseMetadata
public DataSet getTablesByType(String catalog, String schema, String pattern, String type) throws Exception
getTablesByType
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionCopyright © 2010-2020 Toolsverse. All Rights Reserved.