|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.pentaho.di.core.database.BaseDatabaseMeta org.pentaho.di.core.database.NetezzaDatabaseMeta
public class NetezzaDatabaseMeta
Contains Netezza specific information through static final members
Field Summary | |
---|---|
static int |
MAX_CHAR_LEN
|
Constructor Summary | |
---|---|
NetezzaDatabaseMeta()
|
Method Summary | |
---|---|
int[] |
getAccessTypeList()
Get the list of possible access types for a database. |
String |
getAddColumnStatement(String tablename,
ValueMetaInterface v,
String tk,
boolean use_autoinc,
String pk,
boolean semicolon)
Generates the SQL statement to add a column to the specified table Note: Netezza does not allow adding columns to tables |
int |
getDefaultDatabasePort()
|
String |
getDriverClass()
Obtain the name of the JDBC driver class that we need to use! |
String |
getDropColumnStatement(String tablename,
ValueMetaInterface v,
String tk,
boolean use_autoinc,
String pk,
boolean semicolon)
Generates the SQL statement to drop a column from the specified table Note: Netezza does not allow addition/deletion of columns to tables |
String |
getExtraOptionIndicator()
|
String |
getExtraOptionSeparator()
|
String |
getFieldDefinition(ValueMetaInterface v,
String tk,
String pk,
boolean use_autoinc,
boolean add_fieldname,
boolean add_cr)
Describe a Value as a field in the database. |
String |
getLimitClause(int nrRows)
|
String |
getModifyColumnStatement(String tablename,
ValueMetaInterface v,
String tk,
boolean use_autoinc,
String pk,
boolean semicolon)
Generates the SQL statement to modify a column in the specified table. |
String[] |
getReservedWords()
|
String |
getSQLColumnExists(String columnname,
String tablename)
|
String |
getSQLCurrentSequenceValue(String sequenceName)
Get the SQL to get the current value of a sequence. |
String |
getSQLListOfProcedures(String schemaName)
|
String |
getSQLLockTables(String[] tableNames)
|
String |
getSQLNextSequenceValue(String sequenceName)
Get the SQL to get the next value of a sequence. |
String |
getSQLQueryColumnFields(String columnname,
String tableName)
|
String |
getSQLQueryFields(String tableName)
Returns the minimal SQL to launch in order to determine the layout of the resultset for a given database table |
String |
getSQLSequenceExists(String sequenceName)
Check if a sequence exists. |
String |
getSQLTableExists(String tablename)
|
String |
getSQLUnlockTables(String[] tableName)
|
String |
getURL(String hostname,
String port,
String databaseName)
|
String[] |
getUsedLibraries()
|
boolean |
isDefaultingToUppercase()
|
boolean |
isFetchSizeSupported()
Checks whether or not the command setFetchSize() is supported by the JDBC driver... |
boolean |
supportsAutoInc()
|
boolean |
supportsBitmapIndex()
|
boolean |
supportsSequences()
|
boolean |
supportsSynonyms()
|
boolean |
supportsTimeStampToDateConversion()
|
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final int MAX_CHAR_LEN
Constructor Detail |
---|
public NetezzaDatabaseMeta()
Method Detail |
---|
public String getExtraOptionSeparator()
getExtraOptionSeparator
in interface DatabaseInterface
getExtraOptionSeparator
in class BaseDatabaseMeta
public String getExtraOptionIndicator()
getExtraOptionIndicator
in interface DatabaseInterface
getExtraOptionIndicator
in class BaseDatabaseMeta
public int[] getAccessTypeList()
DatabaseInterface
getAccessTypeList
in interface DatabaseInterface
getAccessTypeList
in class BaseDatabaseMeta
public int getDefaultDatabasePort()
getDefaultDatabasePort
in interface DatabaseInterface
getDefaultDatabasePort
in class BaseDatabaseMeta
public String getDriverClass()
DatabaseInterface
getDriverClass
in interface DatabaseInterface
public String getURL(String hostname, String port, String databaseName)
getURL
in interface DatabaseInterface
hostname
- the hostnameport
- the port as a stringdatabaseName
- the database name
public boolean isFetchSizeSupported()
isFetchSizeSupported
in interface DatabaseInterface
isFetchSizeSupported
in class BaseDatabaseMeta
public boolean supportsBitmapIndex()
supportsBitmapIndex
in interface DatabaseInterface
supportsBitmapIndex
in class BaseDatabaseMeta
public boolean supportsSynonyms()
supportsSynonyms
in interface DatabaseInterface
supportsSynonyms
in class BaseDatabaseMeta
public boolean supportsSequences()
supportsSequences
in interface DatabaseInterface
supportsSequences
in class BaseDatabaseMeta
public boolean supportsAutoInc()
supportsAutoInc
in interface DatabaseInterface
supportsAutoInc
in class BaseDatabaseMeta
public String getLimitClause(int nrRows)
getLimitClause
in interface DatabaseInterface
getLimitClause
in class BaseDatabaseMeta
nrRows
- The number of rows to which we want to limit the result of the query.
public String getSQLQueryFields(String tableName)
BaseDatabaseMeta
getSQLQueryFields
in interface DatabaseInterface
getSQLQueryFields
in class BaseDatabaseMeta
tableName
- The name of the table to determine the layout for
public String getSQLTableExists(String tablename)
getSQLTableExists
in interface DatabaseInterface
getSQLTableExists
in class BaseDatabaseMeta
tablename
- The table to verify the existance for
public String getSQLColumnExists(String columnname, String tablename)
getSQLColumnExists
in interface DatabaseInterface
getSQLColumnExists
in class BaseDatabaseMeta
tablename
- The table to verify the existance for
public String getSQLQueryColumnFields(String columnname, String tableName)
public String getSQLNextSequenceValue(String sequenceName)
getSQLNextSequenceValue
in interface DatabaseInterface
getSQLNextSequenceValue
in class BaseDatabaseMeta
sequenceName
- The sequence name
public String getSQLCurrentSequenceValue(String sequenceName)
getSQLCurrentSequenceValue
in interface DatabaseInterface
getSQLCurrentSequenceValue
in class BaseDatabaseMeta
sequenceName
- The sequence name
public String getSQLSequenceExists(String sequenceName)
getSQLSequenceExists
in interface DatabaseInterface
getSQLSequenceExists
in class BaseDatabaseMeta
sequenceName
- The sequence to check
public String getAddColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean use_autoinc, String pk, boolean semicolon)
getAddColumnStatement
in interface DatabaseInterface
tablename
- The table to addv
- The column defined as a valuetk
- the name of the technical key fielduse_autoinc
- whether or not this field uses auto incrementpk
- the name of the primary key fieldsemicolon
- whether or not to add a semi-colon behind the statement.
public String getDropColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean use_autoinc, String pk, boolean semicolon)
getDropColumnStatement
in interface DatabaseInterface
getDropColumnStatement
in class BaseDatabaseMeta
tablename
- The table to addv
- The column defined as a valuetk
- the name of the technical key fielduse_autoinc
- whether or not this field uses auto incrementpk
- the name of the primary key fieldsemicolon
- whether or not to add a semi-colon behind the statement.
public String getModifyColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean use_autoinc, String pk, boolean semicolon)
getModifyColumnStatement
in interface DatabaseInterface
tablename
- The table to addv
- The column defined as a valuetk
- the name of the technical key fielduse_autoinc
- whether or not this field uses auto incrementpk
- the name of the primary key fieldsemicolon
- whether or not to add a semi-colon behind the statement.
public String getFieldDefinition(ValueMetaInterface v, String tk, String pk, boolean use_autoinc, boolean add_fieldname, boolean add_cr)
DatabaseInterface
getFieldDefinition
in interface DatabaseInterface
v
- The value to describetk
- The field that's going to be the technical keypk
- The field that's going to be the primary keyuse_autoinc
- Use autoincrement or notadd_fieldname
- Add the fieldname to the definition or notadd_cr
- Add a cariage return at the end of the definition or not.
public String getSQLListOfProcedures(String schemaName)
the
- schema name to search in or null if you want to search the whole DB
public String[] getReservedWords()
getReservedWords
in interface DatabaseInterface
getReservedWords
in class BaseDatabaseMeta
public String getSQLLockTables(String[] tableNames)
getSQLLockTables
in interface DatabaseInterface
getSQLLockTables
in class BaseDatabaseMeta
tableNames
- The names of the tables to lock
public String getSQLUnlockTables(String[] tableName)
getSQLUnlockTables
in interface DatabaseInterface
getSQLUnlockTables
in class BaseDatabaseMeta
tableName
- The name of the table to unlock
public boolean isDefaultingToUppercase()
isDefaultingToUppercase
in interface DatabaseInterface
isDefaultingToUppercase
in class BaseDatabaseMeta
public boolean supportsTimeStampToDateConversion()
supportsTimeStampToDateConversion
in interface DatabaseInterface
supportsTimeStampToDateConversion
in class BaseDatabaseMeta
public String[] getUsedLibraries()
getUsedLibraries
in interface DatabaseInterface
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |