Understanding the codes in the tables

Use this key for decoding the “Severity” column in Tables A-1 through A-9:

Information – no error or warning was detected, and the precompiler succeeded. The message is purely informational.
Warning – a noncritical error was detected, but the program precompiled.
Severe – an error occurred, and no code was generated. The precompilation failed.
Fatal – a severe error occurred from which the precompiler cannot recover. No further attempt will be made to process your files. Precompiler exits.

**Table A-1: Command line option messages**
Message ID	Message text	Severity	Fix
M_COMPAT_INFO	Compatibility mode specified.	Information	No fix required.
M_DUPOPT	Duplicate command line option specified.	Severe	Do not duplicate the options specified on the command line remove the offending duplicate option.
M_EXCFG_OVERRIDE	The switch value will have no effect because the external switch value has been specified.	Warning	When you use an external configuration file, you may override configuration options set on the command line. Choose one means of setting options.
M_INVALID_COMPAT	Unrecognized compatibility mode specified.	Information	No fix required.
M_INVALID_FILE_FMT	Invalid character in file value at line value.	Severe	Check to be sure that characters in the input file are valid and that you have correctly set the character set you want to use.
M_INVALID_FIPLEVEL	Invalid FIPS level specified.	Severe	Valid values are SQL-92E and SQL-89.
M_INVALID_SYNLEVEL	Invalid syntax checking level specified.	Severe	Valid values are NONE, SYNTAX, SEMANTIC.
M_INVLD_HLANG	Host Language specified is invalid.	Severe	Valid options are COB_MF1, COB_MF2, COB_RM1, COB_RM2, COB_LPI, COB_VAXVMS.
M_INVLD_OCLIB_VER	The Open Client Client-Library version is invalid.	Severe	The correct version string is "CS_VERSION_110" or later.
M_INVOPT	Option is invalid.	Severe	Invalid option specified. Substitute the correct value.
M_LABEL_SYNTAX	Security label is improperly specified; the proper format is ‘labelname= labelvalue’.	Severe	Use the allowed syntax.
M_MSGINIT_FAIL	Error initializing localized error messages.	Warning	Verify that the Sybase installation is complete and that there is a valid entry for the LANG variable in the locales.dat file.
M_MULTI_IN_USE_DEF_OUT	When precompiling multiple input files, you cannot specify output (Listing, SQL, or Language) file names.	Severe	Remove all -G, -L, and -O flags from the command line or precompile the files one at a time.
M_NO_INPUT_FILE	Error: No input file is specified to be precompiled.	Severe	Specify an input file for precompilation. This error may occur if you precede the input file name with a flag (such as -G, for generate stored procedures), which takes an optional argument. To fix, put another flag in front of the input file name. For example, replace cpre -G file.pc with cpre -G -Ccompilername.
M_NO_PERSISTENT_COBOL	The option -p for persistent input host variables is not available.	Information	No fix required.
M_OPEN_INCLUDE	Unable to open the specified include file file.	Severe	The specified file is either not in the path or is missing the required read permission. Specify the path with the -I flag and verify the read permission.
M_OPEN_INPUT	Unable to open the specified input file file.	Severe	Check the validity of the path and file name specified. If the file name extension is not provided, the precompiler searches for the default extension.
M_OPEN_ISQL	Unable to open the specified ISQL file file.	Severe	Check the validity of the isql file name (the file in which the stored procedures are written). Verify that you have the write permission in the directory where the file is being created.
M_OPEN_LIST	Unable to open the specified listing file file.	Severe	Check the validity of the listing file name. Verify that you have write permission in the directory where the file is being created.
M_OPEN_TARGET	Unable to open the specified target file file.	Severe	Check the validity of the output file name. Verify that you have write permission in the directory where the file is being created.
M_OPT_MUST_BE_PROVIDED	Option value must be provided.	Severe	Provide a value for option.
M_OPT_REINIT	Warning: value switch initialized multiple times.	Warning	The specified switch has been initialized multiple times. The second and subsequent values are ignored.
M_PATH_OFL	Error: Max allowed paths for "INCLUDE" files is 64 (OVERFLOWED).	Severe	The maximum allowed paths on the command line have been exceeded. Reduce the number of directories from which the INCLUDE files are fetched.
M_STATIC_HV_CNAME	Static cursor names cannot be host-variables: line.	Severe	Replace the host variable with a SQL identifier.
M_UNBALANCED_DQ	Unbalanced quotes in delimited identifier.	Severe	Balance the quote.
M_VMS_NO_PERSISTENT_ COBOL	The persistent option is not available.	Information

