java.lang.Object

org.pentaho.di.core.database.BaseDatabaseMeta

org.pentaho.di.core.database.AS400DatabaseMeta

All Implemented Interfaces:: Cloneable, DatabaseInterface, DatabaseInterfaceExtended

public class AS400DatabaseMeta extends BaseDatabaseMeta implements DatabaseInterface

Contains AS/400 specific information through static final members

Since:: 11-mrt-2005
Author:: Matt

Field Summary

Fields inherited from class org.pentaho.di.core.database.BaseDatabaseMeta
ATTRIBUTE_CLUSTER_DBNAME_PREFIX, ATTRIBUTE_CLUSTER_HOSTNAME_PREFIX, ATTRIBUTE_CLUSTER_PASSWORD_PREFIX, ATTRIBUTE_CLUSTER_PORT_PREFIX, ATTRIBUTE_CLUSTER_USERNAME_PREFIX, ATTRIBUTE_FORCE_IDENTIFIERS_TO_LOWERCASE, ATTRIBUTE_FORCE_IDENTIFIERS_TO_UPPERCASE, ATTRIBUTE_INITIAL_POOL_SIZE, ATTRIBUTE_IS_CLUSTERED, ATTRIBUTE_MAXIMUM_POOL_SIZE, ATTRIBUTE_MSSQL_DOUBLE_DECIMAL_SEPARATOR, ATTRIBUTE_POOLING_PARAMETER_PREFIX, ATTRIBUTE_PORT_NUMBER, ATTRIBUTE_PREFERRED_SCHEMA_NAME, ATTRIBUTE_PREFIX_EXTRA_OPTION, ATTRIBUTE_PRESERVE_RESERVED_WORD_CASE, ATTRIBUTE_QUOTE_ALL_FIELDS, ATTRIBUTE_SQL_CONNECT, ATTRIBUTE_SUPPORTS_BOOLEAN_DATA_TYPE, ATTRIBUTE_SUPPORTS_TIMESTAMP_DATA_TYPE, ATTRIBUTE_USE_POOLING, ATTRIBUTE_USE_RESULT_STREAMING, AUTOINCREMENT_SQL_FOR_BATCH_ID, NAMED_CLUSTER_ID, poolingParameters, releaseSavepoint, SELECT_COUNT_STATEMENT, SEQUENCE_FOR_BATCH_ID
Constructor Summary

Constructors

Constructor

Description

AS400DatabaseMeta()
Method Summary

Modifier and Type

Method

Description

int[]

getAccessTypeList()

Get the list of possible access types for a database.

String

getAddColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean useAutoinc, String pk, boolean semicolon)

Generates the SQL statement to add a column to the specified table

String

getDriverClass()

Obtain the name of the JDBC driver class that we need to use!

String

getFieldDefinition(ValueMetaInterface v, String tk, String pk, boolean useAutoinc, boolean addFieldName, boolean addCr)

Describe a Value as a field in the database.

int

getMaxTextFieldLength()

Get the maximum length of a text field for this database connection.

int

getMaxVARCHARLength()

Get the maximum length of a text field (VARCHAR) for this database connection.

String

getModifyColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean useAutoinc, String pk, boolean semicolon)

Generates the SQL statement to modify a column in the specified table

String[]

getReservedWords()

String

getSQLCurrentSequenceValue(String sequenceName)

Get the current value of a database sequence

String

getSQLListOfSequences()

String

getSQLNextSequenceValue(String sequenceName)

Get the SQL to get the next value of a sequence.

String

getSQLSequenceExists(String sequenceName)

Check if a sequence exists.

String

getTruncateTableStatement(String tableName)

String

getURL(String hostname, String port, String database)

String[]

getUsedLibraries()

boolean

supportsFloatRoundingOnUpdate()

Most databases round number(7,2) 17.29999999 to 17.30, but some don't.

boolean

supportsSequenceNoMaxValueOption()

boolean

supportsSequences()

