Reference Manual
   CHAPTER 11. SQL Preprocessor Error Messages     

SQLPP errors

This section lists the SQL preprocessor errors.

  subscript value %ld too large

Item	Value
Code	2601

Probable cause 

You have attempted to index a host variable that is an array with a value too large for the array.

  combined pointer and arrays not supported for hosttypes

Item	Value
Code	2602

Probable cause 

You have used an array of pointers as a host variable. This is not legal.

  only one dimensional arrays supported for char type

Item	Value
Code	2603

Probable cause 

You have used an array of arrays of character as a host variable. This is not a legal host variable type.

  VARCHAR type must have a length

Item	Value
Code	2604

Probable cause 

You have attempted to declare a VARCHAR or BINARY host variable using the DECL_VARCHAR or DECL_BINARY macro but have not specified a size for the array.

  arrays of VARCHAR not supported

Item	Value
Code	2605

Probable cause 

You have attempted to declare a host variable as an array of VARCHAR or BINARY. This is not a legal host variable type.

  VARCHAR host variables cannot be pointers

Item	Value
Code	2606

Probable cause 

You have attempted to declare a host variable as a pointer to a VARCHAR or BINARY. This is not a legal host variable type.

  initializer not allowed on VARCHAR host variable

Item	Value
Code	2607

Probable cause 

You can not specify a C variable initializer for a host variable of type VARCHAR or BINARY. You must initialize this variable in regular C executable code.

  FIXCHAR type must have a length

Item	Value
Code	2608

Probable cause 

You have used the DECL_FIXCHAR macro to declare a host variable of type FIXCHAR but have not specified a length.

  arrays of FIXCHAR not supported

Item	Value
Code	2609

Probable cause 

You have attempted to declare a host variable as an array of FIXCHAR. This is not a legal host variable type.

  arrays of int not supported

Item	Value
Code	2610

Probable cause 

You have attempted to declare a host variable as an array of ints. This is not a legal host variable type.

  precision must be specified for decimal type

Item	Value
Code	2611

Probable cause 

You must specify the precision when declaring a packed decimal host variable using the DECL_DECIMAL macro. The scale is optional.

  arrays of decimal not allowed

Item	Value
Code	2612

Probable cause 

You have attempted to declare a host variable as an array of DECIMAL. This is not a legal host variable type.

  Unknown hostvar type

Item	Value
Code	2613

Probable cause 

You declared a host variable of a type not understood by the SQL preprocessor.

  invalid integer

Item	Value
Code	2614

Probable cause 

An integer was required in an embedded SQL statement (for a fetch offset, or a host variable array index, etc.) and the preprocessor was unable to convert what was supplied into an integer.

  '%s' host variable must be a C string type

Item	Value
Code	2615

Probable cause 

A C string was required in an embedded SQL statement (for a cursor name, option name etc.) and the value supplied was not a C string.

  '%s' symbol already defined

Item	Value
Code	2617

Probable cause 

You defined a host variable twice with different definitions.

  invalid type for sql statement variable

Item	Value
Code	2618

Probable cause 

A host variable used as a statement identifier should be of type a_sql_statement_number. You attempted to use a host variable of some other type as a statement identifier.

  Cannot find include file '%s'

Item	Value
Code	2619

Probable cause 

The specified include file was not found. Note that the preprocessor will use the INCLUDE environment variable to search for include files.

  host variable '%s' is unknown

Item	Value
Code	2620

Probable cause 

You have used a host variable in a statement and that host variable has not been declared in a declare section.

  indicator variable '%s' is unknown

Item	Value
Code	2621

Probable cause 

You have used a indicator variable in a statement and that indicator variable has not been declared in a declare section.

  invalid type for indicator variable '%s'

Item	Value
Code	2622

Probable cause 

Indicator variables must be of type short int. You have used a variable of a different type as an indicator variable.

  invalid host variable type on '%s'

Item	Value
Code	2623

Probable cause 

You have used a host variable that is not a string type in a place where the preprocessor was expecting a host variable of a string type.

  host variable '%s' has two different definitions

Item	Value
Code	2625

Probable cause 

The same host variable name was defined with two different types within the same module. Note that host variable names are global to a C module.

  statement '%s' not previously prepared

Item	Value
Code	2626

Probable cause 

An embedded SQL statement name has been used (EXECUTEd) without first being PREPAREd.

  cursor '%s' not previously declared

Item	Value
Code	2627

Probable cause 

An embedded SQL cursor name has been used (in a FETCH, OPEN, CLOSE etc.) without first being DECLAREd.

  unknown statement '%s'

Item	Value
Code	2628

Probable cause 

You attempted to drop an embedded SQL statement that doesn't exist.

  host variables not allowed for this cursor

Item	Value
Code	2629

Probable cause 

Host variables are not allowed on the declare statement for the specified cursor. If the cursor name is provided through a host variable, then you should use full dynamic SQL and prepare the statement. A prepared statement may have host variables in it.

  host variables specified twice - on declare and open

Item	Value
Code	2630

Probable cause 

You have specified host variables for a cursor on both the declare and the open statements. In the static case, you should specify the host variables on the declare statement. In the dynamic case, specify them on the open.

  must specify a host list or using clause on %s

Item	Value
Code	2631

Probable cause 

The specified statement requires host variables to be specified either in a host variable list or from an SQLDA.

  no INTO clause on SELECT statement

Item	Value
Code	2633

Probable cause 

You specified an embedded static SELECT statement but you did not specify an INTO clause for the results.

  incorrect Embedded SQL syntax

Item	Value
Code	2636

Probable cause 

An embedded SQL specific statement (OPEN, DECLARE, FETCH etc.) has a syntax error.

  missing ending quote of string

Item	Value
Code	2637

Probable cause 

You have specified a string constant in an embedded SQL statement, but there is no ending quote before the end of line or end of file.

  token too long

Item	Value
Code	2639

Probable cause 

The SQL preprocessor has a maximum token length of 2K. Any token longer than 2K will produce this error. For constant strings in embedded SQL commands (the main place this error shows up) use string concatenation to make a longer string.

  '%s' host variable must be an integer type

Item	Value
Code	2640

Probable cause 

You have used a host variable that is not of integer type in a statement where only an integer type host variable is allowed.