Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL Code | Msg Type | Number | SQL State | Message | Possible Cause |
|---|---|---|---|---|---|
| -1013047L | Error | 20617 | QCA47 | "Cannot alter index '%2'. Only indexes in base tables or global temporary tables can be altered. %1" | Only indexes in base tables and global temporary tables listed in SYS.SYSINDEX can be altered. Click here for a list of possible parameters and odbc states. |
| 1013048L | Warning | 20618 | 01A48 | "Warning: Partial input record (%1 bytes) skipped at EOF (O/S %2). %3 rows read." | An incomplete input record was found at the end of the flat file. If the operating system error returned is not zero, you may need to take action as dictated by the error and try the LOAD again. Click here for a list of possible parameters and odbc states. |
| 1013049L | Warning | 20619 | 01A49 | "******* Possible Tape/File Error *******\n\n Bytes Read: %1, O/S errno: %2\n %3 rows read. Input suspended." | Take action as dictated by the operating system error and retry the operation. Click here for a list of possible parameters and odbc states. |
| -1013050L | Error | 20620 | QCA50 | "The Temp_Extract_Name1 option is set. The current operation will be rolled back. %1" | Certain operations will not be allowed whenever the Temp_Extract_Name1 option is set. They are: INSERT...VALUES, LOAD, DELETE, and INSERT...LOCATION if the table being inserted, SYNCHRONIZE join index. (Which also may be executed as part of CREATE JOIN INDEX.) loaded or deleted from is the top table in a join. INSERT...SELECT. For example, 'insert t1 select * from t2'. Click here for a list of possible parameters and odbc states. |
| -1013052L | Error | 20622 | QCA52 | "The BLOCK FACTOR for LOAD cannot be zero. %1" | The BLOCK FACTOR for LOAD cannot be zero. Click here for a list of possible parameters and odbc states. |
| -1013054L | Error | 20624 | QCA54 | "Delimiter '%2' must be 1 to %3 characters in length. %1" | The row or column delimiter in a LOAD statement must be 1-4 characters. Click here for a list of possible parameters and odbc states. |
| -1013055L | Error | 20625 | QCA55 | "ON_ERROR = 'CONTINUE' is valid only for a full-width INSERT. %1" | ON_ERROR = 'CONTINUE' is valid only for a full width insert. Click here for a list of possible parameters and odbc states. |
| -1013056L | Error | 20626 | QCA56 | "FILLER width must be greater than zero. %1" | FILLER width must be greater than zero. Click here for a list of possible parameters and odbc states. |
| -1013057L | Error | 20627 | QCA57 | "ASCII input column width must be greater than zero. %1" | ASCII input column width must be greater than zero. Click here for a list of possible parameters and odbc states. |
| -1013058L | Error | 20628 | QCA58 | "The row delimiter must be distinct from all column delimiters. %1" | The row delimiter cannot be the same as any column delimiter. Click here for a list of possible parameters and odbc states. |
| -1013059L | Error | 20629 | QCA59 | "The BLOCK SIZE option is not valid for a fixed-width input insert. %1" | You cannot specify BLOCK SIZE for a fixed-width input insert. Click here for a list of possible parameters and odbc states. |
| -1013060L | Error | 20630 | QCA60 | "The BLOCK FACTOR option is not valid for a variable width input insert. %1" | You cannot specify BLOCK FACTOR for a variable width input insert. Click here for a list of possible parameters and odbc states. |
| -1013061L | Error | 20631 | QCA61 | "Missing row delimiter detected during a row delimited insert. %1" | The input data is missing a row delimiter. Click here for a list of possible parameters and odbc states. |
| -1013062L | Error | 20632 | QCA62 | "Expected '%2' delimited column type on input, but encountered a row delimiter instead. Probable cause is a mismatch between the specified column delimiter and the column delimiter used in the input file. %1" | A row delimiter, rather than a column, was encountered during a LOAD. Probable cause is a mismatch between the specified column delimiter and the column delimiter used in the input file. Click here for a list of possible parameters and odbc states. |
| -1013063L | Error | 20633 | QCA63 | "Expected raw-data column type '%2' on input, but no input data exists. %1" | No data was found during a scan of an input file during insert. Click here for a list of possible parameters and odbc states. |
| -1013064L | Error | 20634 | QCA64 | "Row delimiter not seen during scan of input file. At least one of the input rows is missing a terminator. %1" | A row delimiter has been omitted from an input file. Click here for a list of possible parameters and odbc states. |
| -1013065L | Error | 20635 | QCA65 | "Row delimiter '%2' and column delimiter '%3' cannot be substrings of each other. %1" | Row and column delimiters cannot be substrings of each other. Click here for a list of possible parameters and odbc states. |
| -1013066L | Error | 20636 | QCA66 | "The %2 load option can be specified only once. %1" | The named load option can be specified only once per LOAD statement. Click here for a list of possible parameters and odbc states. |
| -1013067L | Error | 20637 | QCA67 | "Option CONVERSION ERROR must be OFF when IGNORE CONSTRAINT DATA VALUE or ALL is specified. %1" | When IGNORE CONSTRAINT DATA VALUE or ALL is given on a load statement, the database option CONVERSION ERROR must be off. Click here for a list of possible parameters and odbc states. |
| -1013068L | Error | 20638 | QCA68 | "Constraint '%2' violated: Invalid value for column '%3' in table '%4'. %1" | The Data being inserted or updated is invalid due to a column check constraint violation. Click here for a list of possible parameters and odbc states. |