No. 9000 ~ 9999
9001: File \'%1$s\' was not found.
Cause The file does not exist.
Action Check if the file exists or use another file.
9002: Input file was not specified.
Cause An input file was not specified.
Action Specify an input file.
9003: Multiple input files were specified.
Cause Two or more input files were specified.
Action Specify only one input file.
9004: Unable to open file \'%1$s\'.
Cause Cannot open the output file.
Action Verify that the file name is correct.
9005: Unable to locate configuration file \'%1$s\'.
Cause The configuration file could not be found.
Action Verify that the path to the configuration file is correct.
9006: Unrecognized file format.
Cause Invalid file extension.
Action The input file name must have an extension.
9007: File name is too long.
Cause The input file name is over 256 bytes long.
Action Reduce the length of the file name.
9008: Cursor \'%1$s\' is undefined.
Cause Undefined cursor name.
Action Verify that the cursor name is correct.
9009: Database \'%1$s\' is undefined.
Cause Undefined DB name.
Action Verify that the DB name is correct.
9010: Invalid DML statement.
Cause The DML statement syntax is incorrect.
Action Verify that the syntax of the DML statement is correct.
9011: Invalid dynamic SQL syntax.
Cause The dynamic SQL statement is invalid for the ANSI mode.
Action Use a dynamic SQL statement that is valid for the ANSI mode.
9012: CONTEXT USE statement was not found.
Cause A CONTEXT USE statement was not used to specify context application.
Action Use a CONTEXT USE statement.
9013: THREADS option is not enabled.
Cause To use a thread-related command, the THREADS option needs to be set to YES.
Action Set the THREADS option to YES.
9014: Context not allocated.
Cause The context is not allocated.
Action Allocate the context.
9015: Invalid parameter expression \'%1$s\'.
Cause The parameter expression is invalid.
Action Check the expression syntax.
9016: Host variable \'%1$s\' must be declared in the declare section.
Cause The host variable is not declared in the declare section.
Action In ANSI or ISO mode, only variables declared between the EXEC be used as a host variable.
9017: Array size of host variable \'%1$s\' is out of range.
Cause The array size of the host variable is invalid.
Action Modify the array size of the host variable so that it is an integer greater than 1.
9018: Undeclared identifier \'%1$s\'.
Cause The identifier is not defined.
Action Define the identifier.
9019: Undefined structure \'%1$s\'.
Cause The structure is not defined.
Action Define the structure.
9020: Undefined type \'%1$s\'.
Cause The type is not defined.
Action Define the type.
9021: \'%1$s\' is not defined as a struct.
Cause Only objects defined as structures may be used in that manner.
Action Use an object that is defined as a structure.
9022: Invalid indirection object \'%1$s\'.
Cause Accessed a pointer with a period (.), or accessed non-pointer with an arrow (->).
Action Review the item and use the correct access method.
9023: \'%1$s\' is not a member of structure \'%2$s\'.
Cause Undefined member of a structure.
Action Define the object as a member of the structure.
9024: Parameter \'%1$s\' cannot be multi-dimensional.
Cause An attempt was made to bind a multi-dimensional array type.
Action Modify the bind parameter.
9025: Arrays of structs must be named.
Cause No name is defined for the host structure declared as array.
Action Specify a name for the structure.
9026: Structure variable \'%1$s\' has a nested structure.
Cause A structure cannot be bound in another structure.
Action Delete the nested structure definition.
9027: Structure \'%1$s\' cannot have members that are arrays.
Cause An array cannot be a member of the structure.
Action Remove the array from the members of the structure.
9028: Invalid VARCHAR format: must be a 1 or 2 dimensional array.
Cause The format of VARCHAR is invalid.
Action If VARCHAR is an invalid array, modify it and re-declare it.
9029: Cursor \'%1$s\' is already defined.
Cause The cursor name is already defined.
Action Use another cursor name.
9030: Database \'%1$s\' is already defined.
Cause The DB name is already defined.
Action Use another DB name.
9031: Prepared statement \'%1$s\' was not found.
Cause No SQL statement is prepared yet.
Action Prepare an SQL statement.
9033: Indicator variable \'%1$s\' must be a SHORT type
Cause The indicator variable is not a SHORT type.
Action Declare the indicator variable as a SHORT type.
9034: Indicator variable \'%1$s\' for host variable \'%2$s\' cannot be a structure.
Cause The indicator variable cannot be a structure because the host variable is not a structure.
Action Match the type of host variable to the type of indicator variable.
9035: Indicator variable \'%1$s\' must be a structure.
Cause The indicator variable must be a structure because the host variable is a structure.
Action The indicator variable must be defined as a structure.
9036: Indicator variable \'%1$s\' must have the same dimensions as the param variable
Cause The host variable has different dimensions as the indicator variable.
Action The indicator variable must have the same dimensions as the host variable.
9037: Invalid use of signed or unsigned operator.
Cause Invalid signed or unsigned operator has been used to defined variables.
Action Delete signed or unsigned operator.
9038: Invalid type declared.
Cause Invalid type declared.
Action Check if a structure or typedef definition is used with a primitive type.
9039: Two or more data types are in declaration.
Cause Invalid type declaration.
Action Check if the declaration of structure or typedef is duplicated.
9040: Duplicate signed or unsigned operators exist.
Cause More than one signed or unsigned operator.
Action Correctly mark signed or unsigned.
9041: Array value \'%1$s\' is not allowed in WHERE clauses of a SELECT statement.
Cause Array variables cannot be used in WHERE clauses of a SELECT statement.
Action Change array variables in WHERE clauses of the SELECT statement into general variables.
9042: When updating, if any host variable is an array type, all host variables must be.
Cause When updating, if at least one of host variables is an array type, all host variables should be array type, and vice versa.
Action Declare all host variables as array.
9043: Table was not found.
Cause The table does not exist or is not declared in any clause.
Action Declare the table.
9044: Invalid column name(s).
Cause The column(s) could not be found.
Action Check the name of the column(s).
9045: Invalid DML syntax %1$s.
Cause Invalid DML syntax.
Action Verify that the DML syntax is correct.
9046: Invalid ESQL syntax %1$s.
Cause Invalid ESQL syntax .
Action Verify that the ESQL syntax is correct.
9047: Invalid C syntax.
Cause Invalid C syntax.
Action Verify that the C syntax is correct.
9048: Failure while preprocessing %1$s.
Cause Failed to preprocess C programming language.
Action Locate the cause of the error and modify it.
9049: Unexpected identifier %1$s.
Cause The SQL statement starts with a string that is not an ESQL directive.
Action Verify that the ESQL syntax is correct.
9050: Invalid use of AT clause.
Cause The syntax should not contain an AT clause.
Action Delete the AT clause.
9051: Host variable type is not compatible with column type.
Cause The host variable type is not compatible with the column type of the table.
Action Check the type of host variable.
9052: Parameter count does not match column count.
Cause The number of parameters is different from the number of columns.
Action Check the number of parameters.
9053: Semantics check failed at server.
Cause Failed to check semantics using server.
Action Verify that the semantics are correct.
9054: Invalid option.
Cause Unsupported option.
Action Delete the option.
9055: Option \'%1$s\' cannot be used here.
Cause The option cannot be used here.
Action Check the location (config file, command line, etc.) where location.
9056: Option value type \'%1$s\' is invalid.
Cause Invalid type of option value.
Action Check the type of the option value.
9057: Option value \'%1$s\' of %2$s is invalid.
Cause Invalid option value.
Action Check the option value.
9058: Option \'%1$s\' was not found.
Cause Undefined option.
Action Verify that the option exists.
9059: Incomplete multiple option value.
Cause Invalid format of the option value.
Action Check the format of the option value.
9060: USERID option should be specified when SQLCHECK=SE MANTICS or FULL.
Cause If SQLCHECK=SEMANTICS (or FULL), USERID should be also specified.
Action Specify the USERID option.
9061: User ID \'%1$s\' is too long.
Cause User ID must be less than 128 bytes.
Action Reduce the size of the user ID.
9062: Password is too long.
Cause Password must be less than 63 bytes.
Action Reduce the size of the password.
9063: SQLCHECK=SEMANTICS must be specified when embedded PSM blocks are used.
Cause Embedded PSM block was used without the SQLCHECK=SEMANTICS option.
Action Specify the SQLCHECK=SEMANTICS option.
9064: Unable to connect to server.
Cause Failed to access the server for semantics check.
Action Check the connection information and server status.
9067: Improperly terminated C comment.
Cause A C comment beginning with '/*' was not terminated.
Action Terminate the comment properly.
9068: Improperly terminated UNION.
Cause UNION is not properly terminated.
Action Check the syntax.
9069: C preprocessing failed.
Cause Failure while preprocessing C programming language.
Action Correct the error as shown in the additional messages.
9071: Not logged into the server.
Cause Not properly connected to the server.
Action Connect to the server and retry.
9074: Host variable address is NULL.
Cause The address of the host variable is NULL.
Action Specify a valid host variable.
9075: Cursor was not found.
Cause The cursor to be used is not declared.
Action Declare the cursor first.
9076: In ANSI mode, already-closed cursors may not be closed again.
Cause Closed cursors cannot be closed again in ANSI mode.
Action Make sure that the specified cursor isn't already closed.
9077: In ANSI mode, already-opened cursors may not be opened again.
Cause Opened cursors cannot be opened again in ANSI mode.
Action Make sure that the specified cursor isn't already open.
9078: Invalid parameter type.
Cause Invalid parameter type.
Action Verify that the parameter type is correct.
9079: Invalid connection string.
Cause Invalid connection string.
Action Verify that the connection string is correct.
9080: Invalid use of output parameter.
Cause Invalid use of output parameter.
Action Check the output parameter.
9081: Invalid use of input parameter.
Cause Invalid use of input parameter.
Action Check the input parameter.
9082: Unspecified cursor name.
Cause A cursor name was not specified.
Action Specify the cursor name.
9083: Unspecified prepared statement name.
Cause The prepared statement name is unspecified.
Action Specify the name of the prepared statement.
9084: Unspecified database name.
Cause The database name is unspecified.
Action Specify the name of the database.
9085: Invalid database name
Cause The length of database name is 0.
Action Specify a DB name.
9086: Undefined prepared statement name.
Cause The prepared statement that was used is not defined..
Action Verify that the name of the prepared statement is correct.
9087: Input descriptor has not been described.
Cause Describe input for descriptor has not been performed.
Action Perform describe input first.
9088: Undefined SQLDA variable.
Cause The SQLDA variable that was used is not defined.
Action Define the SQLDA variable first.
9089: No connection to database.
Cause The connection opened with the database name does not exist.
Action Make a connection first.
9090: Database connection is closed.
Cause The specified database connection is closed.
Action Try to reconnect.
9091: Cursor operation on wrong database.
Cause This cursor is not defined for the specified database.
Action Specify the correct database name.
9092: Number of output parameters does not match number of output columns.
Cause The number of output parameters does not match the number of output columns.
Action Ensure that the quantities match.
9093: Number of bind variables does not match number of param eters.
Cause The number of bind variables does not match the number of parameters.
Action Ensure that the quantities match.
9094: Indicator variable was not specified in INTO clause.
Cause The indicator variable was not specified in the INTO clause.
Action Specify the indicator variable for the INTO clause.
9095: Too many rows were returned by SELECT statement.
Cause Too many rows were returned by a select statement.
Action Ensure that the expected number of rows does not violate any constraints.
9096: Charmap failed.
Cause The result does not match the given charmap.
Action Make sure the result value is not null or an invalid value.
9097: Fetch out of sequence.
Cause The statement has been executed in wrong sequence.
Action Execute ESQL statements according to the fetch execution sequence.
9098: Duplicate descriptor name exists.
Cause The descriptor name already exists.
Action Use another name for the descriptor.
9099: Unknown descriptor.
Cause The descriptor has not been assigned.
Action Assign the descriptor first.
9100: Undefined descriptor name.
Cause An attempt was made to use an undefined descriptor.
Action Verify that the name of the descriptor is correct.
9102: Host structure \'%1$s\' cannot be used in embedded PSM or dynamic SQL.
Cause An attempt was made to use a host structure for embedded PSM or dynamic SQL.
Action Use a general variable type, not a structure.
9103: Include file \'%1$s\' does not exist.
Cause The file to be included does not exist.
Action Specify a valid file path with the INCLUDE option.
9104: Option \'%1$s\' cannot be used for this host language.
Cause This option cannot be used for this host language.
Action Check the locations where this option can be used (config file, command line, etc.).
9105: Invalid COBOL syntax.
Cause Invalid COBOL syntax.
Action Verify that the COBOL syntax is correct.
9106: Preprocessing failed at line %1$d because of %2$s.
Cause Preprocessing of COBOL language failed.
Action Locate the cause of the failure and fix it.
9107: Invalid argument \'%1$s\'.
Cause Invalid argument.
Action Check the help file for the Precompile utility.
9108: Invalid include file\n%1$s.
Cause An invalid header file has been included.
Action Verify that the header file is correct.
9109: Reserve word \'defined\' cannot be used as macro name.
Cause An attempt was made to use \'defined\' as a macro name.
Action Change the macro name.
9110: Macro name not specified in #%1$s directive.
Cause A macro name was not specified in #%1$s directive.
Action Modify the macro.
9111: Invalid macro name.
Cause The macro name is inappropriate.
Action Modify the macro to follow the syntax of C programming language.
9112: Invalid #%1$s syntax.
Cause #%1$s syntax is invalid.
Action Use #%1$s "file name" or #%1$s <file name>.
9113: Recursive #include file.
Cause The #include file is recursive.
Action Check the #include files and fix the recursion problem.
9114: Invalid #%1$s directive.
Cause The #%1$s directive is invalid.
Action Modify the #%1$s directive.
9115: Invalid #pragma GCC poison directive.
Cause The #pragma GCC poison directive is invalid.
Action Modify the #pragma GCC poison directive.
9116: Invalid pragma.
Cause The pragma is invalid.
Action Modify the pragma syntax.
9117: Invalid conditional syntax (if-else-endif).
Cause The syntax of the conditional clause (IF-ELSE-ENDIF) is invalid.
Action Correct the clause syntax.
9118: Non-terminated #%1$s directive.
Cause The #%1$s directive is non-terminated.
Action Fix the directive syntax.
9119: Invalid predicate syntax in #assert and #unassert.
Cause Predicate syntax used in #assert and #unassert is invalid.
Action Modify the syntax.
9120: Unable to paste %1$s and %2$s because they generate an invalid preprocessing token.
Cause Cannot paste the two specified tokens together.
Action Modify the setting syntax.
9121: Too many arguments specified for \'%1$s\' macro: %2$u ar guments accepted, %3$u arguments specified.
Cause The \'%1$s\' macro accepts %2$u arguments, but %3$u arguments were specified.
Action Modify the clause with the \'%1$s\' macro.
9122: Arguments specified for \'%1$s\' macro are not terminated.
Cause One or more arguments of the \'%1$s\' macro are not terminated.
Action Modify the setting syntax.
9123: Duplicate parameter \'%1$s\' exists in macro.
Cause The \'%1$s\' parameter of the macro is specified twice.
Action Delete one of the duplicate parameters.
9124: Unknown \'%1$s\' parameter in macro.
Cause \'%1$s\' is not in the macro parameter list.
Action Verify that the parameter name is correct.
9125: Invalid macro parameter syntax.
Cause Macro parameter syntax is invalid.
Action Correct the macro parameter syntax.
9126: The # token is not in macro parameter list.
Cause # token is not in the macro parameter list.
Action Modify the setting syntax.
9127: Invalid syntax near \'##\' operator.
Cause The syntax of the part using the \'##\' operator is bad.
Action Modify the setting to meet the syntax.
9128: Conditional expression contains a division by zero error.
Cause The conditional expression contains division by 0 error.
Action Modify the conditional expression.
9129: Invalid syntax when using the \'defined\' operator.
Cause The \'defined\' operator uses invalid syntax.
Action Modify the syntax used with the operator.
9130: Unable to open the \'%1$s\' file.
Cause Unable to open the \'%1$s\' file.
Action Specify a valid file path.
9131: Invalid size of VARCHAR \'%1$s\'.
Cause The length of the given VARCHAR is invalid.
Action Change the length of the VARCHAR.
9132: Invalid use of REF clause.
Cause A REF clause may not be used here.
Action Delete the invalid REF clause.
9133: Copy/include file \'%1$s\' in line %2$d was not found.
Cause No file to copy or include.
Action Specify a valid file to copy or include with the INCLUDE option.
9134: Invalid line continuation.
Cause The continued line does not follow COBOL programming language syntax.
Action Locate out the cause of the error and fix it.
9135: Host variable \'%1$s\' is of an invalid type.
Cause This type of host variable is not supported.
Action Find out the cause of the failure, and modify the part having the problem in the message.
9136: Indicator variable \'%1$s\' must be int type because of IND_TYPE option
Cause Indicator variable must be int type because IND_TYPE is 32bit.
Action Declare indicator variable as int type.
9137: Unhandled character \'%1$s\'.
Cause Invalid character.
Action Check that the character is placed in the correct location.
9138: Invalid host variable \'%1$s\'.
Cause Invalid host variable.
Action Check that the variable is placed in the correct location.
9139: Missing trailing NULL character.
Cause A host variable of external data type 5 was not terminated with a NULL character.
Action Add NULL to the end of the character string.
9140: Invalid iteration count.
Cause Invalid iteration count.
Action Iteration count must contain an integer value of 1 or greater.
9141: Invalid parameter data length (dynamic method 4)
Cause Invalid parameter data length (dynamic method 4)
Action Set the variable length to a correct value.
9142: Semantics check failed during the communication process.
Cause Failed to check semantics with the server due to communication problems.
Action Check the communication status with server.
9143: Execute 'client/config/gen_esql_cfg.sh' from the database home directory.
Cause ESQL configuration has not yet been performed.
Action Execute the 'gen_esql_cfg.sh' file from the 'client/config' directory under the database home directory.
9144: Invalid 'EXEC SQL INCLUDE' statement.
Cause Invalid EXEC SQL INCLUDE statement.
Action Modify the syntax of the EXEC SQL INCLUDE statement.
9145: Invalid parameter data type (dynamic method 4)
Cause Invalid parameter data type (dynamic method 4)
Action Check whether the variable type is valid.
9146: Invalid parameter data type (ANSI dynamic method 4)
Cause Invalid type of bind variable (ANSI type dynamic SQL method 4).
Action Verify that the bind variable type is valid.
9147: Expression was previously declared with a specific database connection.
Cause The expression used in PREPARE was previously declared to use a particular database connection.
Action Do not use an AT clause, or modify the DECLARE clause.
9148: Unable to use ESQL statement in ordinary C include file.
Cause An ESQL statement is used in an included header file.
Action To use an ESQL statement, use an EXEC SQL INCLUDE statement.
9150: Unable to open directory \'%1$s\': Permission denied.
Cause Not authorized to access this directory.
Action Receive authorization to open the directory.
9151: \'%1$s\' is not a directory.
Cause The path after #include does not specify a valid directory.
Action Specify a valid directory.
9152: Precision or scale is out of range.
Cause The precision or scale of the declared type is out of range.
Action Check the precision or scale, and enter a value that is within range.
9153: Dynamic SQL is not DML.
Cause The SQL is not DML.
Action Check the SQL.
9154: Dynamic SQL is DDL.
Cause The SQL is DDL.
Action Check the SQL.
9155: Dynamic SQL is PSM.
Cause The SQL is PSM.
Action Check the SQL.
9156: The size of esql log file is wrong.
Cause The size of log file is too large or too small.
Action Check the esql config file, enter a value that is within the range(>= 1M and <= 1G).
9157: The length in the host variable is wrong.
Cause The lengths in the host variable and in the length field do not match.
Action Check the code and fix the length field of SQLDA or the length in the host variable(VAR CHAR or other type).
9158: The number of bind variables does not match the number of attributes.
Cause The number of bind variables does not match the number of attributes.
Action Check the numbers of bind variables and attributes.
9159: Unable to create output file \'%1$s\'.
Cause Output file name is same with Input file name.
Action Verify that the output file name is different from input file name.
9160: Multiple output files were specified.
Cause Two or more output files were specified.
Action Specify only one output file.
9161: Ambiguous variable \'%1$s\' is referenced.
Cause Ambiguous variable \'%1$s\' is referenced.
Action Check the host variable.
9162: Database name is too long.
Cause Database name must be less than 128 bytes.
Action Reduce the size of the database name.
9163: Invalid dynamic SQL method-2.
Cause The dynamic SQL statement must not be a query (SELECT statement).
Action Use a dynamic SQL method 3, 4 or modify the dynamic SQL.
9164: Struct Indicator member count does not match struct host variable member count.
Cause The number of struct indicator members is different from the number of struct host variable members.
Action Check the number of struct indicator members.
9165: Invalid PL/1 syntax.
Cause Invalid PL/1 syntax.
Action Verify that the PL/1 syntax is correct.
9166: Database was not installed successfully.
Cause Database was not installed successfully.
Action Execute the install batch file in the bin directory of the Database Home.
9167: Not yet implemented.
Cause This function has yet to be implemented.
Action This function has yet to be implemented.
9168: Failed to free CLI ENVIRONMENT HANDLE.
Cause Failed to free CLI ENVIRONMENT HANDLE while deleting esql context manager
Action Check the statements related to ENVIRONMENT HANDLE.
9169: Not yet Implemented
Cause This feature is currently not available.
Action Please go around the problem or contact the manufacturer.
9170: Error code from Oracle
Cause Error has occured while interacting with Oracle binary.
Action Please check error code(sqlca.oracode) from Oracle's error utility.
9171: Failed to return CLI HANDLE.
Cause Unable to find expected CLI HANDLE.
Action Check the status of the connection or the parameters for ESQLGetHandle().
9172: ODBC connection is closed or failed to connect.
Cause ODBC connection is closed or failed to connect.
Action Check the status of the connection or ID/PASSWD.
9173: Invalid COBOL syntax \'%1$s\'.
Cause Invalid COBOL syntax.
Action Verify that the COBOL syntax is correct.
9174: using WHERE CURRENT OF on cursor defined without FOR UPDATE clause
Cause using WHERE CURRENT OF on cursor defined without FOR UPDATE clause
Action Check the cursor statement whether FOR UPDATE clause is defined or not
9175: ODBC general error
Cause General error(HY000) caused by ODBC
Action Check the error message on application
Last updated