**Table A-2: First pass parser messages**
Message ID	Message text	Severity	Fix
M_64BIT_INT	Warning: 64 bit integer host variables are not supported. Line value.	Warning	Use some other host variable type (float, numeric, or 32-bit integer). If necessary, copy the value between the host variable and the 64-bit program variable.
M_BLOCK_ERROR	Non-matching block terminator in value at line: value.	Severe	Correct your program syntax.
M_COB_INC_SQLDA	Error: the INCLUDE SQLDA statement is not valid in ESQL/COBOL.	Severe	Use SYBSETSQLDA. See “Using SYBSETSQLDA”.
M_CONST_FETCH	Error: Attempted fetch into CONST storage class variable value.	Severe	You cannot fetch into a constant type. To fetch the value, remove the constant qualifier in its declaration.
M_DUP_HV	Duplicate host variable in file at line line.	Severe	Another host variable with the same name is already declared in the same block. Verify that each variable within a given block has a unique name.
M_DUP_STRUNION	Duplicate structure/union in file at line.	Severe	Another structure with the same name is already declared in the same block. Verify that each variable within a given block has a unique name.
M_IDENT_OR_STRINGVAR	Error: item must be a SQL-identifier or a string-type variable.	Severe	Verify that the connection, cursor, or statement name is of type string or SQL identifier.
M_ILL_LITERAL_USAGE	Error: Use of literal parameters to an RPC with an OUTPUT qualifier is not legal.	Severe	Do not use a literal as an OUTPUT parameter to a stored procedure.
M_ILL_PARAM_MODE	Error: Mixing calling modes in an rpc call in file at line.	Severe	Call the stored procedure with arguments passed by name or by position. Mixing these modes in the same call is illegal.
M_INDICVAR	Error: item must be an indicator-type variable.	Severe	Use a short integer.
M_INTVAR	Error: item must be an integer-type variable.	Severe	Use an integer.
M_INVLD_HV_BT	Cobol host variable: value of type: value is not supported.	Severe	Check the datatypes of the host variables. An unsupported type was detected.
M_MISMATCHED_QUOTES	Error: mismatched quotes on hex literal value.	Severe	Make quotes match.
M_MULTIDIM_ARRAY	Error: at line. Multiple-dimensioned array variables are not supported.	Severe	Multiple-dimensional arrays are not supported. Break up an m x n array into m arrays of n elements each.
M_MULTI_RESULTS	Error: Embedded Query at line line returns multiple result sets.	Severe	Break the query into multiple queries, each returning one result set. Alternatively, rewrite the queries to fill a temporary table with all the values, then select from the temporary table, thus giving a single result set.
M_NODCL_NONANSI	Warning: Neither SQLCODE nor SQLCA declared in non-ANSI mode.	Warning	In non-ANSI mode, declare either SQLCA, SQLCODE, or both. Verify that the scope is applicable for all Embedded SQL statements within the program.
M_NOLITERAL	Error: Item may not be an unquoted name.	Severe	Use a quoted name or host variable.
M_NOSQUOTE	Error: Item may not be a single quoted string. Use double quotes.	Severe	Use double quotes.
M_NOT_AT_ABLE	An “at” clause is used with a statement type which does not allow it. This occurred at line value.	Severe	Remove the at clause from the specified statement.
M_NUMBER_OR_INDICVAR	Error: Item must be an integer or an indicator-type variable.	Severe	Use a literal integer or a short integer or CS_SMALLINT.
M_NUMBER_OR_INTVAR	Error: Item must be an integer constant or an integer type variable.	Severe	Unused. May be used to raise an error if some field in the dynamic SQL statements (such as MAX, Value n,) is not an integer type or an integer constant.
M_PARAM_RESULTS	Error: Embedded Query at line line returns unexpected parameter result sets.	Severe	Arises only during optional server syntax checking. Determine why the query is returning parameters, and rewrite it.
M_PASS1_ERR	File file: Syntax errors in Pass 1: Pass 2 not done.	Information	Errors in Pass 1 resulted in an aborted precompilation. Correct Pass 1 errors, then proceed.
M_PTR_IN_DEC_SEC	Warning: Pointers are not yet supported in Declare section.	Warning	None.
M_QSTRING_OR_STRINGVAR	Error: Item must be a quoted string or a type string variable.	Severe	Verify that server name, user name, and password are either double-quoted strings or of type string.
M_SCALAR_CHAR	Error: Non-array character variable value is being used illegally as a host variable at line line.	Severe	Use a character array.
M_SQLCA_IGNR	Warning: Both SQLCODE and SQLCA declared: SQLCA ignored.	Warning	Remove one of the two declarations.
M_SQLCA_WARN	Warning: An INCLUDE SQLCA seen while in ANSI mode: SQLCA ignored.	Warning	None.
M_SQLCODE_UNDCL	Warning: SQLCODE not declared while in ANSI mode.	Warning	Declare SQLCODE.
M_STATE_CODE	Warning: Both SQLSTATE and SQLCODE declared: SQLCODE ignored.	Warning	Remove one of the two declarations.
M_STATE_SQLCA	Warning: Both SQLSTATE and SQLCA declared: SQLCA ignored.	Warning	Remove one of the two declarations.
M_STATUS_RESULTS	Error: Embedded Query at line line returns unexpected status result sets.	Severe	Arises only during optional server syntax checking. Determine why the query is returning status results and rewrite it.
M_STICKY_AUTOVAR	Warning: Automatic variable value used with sticky binds at line line. This may cause incorrect results or errors at runtime.	Warning	Be certain that your program logic will not allow errors in this case. Alternatively, use a static or global variable.
M_STICKY_REGVAR	Error: Register variable value cannot be used with sticky binds at line line.	Severe	Remove the register qualifier.
M_STRUCT_NOTFOUND	Structure/union definition not found in scope in file at line.	Severe	Verify that the definition of the structure or union is within the scope of the specified line.
M_SYNTAX_PARSE	Syntax error in file file at line.	Severe	Check the indicated line number for a syntax error in the Embedded SQL grammar.
M_UNBALANCED_DQ	Unbalanced quotes in delimited identifier.	Severe	Balance the quotes.
M_UNDEF_ELM	Error value: illegal structure/ union element.	Severe	The specified element of the structure is not included in the structure definition. Correct the definition.
M_UNDEF_HV	Host variable value undefined.	Severe	Define the host variable in the proper place.
M_UNDEF_IV	Indicator variable value undefined.	Severe	Define the indicator variable in the proper place.
M_UNDEF_STR	Error structure value undefined.	Severe	Undefined structure on the specified line. Define the structure in the proper scope.
M_UNSUP	The value, feature is not supported in this version.	Fatal	This feature is not supported.