Methods inherited from class org.pentaho.di.core.database.BaseDatabaseMeta
addAttribute, addDefaultOptions, addExtraOption, canTest, checkIndexExists, clone, customizeValueFromSQLType, fullExceptionLog, generateColumnAlias, getAccessType, getAttribute, getAttributes, getBackwardsCompatibleSchemaTableCombination, getBackwardsCompatibleTable, getConnectionPoolingProperties, getConnectSQL, getCreateTableStatement, getDatabaseFactoryName, getDatabaseName, getDatabasePortNumberString, getDataTablespace, getDataTablespaceDDL, getDefaultDatabasePort, getDefaultOptions, getDisplayName, getDropColumnStatement, getDropTableIfExistsStatement, getEndQuote, getExtraOptionIndicator, getExtraOptions, getExtraOptionSeparator, getExtraOptionsHelpText, getExtraOptionValueSeparator, getFieldnameProtector, getFunctionAverage, getFunctionCount, getFunctionMaximum, getFunctionMinimum, getFunctionSum, getHostname, getIndexTablespace, getIndexTablespaceDDL, getInitialPoolSize, getInitialPoolSizeString, getLimitClause, getMaxColumnsInIndex, getMaximumPoolSize, getMaximumPoolSizeString, getName, getNamedCluster, getNextBatchId, getNextBatchIdUsingAutoIncSQL, getNextBatchIdUsingLockTables, getNextBatchIdUsingSequence, getNotFoundTK, getObjectId, getPartitioningInformation, getPassword, getPluginId, getPluginName, getPreferredSchemaName, getSafeFieldname, getSchemaTableCombination, getSelectCountStatement, getSequenceNoMaxValueOption, getServername, getSQLColumnExists, getSQLInsertAutoIncUnknownDimensionRow, getSQLListOfProcedures, getSQLListOfSchemas, getSQLLockTables, getSQLQueryFields, getSqlScriptStatements, getSQLTableExists, getSQLUnlockTables, getSQLValue, getStartQuote, getSynonymTypes, getTablespaceDDL, getTableTypes, getUsername, getValueFromResultSet, getViewTypes, getXulOverlayFile, isChanged, isDefaultingToUppercase, isDisplaySizeTwiceThePrecision, isExplorable, isFetchSizeSupported, isForcingIdentifiersToLowerCase, isForcingIdentifiersToUpperCase, isMySQLVariant, isPartitioned, isQuoteAllFields, isRequiringTransactionsOnQueries, isStreamingResults, isSystemTable, isUsingConnectionPool, isUsingDoubleDecimalAsSchemaTableSeparator, needsPlaceHolder, needsToLockAllTables, onlySpaces, parseStatements, preserveReservedCase, quoteReservedWords, quoteSQLString, releaseSavepoint, requiresCastToVariousForIsNull, requiresCreateTablePrimaryKeyAppend, requiresName, setAccessType, setAttributes, setChanged, setConnectionPoolingProperties, setConnectSQL, setDatabaseName, setDatabasePortNumberString, setDataTablespace, setDisplayName, setForcingIdentifiersToLowerCase, setForcingIdentifiersToUpperCase, setHostname, setIndexTablespace, setInitialPoolSize, setInitialPoolSizeString, setMaximumPoolSize, setMaximumPoolSizeString, setName, setNamedCluster, setObjectId, setPartitioned, setPartitioningInformation, setPassword, setPluginId, setPluginName, setPreferredSchemaName, setPreserveReservedCase, setQuoteAllFields, setServername, setStreamingResults, setSupportsBooleanDataType, setSupportsTimestampDataType, setUsername, setUsingConnectionPool, setUsingDoubleDecimalAsSchemaTableSeparator, supportsAutoGeneratedKeys, supportsAutoInc, supportsBatchUpdates, supportsBitmapIndex, supportsBooleanDataType, supportsCatalogs, supportsEmptyTransactions, supportsErrorHandling, supportsErrorHandlingOnBatchUpdates, supportsGetBlob, supportsNewLinesInSQL, supportsOptionsInURL, supportsPreparedStatementMetadataRetrieval, supportsRepository, supportsResultSetMetadataRetrievalOnly, supportsSchemas, supportsSetCharacterStream, supportsSetLong, supportsSetMaxRows, supportsSynonyms, supportsTimestampDataType, supportsTimeStampToDateConversion, supportsTransactions, supportsViews, useSafePoints, useSchemaNameForTableList

