Error 1000229

"Only BINARY [WITH NULL BYTE] can be used as a column specification when using UNLOAD FORMAT. %1"

Item Description

SQLCode

-1000229L

Constant

EMSG_CANTUSEINLOAD

SQLState

QDC38

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

20998

Severity Code

14

Parameter 1

location of the exception

Probable cause

When using UNLOAD FORMAT, you cannot specify any column specification other than BINARY. If need to load null values for a column using the BINARY column spec, you must specify the WITH NULL BYTE option. You cannot use the [ROW] DELIMITED BY options with UNLOAD FORMAT.


Created November 10, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com