**Table A-3: Second pass parser messages**
Message ID	Message text	Severity	Fix
M_CURSOR_RD	The cursor value is redefined at line line in file.	Warning	A cursor with same name has already been declared. Use a different name.
M_HOSTVAR_MULTIBIND	Warning: host variable used as a bind variable value more than once per statement.	Warning	Do not use a host variable multiple times in a single fetch statement. You cannot fetch multiple results into one location. Client-Library causes the last value fetched to be put in the variable.
M_INVTYPE_IV	Indicator variable is an incorrect type.	Severe	The indicator variable should be of type CS_SMALLINT or of type INDICATOR.
M_PARSE_INTERNAL	Internal parser error at line line. Please contact a Sybase representative.	Fatal	Immediately report this internal consistency parser error to Sybase Technical Support.
M_SQLCANF	‘INCLUDE SQLCA’ statement not found.	Warning	Add the statement.
M_TAB_IN_LIT	Warning: TAB character in quoted string converted to space. (This warning will only appear once.)	Warning	If this is a problem, manually expand quoted <tabs> to spaces in your queries.
M_WHEN_ERROR	Unable to find the SQL statement ‘WHENEVER SQLERROR’.	Warning	Add WHENEVER SQLERROR statement ,or use the command line option to suppress warning and INTO messages (see the Open Client and Open Server Programmer’s Supplement).
M_WHEN_NF	Unable to find the SQL statement "WHENEVER NOT FOUND".	Warning	Enter a WHENEVER NOT FOUND statement, or use the command line option to suppress warning and INTO messages (see the Open Client and Open Server Programmer’s Supplement).
M_WHEN_WARN	Unable to find the SQL statement "WHENEVER NOT FOUND".	Warning	Enter a WHENEVER WARNING statement, or use the command line option to suppress warning and INTO messages (see the Open Client and Open Server Programmer’s Supplement).

