Troubleshooting Sybase Error Code from Error 20632 to 20646

SQLServerF1

Sybase Error Code 20632
Sybase SQL Code –1013062L
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
Sybase Error Code 20633
Sybase SQL Code –1013063L
Expected raw-data column type ‘%2’ on input, but no input data exists. %1
Sybase Error Code 20634
Sybase SQL Code –1013064L
Row delimiter not seen during scan of input file. At least one of the input rows is missing a terminator. %1
Sybase Error Code 20635
Sybase SQL Code –1013065L
Row delimiter ‘%2’ and column delimiter ‘%3’ cannot be substrings of each other. %1

Sybase Error Code 20636
Sybase SQL Code –1013066L
The %2 load option can be specified only once. %1
Sybase Error Code 20637
Sybase SQL Code –1013067L
Option CONVERSION ERROR must be OFF when IGNORE CONSTRAINT DATA VALUE or ALL is specified. %1
Sybase Error Code 20638
Sybase SQL Code –1013068L
Constraint ‘%2’ violated: Invalid value for column ‘%3’ in table ‘%4’. %1
Sybase Error Code 20639
Sybase SQL Code –1008003L
Cannot drop join virtual table ‘%1’.
Sybase Error Code 20640
Sybase SQL Code –1013070L
Cannot specify check constraints off and ignore all, ignore check, logl all or log check during load. %1

Sybase Error Code 20641
Sybase SQL Code –1013071L
Constraint ‘%2’ violated: Invalid value in table ‘%3’. %1
Sybase Error Code 20642
Sybase SQL Code –1008036L
Table %1 already has an Identity/Autoincrement Column.
Sybase Error Code 20643
Sybase SQL Code –1008037L
Cannot drop %1 %2: set option ‘identity_insert’ must be off.
Sybase Error Code 20644
Sybase SQL Code –1000293L
Cannot insert or update Column %2: set option ‘identity_insert’ to the specific table name containing the identity column to be modified. %1
Sybase Error Code 20645
Sybase SQL Code –1000294L
Cannot set ‘identity_insert’, it is already on for a different table. %1
Sybase Error Code 20646
Sybase SQL Code –1000295L
Invalid table name %2 specified for option ‘identity_insert’. %1

Above are list of Sybase Error Code Messages from Error Code 20632 to 20646 received while performing certain operation against Sybase Database or related products.

What are Sybase Error Codes?

Sybase error codes are a set of error codes for use by all Sybase products, including Adaptive Server Enterprise. For every Sybase error code returned by Sybase IQ, there is a pair of matching Sybase IQ error codes (SQLCODE and SQLSTATE). In many cases Sybase IQ error codes offer a finer level of granularity than their Sybase error code counterparts, thus some Sybase error codes in the following table are non-unique.

Many of the errors contain the characters %1, %2 and so on. These are replaced by the parameters to the error message.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Sybase Error Code Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *