EclipseLink Core 4.0.2 · org.eclipse.persistence.platform.database.DB2ZPlatform

Modifier and Type	Field and Description
private static String	DB2_CALLABLESTATEMENT_CLASS
private static String	DB2_PREPAREDSTATEMENT_CLASS

Access	Constructor and Description
public	DB2ZPlatform()

Method Summary

Modifier and Type	Method and Description
protected ExpressionOperator	absOperator() Disable binding support.
protected ExpressionOperator	avgOperator() Disable binding support.
protected ExpressionOperator	betweenOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ?
protected Hashtable<Class<?>, FieldTypeDefinition>	buildFieldTypes() Overrides org.eclipse.persistence.platform.database.DB2Platform.buildFieldTypes. Return the mapping of class types to database types for the schema framework.
public String	buildProcedureCallString(StoredProcedureCall call, AbstractSession session, AbstractRecord row) Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.buildProcedureCallString. INTERNAL: Used for sp calls.
protected ExpressionOperator	ceilingOperator() Disable binding support.
protected ExpressionOperator	concatOperator() Overrides org.eclipse.persistence.platform.database.DB2Platform.concatOperator. DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way.
protected ExpressionOperator	equalOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ?
protected ExpressionOperator	expOperator() Disable binding support.
protected ExpressionOperator	floorOperator() Disable binding support.
public Object	getParameterValueFromDatabaseCall(CallableStatement statement, String name, AbstractSession session) Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getParameterValueFromDatabaseCall. INTERNAL Get the parameter from the JDBC statement with the given name.
public String	getProcedureArgument(String name, Object parameter, DatasourceCall.ParameterType parameterType, StoredProcedureCall call, AbstractSession session) Overrides org.eclipse.persistence.platform.database.DB2Platform.getProcedureArgument. Obtain the platform specific argument string
public String	getProcedureOptionList() Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getProcedureOptionList. DB2 on Z uses ":" as prefix for procedure arguments.
public String	getTableCreationSuffix() Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getTableCreationSuffix. PUBLIC: Get the String used on all table creation statements generated from the DefaultTableGenerator with a session using this project (DDL generation).
public ValueReadQuery	getTimestampQuery() Overrides org.eclipse.persistence.platform.database.DB2Platform.getTimestampQuery. Implements org.eclipse.persistence.internal.databaseaccess.Platform.getTimestampQuery. INTERNAL: This method returns the query to select the timestamp from the server for DB2.
protected ExpressionOperator	greaterThanEqualOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ?
protected ExpressionOperator	greaterThanOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ?
protected void	initializePlatformOperators() Overrides org.eclipse.persistence.platform.database.DB2Platform.initializePlatformOperators. INTERNAL: Initialize any platform-specific operators
protected ExpressionOperator	inOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ?
public boolean	isDB2Z() Overrides org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform.isDB2Z. Implements org.eclipse.persistence.internal.databaseaccess.Platform.isDB2Z.
protected ExpressionOperator	isNotNullOperator() Disable binding support.
protected ExpressionOperator	isNullOperator() Disable binding support.
protected ExpressionOperator	lessThanEqualOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ?
protected ExpressionOperator	lessThanOperator() Set binding support to PARTIAL.
protected ExpressionOperator	likeEscapeOperator() DB2 z/OS support for binding the LIKE ESCAPE character depends on database configuration (mixed vs DBCS).
protected ExpressionOperator	lnOperator() Disable binding support.
protected ExpressionOperator	locate2Operator() Disable binding support.
protected ExpressionOperator	locateOperator() Disable binding support.
protected ExpressionOperator	ltrim2Operator() Overrides org.eclipse.persistence.platform.database.DB2Platform.ltrim2Operator. Disable binding support.
protected ExpressionOperator	ltrimOperator() Disable binding support.
protected ExpressionOperator	modOperator() Disable binding support.
protected ExpressionOperator	notBetweenOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ?
protected ExpressionOperator	notEqualOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ?
protected ExpressionOperator	notLikeEscapeOperator() DB2 z/OS support for binding the LIKE ESCAPE character depends on database configuration (mixed vs DBCS).
protected ExpressionOperator	powerOperator() Disable binding support.
public void	registerOutputParameter(CallableStatement statement, String name, int jdbcType) Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.registerOutputParameter. This method is used to register output parameter on Callable Statements for Stored Procedures as each database seems to have a different method.
public void	registerOutputParameter(CallableStatement statement, String name, int jdbcType, String typeName) Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.registerOutputParameter. This method is used to register output parameter on Callable Statements for Stored Procedures as each database seems to have a different method.
protected ExpressionOperator	roundOperator() Overrides org.eclipse.persistence.platform.database.DB2Platform.roundOperator. Disable binding support.
protected ExpressionOperator	rtrim2Operator() Overrides org.eclipse.persistence.platform.database.DB2Platform.rtrim2Operator. Disable binding support.
protected ExpressionOperator	rtrimOperator() Disable binding support.
protected void	setNullFromDatabaseField(DatabaseField databaseField, CallableStatement statement, String name) Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.setNullFromDatabaseField.
public void	setParameterValueInDatabaseCall(Object parameter, CallableStatement statement, String name, AbstractSession session) Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.setParameterValueInDatabaseCall. INTERNAL Set the parameter in the JDBC statement with the given name.
protected ExpressionOperator	signOperator() Disable binding support.
protected ExpressionOperator	sqrtOperator() Disable binding support.
protected ExpressionOperator	sumOperator() Disable binding support.
protected ExpressionOperator	trim2() Overrides org.eclipse.persistence.platform.database.DB2Platform.trim2. Disable binding support.
protected ExpressionOperator	trimOperator() Disable binding support.