Methods inherited from class java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.pentaho.di.core.database.DatabaseInterface
addAttribute, addDefaultOptions, addExtraOption, checkIndexExists, clone, createSqlScriptParser, customizeValueFromSQLType, generateColumnAlias, getAccessType, getAttribute, getAttributes, getConnectionPoolingProperties, getConnectSQL, getCreateTableStatement, getDatabaseFactoryName, getDatabaseName, getDatabasePortNumberString, getDataTablespace, getDataTablespaceDDL, getDefaultDatabasePort, getDefaultOptions, getDisplayName, getDropColumnStatement, getEndQuote, getExtraOptionIndicator, getExtraOptions, getExtraOptionSeparator, getExtraOptionsHelpText, getExtraOptionValueSeparator, getFunctionAverage, getFunctionCount, getFunctionMaximum, getFunctionMinimum, getFunctionSum, getHostname, getIndexTablespace, getIndexTablespaceDDL, getInitialPoolSize, getInitialPoolSizeString, getLegacyColumnName, getLimitClause, getMaxColumnsInIndex, getMaximumPoolSize, getMaximumPoolSizeString, getName, getNamedCluster, getNamedClusterList, getNextBatchId, getNotFoundTK, getObjectId, getPartitioningInformation, getPassword, getPluginId, getPluginName, getPreferredSchemaName, getSafeFieldname, getSchemas, getSchemaTableCombination, getSelectCountStatement, getSequenceNoMaxValueOption, getServername, getSQLColumnExists, getSQLInsertAutoIncUnknownDimensionRow, getSQLListOfProcedures, getSQLListOfSchemas, getSQLListOfSchemas, getSQLLockTables, getSQLQueryFields, getSqlScriptStatements, getSQLTableExists, getSQLUnlockTables, getSQLValue, getStartQuote, getSynonymTypes, getTables, getTableTypes, getUnsupportedTableOutputMessage, getUsername, getValueFromResultSet, getViewTypes, getXulOverlayFile, isChanged, isDefaultingToUppercase, isDisplaySizeTwiceThePrecision, isExplorable, isFetchSizeSupported, isForcingIdentifiersToLowerCase, isForcingIdentifiersToUpperCase, isMySQLVariant, isPartitioned, isQuoteAllFields, isRequiringTransactionsOnQueries, isStreamingResults, isSystemTable, isUsingConnectionPool, isUsingDoubleDecimalAsSchemaTableSeparator, needsPlaceHolder, needsToLockAllTables, parseStatements, preserveReservedCase, putOptionalOptions, quoteReservedWords, quoteSQLString, releaseSavepoint, requiresCastToVariousForIsNull, requiresCreateTablePrimaryKeyAppend, setAccessType, setAttributes, setChanged, setConnectionPoolingProperties, setConnectSQL, setDatabaseName, setDatabasePortNumberString, setDataTablespace, setDisplayName, setForcingIdentifiersToLowerCase, setForcingIdentifiersToUpperCase, setHostname, setIndexTablespace, setInitialPoolSize, setInitialPoolSizeString, setMaximumPoolSize, setMaximumPoolSizeString, setName, setNamedCluster, setObjectId, setPartitioned, setPartitioningInformation, setPassword, setPluginId, setPluginName, setPreferredSchemaName, setPreserveReservedCase, setQuoteAllFields, setServername, setStreamingResults, setSupportsBooleanDataType, setSupportsTimestampDataType, setUsername, setUsingConnectionPool, setUsingDoubleDecimalAsSchemaTableSeparator, supportsAutoGeneratedKeys, supportsAutoInc, supportsBatchUpdates, supportsBitmapIndex, supportsBooleanDataType, supportsCatalogs, supportsEmptyTransactions, supportsErrorHandling, supportsErrorHandlingOnBatchUpdates, supportsGetBlob, supportsIndexes, supportsNewLinesInSQL, supportsOptionsInURL, supportsPreparedStatementMetadataRetrieval, supportsRepository, supportsResultSetMetadataRetrievalOnly, supportsSchemas, supportsSetCharacterStream, supportsSetLong, supportsSetMaxRows, supportsStandardTableOutput, supportsSynonyms, supportsTimestampDataType, supportsTimeStampToDateConversion, supportsTransactions, supportsViews, useSafePoints, useSchemaNameForTableList

Constructor Details
- AS400DatabaseMeta
  
  public AS400DatabaseMeta()
