Understanding the codes in the tables

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.

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

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.

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/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/Server Programmer’s Supplement).

M_WHEN_WARN

Unable to find the SQL statement "WHENEVER WARNING".

Warning

Enter a WHENEVER WARNING statement, or use the command line option to suppress warning and INTO messages (see the Open Client/Server Programmer’s Supplement).

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.

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.

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.

M_LONGLINE

A line being printed is too long and cannot be broken.

Warning

Shorten the line to be printed.

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.

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.