Messages 1000085 through 1000107

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

Error 1000085 "The join field array for table '%2' must have at least one entry. %1"
Constant
EMSG_HDB_FIELDNOJOINNAMES
SAP Sybase Error Number
20745
SQL State
QDA85
SQL Code
-1000085L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
tablename
Probable Cause
This an internal error. If this error occurs, it should be reported to Sybase.
Warning 1000086 "Length %1 %2%3%4"
Constant
EMSG_PREVIEWFILLERA
SAP Sybase Error Number
20746
SQL State
QDA86
SQL Code
1000086L
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 is an informational message displayed in context with other messages.
Warning 1000087 "Delimiter %1 %2%3%4"
Constant
EMSG_PREVIEWFILLERCD
SAP Sybase Error Number
20747
SQL State
QDA87
SQL Code
1000087L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
delimiter name
Parameter 2
Parameter 2 description
Parameter 3
Parameter 3 description
Parameter 4
Parameter 4 description
Probable Cause
This is an informational message displayed in context with other messages.
Warning 1000088 "Offset %1, Length %2, %3 nulls, %4%5%6 %7"
Constant
EMSG_PREVIEWOFFSET
SAP Sybase Error Number
20748
SQL State
QDA88
SQL Code
1000088L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
offset
Parameter 2
length
Parameter 3
nulls
Parameter 4
parameter 4 description
Parameter 5
parameter 5 description
Parameter 6
parameter 6 description
Parameter 7
parameter 7 description
Probable Cause
This is an informational message displayed in context with other messages.
Warning 1000089 "Length %1, %2 nulls, %3%4%5 %6"
Constant
EMSG_PREVIEWLENGTH
SAP Sybase Error Number
20749
SQL State
QDA89
SQL Code
1000089L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
length
Parameter 2
nulls
Parameter 3
parameter 3 description
Parameter 4
parameter 4 description
Parameter 5
parameter 5 description
Parameter 6
parameter 6 description
Probable Cause
This is an informational message displayed in context with other messages.
Warning 1000090 "%1, %2 nulls, %3%4%5 %6"
Constant
EMSG_PREVIEWPREFIX1
SAP Sybase Error Number
20750
SQL State
QDA90
SQL Code
1000090L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
length
Parameter 2
nulls
Parameter 3
parameter 3 description
Parameter 4
parameter 4 description
Parameter 5
parameter 5 description
Parameter 6
parameter 6 description
Probable Cause
This is an informational message displayed in context with other messages.
Warning 1000091 "%1, %2 nulls, %3%4%5 %6"
Constant
EMSG_PREVIEWPREFIX2
SAP Sybase Error Number
20751
SQL State
QDA91
SQL Code
1000091L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
length
Parameter 2
nulls
Parameter 3
parameter 3 description
Parameter 4
parameter 4 description
Parameter 5
parameter 5 description
Parameter 6
parameter 6 description
Probable Cause
This is an informational message displayed in context with other messages.
Error 1000092 "Table %2 must have a name for the join field array. %1"
Constant
EMSG_HDB_TABLENOJOINNAME
SAP Sybase Error Number
20752
SQL State
QDA92
SQL Code
-1000092L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
explanation for %2
Probable Cause
This is an internal error. If this error occurs, it should be reported to Sybase.
Warning 1000093 "%1, %2 nulls, %3%4%5 %6"
Constant
EMSG_PREVIEWPREFIX4
SAP Sybase Error Number
20753
SQL State
QDA93
SQL Code
1000093L
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
Parameter 6
Parameter 6 description
Probable Cause
This is an informational message displayed in context with other messages.
Error 1000094 "Sufficient memory cannot be found for the LOAD. Increasing the Load_Memory_MB or decreasing the BLOCK FACTOR or BLOCK SIZE will allow the LOAD to proceed. %1"
Constant
EMSG_BLOCK_FACTOR_SIZE_LOAD_MEMORY
SAP Sybase Error Number
20754
SQL State
QDA94
SQL Code
-1000094L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
Location of the exception.
Probable Cause
When the user explicitly sets Load_Memory_MB, the LOAD process applies various heuristics for load parameters in an attempt to find a combination such that the memory required is not more than what the user specified. For a fixed width LOAD, BLOCK FACTOR indicates the minimal number of rows that must be read into memory for each read. The default BLOCK FACTOR is 10,000. Decreasing the BLOCK FACTOR will make the LOAD's internal memory requirements smaller. For a variable length input LOAD, BLOCK SIZE represents the size in bytes in which input data should be read. The default BLOCK SIZE is 500,000 bytes. Decreasing the BLOCK SIZE for a variable width input load will reduce LOAD's memory requirements. Alternatively, the Load_Memory_MB option setting could be raised.
Warning 1000096 "Delimiter %1 %2 nulls, %3%4%5 %6"
Constant
EMSG_PREVIEWCD
SAP Sybase Error Number
20756
SQL State
QDA96
SQL Code
1000096L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
1
Parameter 1
delimiter
Parameter 2
nulls
Parameter 3
parameter 3 description
Parameter 4
parameter 4 description
Parameter 5
parameter 5 description
Parameter 6
parameter 6 description
Probable Cause
This is an informational message displayed in context with other messages.
Error 1000097 "Parse Error in Command String at '%2'. %1"
Constant
EMSG_PARSEERROR
SAP Sybase Error Number
20757
SQL State
QDA97
SQL Code
-1000097L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
23
Parameter 1
location of the exception
Parameter 2
Start of the parse error
Probable Cause
Consult the IQ reference manual for the DBCC grammar
Error 1000099 "The PAGE SIZE divided by the BLOCK SIZE must be equal to 2, 4, 8, or 16. DATABASE: %2 PAGE SIZE: %3 BLOCK SIZE: %4 %1"
Constant
EMSG_HDB_INVALIDCHUNKSIZE
SAP Sybase Error Number
20759
SQL State
QDA99
SQL Code
-1000099L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Parameter 2
database name
Parameter 3
page size
Parameter 4
block size
Probable Cause
(PAGE SIZE)/(BLOCK SIZE) must be one of 2, 4, 8, 16. Adjust the PAGE SIZE or the BLOCK SIZE in the CREATE DATABASE statement.
Error 1000100 "Cannot INSERT, LOAD, or UPDATE a join virtual table. %1"
Constant
EMSG_SQL_NOINSERTJVT
SAP Sybase Error Number
20760
SQL State
QDB00
SQL Code
-1000100L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception
Probable Cause
The user is not allowed to INSERT to or LOAD a join virtual table. Instead you must INSERT to or LOAD the tables which participate in the join and and execute the SYNCHRONIZE command.
Error 1000101 "%2 not supported by Sybase IQ. %1"
Constant
EMSG_SQL_STMT_NOTSUPPORTED
SAP Sybase Error Number
20761
SQL State
QDB01
SQL Code
-1000101L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
sql statement type
Parameter 2
location of the exception
Probable Cause
The statement in question is not supported by Sybase IQ.
Error 1000103 "Cannot find an index for field '%2'. Every field must have at least one index. Current IndexCount = %3. %1"
Constant
EMSG_CAT_FIELD_HAS_NOINDEX
SAP Sybase Error Number
20763
SQL State
QDB03
SQL Code
-1000103L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
Field name
Parameter 2
Number of indexes found for the named field.
Parameter 3
location of the exception
Probable Cause
This error should not occur during normal operation. Every field in ASIQ will have at least one index (the automatically generated FP index). This error occurs, the operation should be retried. If the error persists, it should be reported to Sybase. Extra information may have been output to the iqmsg file.
Warning 1000104 "in join virtual table '%1'%2"
Constant
EMSG_DELETE_CBTNAMEJOIN
SAP Sybase Error Number
20764
SQL State
01B04
SQL Code
1000104L
ODBC 2 State
OK
ODBC 3 State
OK
Severity Code
10
Parameter 1
Parameter 1 description
Parameter 2
Parameter 2 description
Probable Cause
This is an informational message displayed in context with other messages.
Warning 1000105 "%1"
Constant
EMSG_DELETE_CBTNAME1TABLE
SAP Sybase Error Number
20765
SQL State
01B05
SQL Code
1000105L
ODBC 2 State
OK
ODBC 3 State
OK
Severity Code
10
Parameter 1
Parameter 1 description
Probable Cause
This is an informational message displayed in context with other messages.
Error 1000106 "Local temporary table, %2, must be committed in order to create an index. %1"
Constant
EMSG_CAT_CANNOT_CREATEIDX_ONLTT
SAP Sybase Error Number
20766
SQL State
QDB06
SQL Code
-1000106L
ODBC 2 State
ERROR
ODBC 3 State
ERROR
Severity Code
14
Parameter 1
location of the exception.
Parameter 2
Tablename
Probable Cause
To be able to create an index for a local temporary table, the table must be in a committed state. If this message occurs, the user has tried to execute a CREATE INDEX on a local temporary table that has had data inserted, deleted, or updated that has not yet been committed.
Warning 1000107 "For table '%1' in join virtual table '%2', \n%3 left outer rows with %4 columns will be moved (inserted/deleted).\n"
Constant
EMSG_DELETE_CBTLOUTERROWSMOVED
SAP Sybase Error Number
20767
SQL State
01B07
SQL Code
1000107L
ODBC 2 State
OK
ODBC 3 State
OK
Severity Code
10
Parameter 1
tablename
Parameter 2
join virtual table
Parameter 3
number of rows moved
Parameter 4
number of columns
Probable Cause
This is an informational message displayed in context with other messages. The message displays the number of rows moved during an insert to or delete from a join.
Parent topic: 1630 - 1000133