Method Details
- getAccessTypeList
  
  public int[] getAccessTypeList()
  
  Description copied from interface: DatabaseInterface
  
  Get the list of possible access types for a database.
  
  Specified by:
  
  getAccessTypeList in interface DatabaseInterface
  
  Specified by:
  
  getAccessTypeList in class BaseDatabaseMeta
  
  Returns:
  
  the list of possible access types for a database.
- getDriverClass
  
  public String getDriverClass()
  
  Description copied from interface: DatabaseInterface
  
  Obtain the name of the JDBC driver class that we need to use!
  
  Specified by:
  
  getDriverClass in interface DatabaseInterface
  
  Returns:
  
  the name of the JDBC driver class for the specific database
- getMaxTextFieldLength
  
  public int getMaxTextFieldLength()
  
  Get the maximum length of a text field for this database connection. This includes optional CLOB, Memo and Text fields. (the maximum!)
  
  Specified by:
  
  getMaxTextFieldLength in interface DatabaseInterface
  
  Overrides:
  
  getMaxTextFieldLength in class BaseDatabaseMeta
  
  Returns:
  
  The maximum text field length for this database type. (mostly CLOB_LENGTH)
- getURL
  
  public String getURL(String hostname, String port, String database)
  
  Specified by:
  
  getURL in interface DatabaseInterface
  
  Parameters:
  
  hostname - the hostname
  
  port - the port as a string
  
  database - the database name
  
  Returns:
  
  the URL to use for connecting to the database.
- getTruncateTableStatement
  
  public String getTruncateTableStatement(String tableName)
  
  Specified by:
  
  getTruncateTableStatement in interface DatabaseInterface
  
  Overrides:
  
  getTruncateTableStatement in class BaseDatabaseMeta
  
  Parameters:
  
  tableName - The table to be truncated.
  
  Returns:
  
  The SQL statement to truncate a table: remove all rows from it without a transaction
- getAddColumnStatement
  
  public String getAddColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean useAutoinc, String pk, boolean semicolon)
  
  Generates the SQL statement to add a column to the specified table
  
  Specified by:
  
  getAddColumnStatement in interface DatabaseInterface
  
  Parameters:
  
  tablename - The table to add
  
  v - The column defined as a value
  
  tk - the name of the technical key field
  
  useAutoinc - whether or not this field uses auto increment
  
  pk - the name of the primary key field
  
  semicolon - whether or not to add a semi-colon behind the statement.
  
  Returns:
  
  the SQL statement to add a column to the specified table
- getModifyColumnStatement
  
  public String getModifyColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean useAutoinc, String pk, boolean semicolon)
  
  Generates the SQL statement to modify a column in the specified table
  
  Specified by:
  
  getModifyColumnStatement in interface DatabaseInterface
  
  Parameters:
  
  tablename - The table to add
  
  v - The column defined as a value
  
  tk - the name of the technical key field
  
  useAutoinc - whether or not this field uses auto increment
  
  pk - the name of the primary key field
  
  semicolon - whether or not to add a semi-colon behind the statement.
  
  Returns:
  
  the SQL statement to modify a column in the specified table
- getFieldDefinition
  
  public String getFieldDefinition(ValueMetaInterface v, String tk, String pk, boolean useAutoinc, boolean addFieldName, boolean addCr)
  
  Description copied from interface: DatabaseInterface
  
  Describe a Value as a field in the database.
  
  Specified by:
  
  getFieldDefinition in interface DatabaseInterface
  
  Parameters:
  
  v - The value to describe
  
  tk - The field that's going to be the technical key
  
  pk - The field that's going to be the primary key
  
  useAutoinc - Use autoincrement or not
  
  addFieldName - Add the fieldname to the definition or not
  
  addCr - Add a cariage return at the end of the definition or not.
  
  Returns:
  
  a value described as a field in this database.
- getReservedWords
  
  public String[] getReservedWords()
  
  Specified by:
  
  getReservedWords in interface DatabaseInterface
  
  Overrides:
  
  getReservedWords in class BaseDatabaseMeta
  
  Returns:
  
  an array of reserved words for the database type...
- getUsedLibraries
  
  public String[] getUsedLibraries()
  
  Specified by:
  
  getUsedLibraries in interface DatabaseInterface
  
  Returns:
  
  the required libraries (in lib) for this database connection.