Inherited from org.eclipse.persistence.platform.database.DB2Platform:: allowBindingForSelectClause appendByteArray appendCalendar appendDate appendDB2Calendar appendDB2Date appendDB2Timestamp appendTime appendTimestamp ascendingOperator buildSelectQueryForIdentity buildSelectQueryForSequenceObject caseConditionOperator caseOperator coalesceOperator count descendingOperator disableAllBindingExpression disableAtLeast1BindingExpression distinct dontBindUpdateAllQueryUsingTempTables getCreateTempTableSqlBodyForTable getCreateTempTableSqlPrefix getCreateTempTableSqlSuffix getMaxFieldNameSize getMaxForeignKeyNameSize getMaxUniqueKeyNameSize getNativeTableInfo getNoWaitString getProcedureAsString getProcedureBeginString getProcedureCallHeader getProcedureEndString getSelectForUpdateString getTempTableForTable initializeConnectionData isAlterSequenceObjectSupported isDB2 isDynamicSQLRequiredForFunctions isNullAllowedInSelectClause lengthOperator max maximumNumericValues min minimumNumericValues nullifOperator printFieldIdentityClause printFieldTypeSize printSQLSelectStatement shouldBindPartialParameters shouldIgnoreException shouldPrintForUpdateClause shouldPrintOutputTokenAtStart shouldUseJDBCOuterJoinSyntax supportsGlobalTempTables supportsIdentity supportsLockingQueriesWithMultipleTables supportsOrderByParameters supportsSequenceObjects writeParameterMarker

DB2_CALLABLESTATEMENT_CLASS	back to summary
private static String DB2_CALLABLESTATEMENT_CLASS

DB2_PREPAREDSTATEMENT_CLASS	back to summary
private static String DB2_PREPAREDSTATEMENT_CLASS

DB2ZPlatform	back to summary
public DB2ZPlatform()

Method Detail

absOperator	back to summary
protected ExpressionOperator absOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

absOperator

back to summary

protected ExpressionOperator absOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

avgOperator	back to summary
protected ExpressionOperator avgOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

avgOperator

back to summary

protected ExpressionOperator avgOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

betweenOperator	back to summary
protected ExpressionOperator betweenOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

betweenOperator

back to summary

protected ExpressionOperator betweenOperator()

DB2 z/OS requires that at least one argument be a known type

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