**Table A-4: Code generation messages**
Message ID	Message text	Severity	Fix
M_INCLUDE_PATHLEN	An included or copied file path was too long. Leaving the path off the generated file name: value.	Warning	Use links or move the file to a shorter path.
M_WRITE_ISQL	Unable to write to the isql file. Return code: value.	Fatal	Verify your permission to create and write to the isql file and in the directory. Also, verify that the file system is not full.
M_WRITE_TARGET	Unable to write to the target file. Return code: value.	Fatal	Unable to write to the target file. Verify your permission to create and write to a file in the directory where the precompiler is generating the target file. Also, verify that the file system is not full.

**Table A-5: FIPS flag messages**
Message ID	Message text	Severity	ANSI extension
M_FIPS_ARRAY	FIPS-flagger Warning: ANSI extension ARRAY type at line.	Information	Arrays. As for all FIPS messages, do not use this feature if you need to be ANSI-compliant.
M_FIPS_DATAINIT	FIPS-flagger Warning: ANSI extension Data Initialization at line.	Information	Data initialization.
M_FIPS_GPITEM	FIPS-Flagger Warning: ANSI extension group item syntax. (line line).	Information
M_FIPS_HASHDEF	FIPS-flagger Warning: ANSI extension "#DEFINE" line.	Information	Using #DEFIN in a DECLARE section.
M_FIPS_LABEL	FIPS-flagger Warning: ANSI extension ':' with label in a "WHENEVER" clause.	Information	Allowing ":" with a label in a WHENEVER clause.
M_FIPS_POINTER	FIPS-flagger Warning: ANSI extension POINTER type at line.	Information	The type POINTER.
M_FIPS_SQLDA	FIPS-flagger Warning: ANSI extension sqlda. (line line).	Information	The SQLDA structure.
M_FIPS_STMT	FIPS-flagger Warning: ANSI extension statement (line line)	Information	The statement at this line is an extension.
M_FIPS_SYBTYPE	FIPS-flagger Warning: ANSI extension Sybase SQL-Type line.	Information	Sybase-specific datatypes.
M_FIPS_TYPE	FIPS-flagger Warning: ANSI extension data type at line.	Information	The specified syntax is not ANSI-compliant.
M_FIPS_TYPEDEF	FIPS-flagger Warning: ANSI extension TYPEDEF line.	Information	TYPEDEF.
M_FIPS_VOID	FIPS-flagger Warning: ANSI extension VOID type line.	Information	The type VOID.

**Table A-6: Internal error messages**
Message ID	Message text	Severity	Fix
M_ALC_MEMORY	Unable to allocate a block of memory.	Fatal	Check system resources.
M_FILE_STACK_OVFL	File stack overflow: Max allowed nesting is value.	Fatal	The file stack overflowed while trying to process the nested INCLUDE statement. Do not exceed the nested depth maximum of 32.
M_INTERNAL_ERROR	Fatal Internal Error at file file line line: Argument inconsistency error. Please contact Sybase representative.	Fatal	This is an internal error. Contact your Sybase representative.