- supportsFloatRoundingOnUpdate
  
  public boolean supportsFloatRoundingOnUpdate()
  
  Most databases round number(7,2) 17.29999999 to 17.30, but some don't.
  
  Specified by:
  
  supportsFloatRoundingOnUpdate in interface DatabaseInterface
  
  Overrides:
  
  supportsFloatRoundingOnUpdate in class BaseDatabaseMeta
  
  Returns:
  
  true if the database supports roundinf of floating point data on update/insert
- getMaxVARCHARLength
  
  public int getMaxVARCHARLength()
  
  Get the maximum length of a text field (VARCHAR) for this database connection. If this size is exceeded use a CLOB.
  
  Specified by:
  
  getMaxVARCHARLength in interface DatabaseInterface
  
  Overrides:
  
  getMaxVARCHARLength in class BaseDatabaseMeta
  
  Returns:
  
  The maximum VARCHAR field length for this database type. (mostly identical to getMaxTextFieldLength() - CLOB_LENGTH)
- supportsSequences
  
  public boolean supportsSequences()
  
  Specified by:
  
  supportsSequences in interface DatabaseInterface
  
  Overrides:
  
  supportsSequences in class BaseDatabaseMeta
  
  Returns:
  
  true if the database supports sequences
- getSQLListOfSequences
  
  public String getSQLListOfSequences()
  
  Specified by:
  
  getSQLListOfSequences in interface DatabaseInterface
  
  Overrides:
  
  getSQLListOfSequences in class BaseDatabaseMeta
  
  Returns:
  
  The SQL on this database to get a list of sequences.
- getSQLSequenceExists
  
  public String getSQLSequenceExists(String sequenceName)
  
  Check if a sequence exists.
  
  Specified by:
  
  getSQLSequenceExists in interface DatabaseInterface
  
  Overrides:
  
  getSQLSequenceExists in class BaseDatabaseMeta
  
  Parameters:
  
  sequenceName - The sequence to check
  
  Returns:
  
  The SQL to get the name of the sequence back from the databases data dictionary
- getSQLCurrentSequenceValue
  
  public String getSQLCurrentSequenceValue(String sequenceName)
  
  Get the current value of a database sequence
  
  Specified by:
  
  getSQLCurrentSequenceValue in interface DatabaseInterface
  
  Overrides:
  
  getSQLCurrentSequenceValue in class BaseDatabaseMeta
  
  Parameters:
  
  sequenceName - The sequence to check
  
  Returns:
  
  The current value of a database sequence
- getSQLNextSequenceValue
  
  public String getSQLNextSequenceValue(String sequenceName)
  
  Get the SQL to get the next value of a sequence. (Oracle only)
  
  Specified by:
  
  getSQLNextSequenceValue in interface DatabaseInterface
  
  Overrides:
  
  getSQLNextSequenceValue in class BaseDatabaseMeta
  
  Parameters:
  
  sequenceName - The sequence name
  
  Returns:
  
  the SQL to get the next value of a sequence. (Oracle only)
- supportsSequenceNoMaxValueOption
  
  public boolean supportsSequenceNoMaxValueOption()
  
  Specified by:
  
  supportsSequenceNoMaxValueOption in interface DatabaseInterface
  
  Overrides:
  
  supportsSequenceNoMaxValueOption in class BaseDatabaseMeta
  
  Returns:
  
  true if the database supports the NOMAXVALUE sequence option. The default is false, AS/400 and DB2 support this.

Class AS400DatabaseMeta

Field Summary

Fields inherited from class org.pentaho.di.core.database.BaseDatabaseMeta

Constructor Summary

Method Summary

Methods inherited from class org.pentaho.di.core.database.BaseDatabaseMeta

Methods inherited from class java.lang.Object

Methods inherited from interface org.pentaho.di.core.database.DatabaseInterface

Constructor Details

AS400DatabaseMeta

Method Details

getAccessTypeList

getDriverClass

getMaxTextFieldLength

getURL

getTruncateTableStatement

getAddColumnStatement

getModifyColumnStatement

getFieldDefinition

getReservedWords

getUsedLibraries

supportsFloatRoundingOnUpdate

getMaxVARCHARLength

supportsSequences

getSQLListOfSequences

getSQLSequenceExists

getSQLCurrentSequenceValue

getSQLNextSequenceValue

supportsSequenceNoMaxValueOption