buildFieldTypes	back to summary
protected Hashtable<Class<?>, FieldTypeDefinition> buildFieldTypes() Overrides org.eclipse.persistence.platform.database.DB2Platform.buildFieldTypes. Doc from org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.buildFieldTypes. Return the mapping of class types to database types for the schema framework. Annotations @Override

buildFieldTypes

back to summary

protected Hashtable<Class<?>, FieldTypeDefinition> buildFieldTypes()

Overrides org.eclipse.persistence.platform.database.DB2Platform.buildFieldTypes.

Doc from org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.buildFieldTypes.

Return the mapping of class types to database types for the schema framework.

Annotations

@Override

buildProcedureCallString	back to summary
public String buildProcedureCallString(StoredProcedureCall call, AbstractSession session, AbstractRecord row) Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.buildProcedureCallString. INTERNAL: Used for sp calls. PostGreSQL uses a different method for executing StoredProcedures than other platforms. Annotations @Override

buildProcedureCallString

back to summary

public String buildProcedureCallString(StoredProcedureCall call, AbstractSession session, AbstractRecord row)

Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.buildProcedureCallString.

INTERNAL: Used for sp calls. PostGreSQL uses a different method for executing StoredProcedures than other platforms.

Annotations

@Override

ceilingOperator	back to summary
protected ExpressionOperator ceilingOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

ceilingOperator

back to summary

protected ExpressionOperator ceilingOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

concatOperator	back to summary
protected ExpressionOperator concatOperator() Overrides org.eclipse.persistence.platform.database.DB2Platform.concatOperator. DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610 Annotations @Override

concatOperator

back to summary

protected ExpressionOperator concatOperator()

Overrides org.eclipse.persistence.platform.database.DB2Platform.concatOperator.

DB2 z/OS requires that at least one argument be a known type

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

Annotations

@Override

equalOperator	back to summary
protected ExpressionOperator equalOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

equalOperator

back to summary

protected ExpressionOperator equalOperator()

DB2 z/OS requires that at least one argument be a known type

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

expOperator	back to summary
protected ExpressionOperator expOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

expOperator

back to summary

protected ExpressionOperator expOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

floorOperator	back to summary
protected ExpressionOperator floorOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

floorOperator

back to summary

protected ExpressionOperator floorOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

getParameterValueFromDatabaseCall	back to summary
public Object getParameterValueFromDatabaseCall(CallableStatement statement, String name, AbstractSession session) throws SQLException Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getParameterValueFromDatabaseCall. Doc from org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getParameterValueFromDatabaseCall. INTERNAL Get the parameter from the JDBC statement with the given name. Annotations @Override

getParameterValueFromDatabaseCall

back to summary

public Object getParameterValueFromDatabaseCall(CallableStatement statement, String name, AbstractSession session) throws SQLException

Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getParameterValueFromDatabaseCall.

Doc from org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getParameterValueFromDatabaseCall.

INTERNAL Get the parameter from the JDBC statement with the given name.

Annotations

@Override

getProcedureArgument	back to summary
public String getProcedureArgument(String name, Object parameter, DatasourceCall.ParameterType parameterType, StoredProcedureCall call, AbstractSession session) Overrides org.eclipse.persistence.platform.database.DB2Platform.getProcedureArgument. Doc from org.eclipse.persistence.platform.database.DB2Platform.getProcedureArgument. Obtain the platform specific argument string Annotations @Override

getProcedureArgument

back to summary

public String getProcedureArgument(String name, Object parameter, DatasourceCall.ParameterType parameterType, StoredProcedureCall call, AbstractSession session)

Overrides org.eclipse.persistence.platform.database.DB2Platform.getProcedureArgument.

Doc from org.eclipse.persistence.platform.database.DB2Platform.getProcedureArgument.

Obtain the platform specific argument string

Annotations

@Override

getProcedureOptionList	back to summary
public String getProcedureOptionList() Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getProcedureOptionList. DB2 on Z uses ":" as prefix for procedure arguments. Annotations @Override

getProcedureOptionList

back to summary

public String getProcedureOptionList()

Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getProcedureOptionList.

DB2 on Z uses ":" as prefix for procedure arguments.

Annotations

@Override