**Table A-7: Platform and language messages**
Message ID	Message text	Severity	Fix
M_LONGLINE	A line being printed is too long and cannot be broken.	Warning	Shorten the line to be printed.

**Table A-8: Sybase and Client-Library messages**
Message ID	Message text	Severity	Fix
M_COLMCNT	The bind count of the bind variable count and the column count of result set are incompatible.	Warning	The number of returned columns is different from the number of results columns returned with the bind variable types and number.
M_COLVARLM	The host variable name length value is less than the column length of value.	Warning	The host variable may not be able to hold the fetched column. Check the column length and adjust the length of the host variable accordingly.
M_COLVARPS	The host variable name precision and scale: value are different from the column's precision value and scale: value.	Warning	The precision and scale of the host variable is different from that of the column being fetched or inserted into. Make the scale and precision compatible.
M_COLVARTM	Open Client unable to convert type value to type value for host variable name.	Warning	Illegal type. Use cs_convert, as Open Client cannot convert by default.
M_CTMSG	Client Library message: value.	Information	None. If needed, contact Sybase Technical Support for assistance.
M_OCAPI	Error during execution of the Open Client API value. Error: value.	Warning	Depending on the context in which this warning occurs, you may be required to take corrective action before proceeding.
M_OPERSYS	Operating system error: value occurred during execution of the Open Client API.	Warning	An operating system error occurred. See the systems administrator.
M_PRECLINE	Warning(s) during check of query on line value.	Information	Examine the query for problems.
M_SYBSERV	Sybase Server error. Server: value. Message: name.	Warning	Check the syntax of the statement sent to the Server which caused this error. Verify that all resources are available in Adaptive Server to process the SQL statement.

**Table A-9: Runtime messages**
SQLSTATE Code	Message text	Severity	Fix
ZZ000	Unrecoverable error occurred.	Fatal	Immediately report this error to Sybase Technical Support.
ZA000	Internal error occurred.	Fatal	Immediately report this error to Sybase Technical Support.
ZD000	Unexpected CS_COMPUTE_RESULT received.	Severe	Embedded SQL cannot retrieve compute results. Rewrite the query so it does not return them.
ZE000	Unexpected CS_CURSOR_RESULT received.	Severe	Verify that the value returned by the CS_LIBRARY routine is valid. Consult your CS-Library documentations for details.
ZF000	Unexpected CS_PARAM_RESULT received.	Severe	Verify that the value returned by the CS_LIBRARY routine is valid. Consult your CS-Library documentation for details.
ZG000	Unexpected CS_ROW_RESULT received.	Severe	Verify that the value returned by the CS_LIBRARY routine is valid. Consult your CS-Library documentation for details.
ZB000	No message(s) returned for SQLCA, SQLCODE, or SQLSTATE.	Information	Informational message. No action is required.
ZC000	Connection has not been defined yet.	Severe	Enter a valid connect statement.
ZH000	Unexpected CS_STATUS_RESULT received.	Severe	Verify that the value returned by the CS_LIBRARY routine is valid. Consult your CS-Library documentation for details.
ZI000	Unexpected CS_DESCRIBE_RESULT received.	Severe	Verify that the value returned by the CS_LIBRARY routine is valid. Consult your CS-Library documentation for details.
22005	Data exception—error in assignment of item descriptor type.	Severe	Enter a valid descriptor type.
ZJ000	Memory allocation failure.	Severe	There is an insufficient amount of memory to allocate to this operation.
ZK000	SQL-Server must be version 10 or greater.	Severe	Verify that your installation has an installed, functioning copy of SQL Server 10.0 or later. If you do not have SQL Server 10.0 or later, have your installation’s designated person contact Sybase Technical Support.
ZM000	Error initializing Client Library.	Severe	Check your $SYBASE set-up.
ZN000	Error taking a mutex.	Severe	Unused.
08002	Connection name in use.	Severe	Check your program logic: Are you re-opening an open connection? Or use a new name for the second connection. You cannot have two DEFAULT connections.