Messages 1000062 through 1000084

Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.

Error 1000062 "Cannot add column '%3' with 'not null' constraint on table %2 with data. %1"
Constant
EMSG_TABLEHASDATA
SAP Sybase Error Number
20722
SQL State
QDC35
SQL Code
-1000062L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
table name
Parameter 3
column name
Probable Cause
The user tried to ALTER ADD a NOT NULL column to a table that has data. The newly added column would violate the NOT NULL constraint as it would have null data.
Error 1000063 "Cannot enforce the NOT NULL constraint. Column %2 has NULL data. %1"
Constant
EMSG_COLUMNHASNULLDATA
SAP Sybase Error Number
20723
SQL State
QDC34
SQL Code
-1000063L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
column name
Probable Cause
The user tried ALTER MODIFY column NOT NULL on a column that used to allow nulls and has null data. The user has to first delete the null rows before altering the column to enforce the NOT NULL constraint.
Error 1000064 "Column %2 can not be altered because it participates in join %3. %1"
Constant
EMSG_CAT_JOINFIELDINPREJOIN
SAP Sybase Error Number
20724
SQL State
QDA64
SQL Code
-1000064L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the error
Parameter 2
columns
Parameter 3
join
Probable Cause
A column/field that participates in a join cannot be altered. Joins on this field must be deleted before an ALTER can be performed.
Error 1000065 "Table %2 must be owned by the creator of the join. %1"
Constant
EMSG_CAT_TABLEOWNERDIFF
SAP Sybase Error Number
20725
SQL State
QDA65
SQL Code
-1000065L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the error
Parameter 2
tablename
Probable Cause
This error message is given during CREATE JOIN when one of the tables specified is not owned by the owner of the join. Joins can only be created from tables of the same owner.
Error 1000066 "ALTER on the column would interfere with the natural join to table %2 in join %3. %1"
Constant
EMSG_CAT_JOINFIELDNATMAT
SAP Sybase Error Number
20726
SQL State
QDA66
SQL Code
-1000066L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the error
Parameter 2
tablename
Parameter 3
join
Probable Cause
This message is displayed when using the ALTER command or adding columns to a table that participates in a join.
Error 1000067 "Table '%2' is not defined in the catalog. %1"
Constant
EMSG_CAT_TABLENOTINCAT
SAP Sybase Error Number
20727
SQL State
QDA67
SQL Code
-1000067L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
tablename
Probable Cause
This is an internal error. The table does not exist in the catalog. If this error occurs, it should be reported to Sybase.
Warning 1000069 " %1; %2 blocks; %3"
Constant
EMSG_DB_HEADER_MSG10
SAP Sybase Error Number
20729
SQL State
QDA69
SQL Code
1000069L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
argument 1 comment
Parameter 2
argument 2 comment
Parameter 3
argument 3 comment
Probable Cause
This message is an informational message displayed in context with other messages.
Warning 1000070 "File listing:"
Constant
EMSG_DB_HEADER_MSG11
SAP Sybase Error Number
20730
SQL State
QDA70
SQL Code
1000070L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Probable Cause
This message is an informational message displayed in context with other messages.
Warning 1000071 " %1"
Constant
EMSG_DB_HEADER_MSG14
SAP Sybase Error Number
20731
SQL State
QDA71
SQL Code
1000071L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
argument 1 comment
Probable Cause
This message is an informational message displayed in context with other messages.
Warning 1000072 "Hole listing (%1):"
Constant
EMSG_DB_HEADER_MSG20
SAP Sybase Error Number
20732
SQL State
QDA72
SQL Code
1000072L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
argument 1 comment
Probable Cause
This message is an informational message displayed in context with other messages.
Warning 1000073 " start: %1; size: %2"
Constant
EMSG_DB_HEADER_MSG21
SAP Sybase Error Number
20733
SQL State
QDA73
SQL Code
1000073L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
Parameter 1 description
Parameter 2
Parameter 2 description
Probable Cause
This message is displayed in context with other messages.
Warning 1000074 "Offset %1 Length %2, %3%4%5"
Constant
EMSG_PREVIEWFILLER
SAP Sybase Error Number
20734
SQL State
QDA74
SQL Code
1000074L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
Parameter 1 description
Parameter 2
Parameter 2 description
Parameter 3
Parameter 3 description
Parameter 4
Parameter 4 description
Parameter 5
Parameter 5 description
Probable Cause
This message is displayed in context with other messages.
Warning 1000075 "%1, %2%3%4"
Constant
EMSG_PREVIEWFILLER1
SAP Sybase Error Number
20735
SQL State
QDA75
SQL Code
1000075L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
Parameter 1 description
Parameter 2
Parameter 2 description
Parameter 3
Parameter 3 description
Parameter 4
Parameter 4 description
Probable Cause
This message is displayed in context with other messages.
Warning 1000076 "%1, %2%3%4"
Constant
EMSG_PREVIEWFILLER2
SAP Sybase Error Number
20736
SQL State
QDA76
SQL Code
1000076L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
Parameter 1 description
Parameter 2
Parameter 2 description
Parameter 3
Parameter 3 description
Parameter 4
Parameter 4 description
Probable Cause
This message is displayed in context with other messages.
Warning 1000077 "%1, %2%3%4"
Constant
EMSG_PREVIEWFILLER4
SAP Sybase Error Number
20737
SQL State
QDA77
SQL Code
1000077L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
Parameter 1 description
Parameter 2
Parameter 2 description
Parameter 3
Parameter 3 description
Parameter 4
Parameter 4 description
Probable Cause
This message is displayed in context with other messages.
Error 1000078 "IQ PAGE SIZE of '%2' for database '%3' is not valid. %1"
Constant
EMSG_HDB_INVALIDPAGESIZE
SAP Sybase Error Number
20738
SQL State
QDA78
SQL Code
-1000078L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
requested PAGE SIZE
Parameter 3
database name
Probable Cause
An invalid IQ PAGE SIZE was specified. IQ PAGE SIZE must be one of 1024, 2048, 4096, 8192, 16384, 32768, 65536, 131072, 262144, 524288. See the Reference Manual and Admin and Performance Guide for IQ PAGE SIZE recommendations.
Error 1000079 "IQ SIZE of '%2' for database '%3' is not valid. %1"
Constant
EMSG_HDB_INVALIDDATABASESIZE
SAP Sybase Error Number
20739
SQL State
QDA79
SQL Code
-1000079L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
requested IQ SIZE
Parameter 3
database name
Probable Cause
The maximum IQ SIZE is 128GB.
Error 1000082 "The insert must contain all of the table %2 columns because it participates in one or more joins. %1"
Constant
EMSG_INSRT_MUSTBE_FULLWIDTH
SAP Sybase Error Number
20742
SQL State
QDA82
SQL Code
-1000082L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
table name
Probable Cause
If a table participates in a join, then the user cannot load data into that table using a partial width insert.
Error 1000083 "The field array entry must be given a name. %1"
Constant
EMSG_HDB_FIELDNONAME
SAP Sybase Error Number
20743
SQL State
QDA83
SQL Code
-1000083L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
This is an internal error. If this error occurs, it should be reported to Sybase.
Error 1000084 "The %2th join field array entry for table '%3' must have a name. %1"
Constant
EMSG_HDB_FIELDNOJOINNAME
SAP Sybase Error Number
20744
SQL State
QDA84
SQL Code
-1000084L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
field array entry
Parameter 3
tablename
Probable Cause
This is an internal error. If this error occurs, it should be reported to Sybase.