getTableCreationSuffix	back to summary
public String getTableCreationSuffix() Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getTableCreationSuffix. Doc from org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getTableCreationSuffix. PUBLIC: Get the String used on all table creation statements generated from the DefaultTableGenerator with a session using this project (DDL generation). This value will be appended to CreationSuffix strings stored on the DatabaseTable or TableDefinition. Annotations @Override

getTableCreationSuffix

back to summary

public String getTableCreationSuffix()

Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getTableCreationSuffix.

Doc from org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.getTableCreationSuffix.

PUBLIC: Get the String used on all table creation statements generated from the DefaultTableGenerator with a session using this project (DDL generation). This value will be appended to CreationSuffix strings stored on the DatabaseTable or TableDefinition.

Annotations

@Override

getTimestampQuery	back to summary
public ValueReadQuery getTimestampQuery() Overrides org.eclipse.persistence.platform.database.DB2Platform.getTimestampQuery. Implements org.eclipse.persistence.internal.databaseaccess.Platform.getTimestampQuery. INTERNAL: This method returns the query to select the timestamp from the server for DB2. Annotations @Override

getTimestampQuery

back to summary

public ValueReadQuery getTimestampQuery()

Overrides org.eclipse.persistence.platform.database.DB2Platform.getTimestampQuery.

Implements org.eclipse.persistence.internal.databaseaccess.Platform.getTimestampQuery.

INTERNAL: This method returns the query to select the timestamp from the server for DB2.

Annotations

@Override

greaterThanEqualOperator	back to summary
protected ExpressionOperator greaterThanEqualOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

greaterThanEqualOperator

back to summary

protected ExpressionOperator greaterThanEqualOperator()

DB2 z/OS requires that at least one argument be a known type

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

greaterThanOperator	back to summary
protected ExpressionOperator greaterThanOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

greaterThanOperator

back to summary

protected ExpressionOperator greaterThanOperator()

DB2 z/OS requires that at least one argument be a known type

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

initializePlatformOperators	back to summary
protected void initializePlatformOperators() Overrides org.eclipse.persistence.platform.database.DB2Platform.initializePlatformOperators. INTERNAL: Initialize any platform-specific operators Annotations @Override

initializePlatformOperators

back to summary

protected void initializePlatformOperators()

Overrides org.eclipse.persistence.platform.database.DB2Platform.initializePlatformOperators.

INTERNAL: Initialize any platform-specific operators

Annotations

@Override

inOperator	back to summary
protected ExpressionOperator inOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

inOperator

back to summary

protected ExpressionOperator inOperator()

DB2 z/OS requires that at least one argument be a known type

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

isDB2Z	back to summary
public boolean isDB2Z() Overrides org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform.isDB2Z. Implements org.eclipse.persistence.internal.databaseaccess.Platform.isDB2Z. Annotations @Override

isDB2Z

back to summary

public boolean isDB2Z()

Overrides org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform.isDB2Z.

Implements org.eclipse.persistence.internal.databaseaccess.Platform.isDB2Z.

Annotations

@Override

isNotNullOperator	back to summary
protected ExpressionOperator isNotNullOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

isNotNullOperator

back to summary

protected ExpressionOperator isNotNullOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

isNullOperator	back to summary
protected ExpressionOperator isNullOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

isNullOperator

back to summary

protected ExpressionOperator isNullOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

lessThanEqualOperator	back to summary
protected ExpressionOperator lessThanEqualOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

lessThanEqualOperator

back to summary

protected ExpressionOperator lessThanEqualOperator()

DB2 z/OS requires that at least one argument be a known type

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

lessThanOperator	back to summary
protected ExpressionOperator lessThanOperator() Set binding support to PARTIAL. With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

lessThanOperator

back to summary

protected ExpressionOperator lessThanOperator()

Set binding support to PARTIAL.

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

likeEscapeOperator	back to summary
protected ExpressionOperator likeEscapeOperator() DB2 z/OS support for binding the LIKE ESCAPE character depends on database configuration (mixed vs DBCS). Since we cannot know how the database in configured, we will disable parameter binding for the ESCAPE With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

likeEscapeOperator

back to summary

protected ExpressionOperator likeEscapeOperator()

DB2 z/OS support for binding the LIKE ESCAPE character depends on database configuration (mixed vs DBCS). Since we cannot know how the database in configured, we will disable parameter binding for the ESCAPE

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

lnOperator	back to summary
protected ExpressionOperator lnOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

lnOperator

back to summary

protected ExpressionOperator lnOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

locate2Operator	back to summary
protected ExpressionOperator locate2Operator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610 With binding enabled, DB2 z/OS will throw an error: The data type, the length, or the value of an argument of a scalar function is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815

locate2Operator

back to summary

protected ExpressionOperator locate2Operator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

With binding enabled, DB2 z/OS will throw an error:

The data type, the length, or the value of an argument of a scalar function 
is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815

locateOperator	back to summary
protected ExpressionOperator locateOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610 With binding enabled, DB2 z/OS will throw an error: The data type, the length, or the value of an argument of a scalar function is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815

locateOperator

back to summary

protected ExpressionOperator locateOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

With binding enabled, DB2 z/OS will throw an error:

The data type, the length, or the value of an argument of a scalar function 
is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815

ltrim2Operator	back to summary
protected ExpressionOperator ltrim2Operator() Overrides org.eclipse.persistence.platform.database.DB2Platform.ltrim2Operator. Disable binding support. With binding enabled, DB2 z/OS will throw an error: The data type, the length, or the value of an argument of a scalar function is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815 Annotations @Override

ltrim2Operator

back to summary

protected ExpressionOperator ltrim2Operator()

Overrides org.eclipse.persistence.platform.database.DB2Platform.ltrim2Operator.

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The data type, the length, or the value of an argument of a scalar function 
is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815

Annotations

@Override

ltrimOperator	back to summary
protected ExpressionOperator ltrimOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

ltrimOperator

back to summary

protected ExpressionOperator ltrimOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

modOperator	back to summary
protected ExpressionOperator modOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610 With binding enabled, DB2 z/OS will throw an error: The data type, the length, or the value of an argument of a scalar function is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815

modOperator

back to summary

protected ExpressionOperator modOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

With binding enabled, DB2 z/OS will throw an error:

The data type, the length, or the value of an argument of a scalar function 
is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815

notBetweenOperator	back to summary
protected ExpressionOperator notBetweenOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

notBetweenOperator

back to summary

protected ExpressionOperator notBetweenOperator()

DB2 z/OS requires that at least one argument be a known type

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

notEqualOperator	back to summary
protected ExpressionOperator notEqualOperator() DB2 z/OS requires that at least one argument be a known type With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

notEqualOperator

back to summary

protected ExpressionOperator notEqualOperator()

DB2 z/OS requires that at least one argument be a known type

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator—for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

notLikeEscapeOperator	back to summary
protected ExpressionOperator notLikeEscapeOperator() DB2 z/OS support for binding the LIKE ESCAPE character depends on database configuration (mixed vs DBCS). Since we cannot know how the database in configured, we will disable parameter binding for the ESCAPE With binding enabled, DB2 z/OS will throw an error: The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

notLikeEscapeOperator

back to summary

protected ExpressionOperator notLikeEscapeOperator()

With binding enabled, DB2 z/OS will throw an error:

The statement string specified as the object of a PREPARE contains a 
predicate or expression where parameter markers have been used as operands of 
the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609

powerOperator	back to summary
protected ExpressionOperator powerOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

powerOperator

back to summary

protected ExpressionOperator powerOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

registerOutputParameter	back to summary
public void registerOutputParameter(CallableStatement statement, String name, int jdbcType) throws SQLException Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.registerOutputParameter. This method is used to register output parameter on Callable Statements for Stored Procedures as each database seems to have a different method. Annotations @Override

registerOutputParameter

back to summary

public void registerOutputParameter(CallableStatement statement, String name, int jdbcType) throws SQLException

Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.registerOutputParameter.

This method is used to register output parameter on Callable Statements for Stored Procedures as each database seems to have a different method.

Annotations

@Override

registerOutputParameter	back to summary
public void registerOutputParameter(CallableStatement statement, String name, int jdbcType, String typeName) throws SQLException Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.registerOutputParameter. This method is used to register output parameter on Callable Statements for Stored Procedures as each database seems to have a different method. Annotations @Override

registerOutputParameter

back to summary

public void registerOutputParameter(CallableStatement statement, String name, int jdbcType, String typeName) throws SQLException

Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.registerOutputParameter.

This method is used to register output parameter on Callable Statements for Stored Procedures as each database seems to have a different method.

Annotations

@Override

roundOperator	back to summary
protected ExpressionOperator roundOperator() Overrides org.eclipse.persistence.platform.database.DB2Platform.roundOperator. Disable binding support. With binding enabled, DB2 z/OS will throw an error: The data type, the length, or the value of an argument of a scalar function is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815 Annotations @Override

roundOperator

back to summary

protected ExpressionOperator roundOperator()

Overrides org.eclipse.persistence.platform.database.DB2Platform.roundOperator.

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The data type, the length, or the value of an argument of a scalar function 
is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815

Annotations

@Override

rtrim2Operator	back to summary
protected ExpressionOperator rtrim2Operator() Overrides org.eclipse.persistence.platform.database.DB2Platform.rtrim2Operator. Disable binding support. With binding enabled, DB2 z/OS will throw an error: The data type, the length, or the value of an argument of a scalar function is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815 Annotations @Override

rtrim2Operator

back to summary

protected ExpressionOperator rtrim2Operator()

Overrides org.eclipse.persistence.platform.database.DB2Platform.rtrim2Operator.

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The data type, the length, or the value of an argument of a scalar function 
is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815

Annotations

@Override

rtrimOperator	back to summary
protected ExpressionOperator rtrimOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

rtrimOperator

back to summary

protected ExpressionOperator rtrimOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

setNullFromDatabaseField	back to summary
protected void setNullFromDatabaseField(DatabaseField databaseField, CallableStatement statement, String name) throws SQLException Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.setNullFromDatabaseField. Annotations @Override

setNullFromDatabaseField

back to summary

protected void setNullFromDatabaseField(DatabaseField databaseField, CallableStatement statement, String name) throws SQLException

Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.setNullFromDatabaseField.

Annotations

@Override

setParameterValueInDatabaseCall	back to summary
public void setParameterValueInDatabaseCall(Object parameter, CallableStatement statement, String name, AbstractSession session) throws SQLException Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.setParameterValueInDatabaseCall. Doc from org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.setParameterValueInDatabaseCall. INTERNAL Set the parameter in the JDBC statement with the given name. This support a wide range of different parameter types, and is heavily optimized for common types. Annotations @Override @SuppressWarnings:rawtypes

setParameterValueInDatabaseCall

back to summary

public void setParameterValueInDatabaseCall(Object parameter, CallableStatement statement, String name, AbstractSession session) throws SQLException

Overrides org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.setParameterValueInDatabaseCall.

Doc from org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.setParameterValueInDatabaseCall.

INTERNAL Set the parameter in the JDBC statement with the given name. This support a wide range of different parameter types, and is heavily optimized for common types.

Annotations

@Override
@SuppressWarnings:rawtypes

signOperator	back to summary
protected ExpressionOperator signOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

signOperator

back to summary

protected ExpressionOperator signOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

sqrtOperator	back to summary
protected ExpressionOperator sqrtOperator() Disable binding support. With binding enabled, DB2 z/OS will throw an error: The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

sqrtOperator

back to summary

protected ExpressionOperator sqrtOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

sumOperator

back to summary

protected ExpressionOperator sumOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

trim2

back to summary

protected ExpressionOperator trim2()

Overrides org.eclipse.persistence.platform.database.DB2Platform.trim2.

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The data type, the length, or the value of an argument of a scalar function 
is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815

Annotations

@Override

trimOperator

back to summary

protected ExpressionOperator trimOperator()

Disable binding support.

With binding enabled, DB2 z/OS will throw an error:

The statement cannot be executed because a parameter marker has been used 
in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610

public Class DB2ZPlatform

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail