HP 3000 Manuals

ALLBASE/SQL Error Messages (Continued) [ ALLBASE/SQL Message Manual ] MPE/iX 5.5 Documentation


ALLBASE/SQL Message Manual

ALLBASE/SQL Error Messages (Continued) 

10936        MESSAGE    Syntax error.  (DBERR 10936)

           CAUSE      An unrecognized syntax error occurred.

           ACTION     Correct the syntax in either the line specified in
                      the error message or the line immediately preceding
                      or immediately following the specified line.  Refer
                      to the ALLBASE/SQL application programming guide
                      for the language you are using for additional
                      information.

----------------------------------------------------------------------------

10937        MESSAGE    Syntax error caused skip to end of DECLARE
                      SECTION.  (DBERR 10937)

           CAUSE      An unrecognized syntax error occurred in the host
                      variable declaration section.

           ACTION     Correct the syntax in either the specified line in
                      the error message or the line immediately preceding
                      or immediately following the specified line.  Refer
                      to the ALLBASE/SQL application programming guide
                      for the language you are using for additional
                      information.

----------------------------------------------------------------------------

10938        MESSAGE    This host variable was previously declared.
                      (DBERR 10938)

           CAUSE      You specified the same name for more than one host
                      variable.

           ACTION     Either delete one occurrence of the variable or
                      correct one of the host variables to specify a
                      unique name and re-preprocess your program.

----------------------------------------------------------------------------

10939        MESSAGE    Table element must occur one or more times.
                      (DBERR 10939)

           CAUSE      You specified a table declaration in the DECLARE
                      section with an invalid value in the OCCURS clause.

           ACTION     Specify an integer value greater than zero in the
                      table declaration OCCURS clause.

----------------------------------------------------------------------------

10940        MESSAGE    Array lower bound may not exceed upper bound.
                      (DBERR 10940)

           CAUSE      The array lower bound was greater than the array
                      upper bound.

           ACTION     Correct the host variable declare section
                      specifying valid array bounds, and re-preprocess
                      your program.  Refer to the ALLBASE/SQL application
                      programming guide for the language you are using
                      for additional information.

----------------------------------------------------------------------------

10941        MESSAGE    Invalid STRING size.  (DBERR 10941)

           CAUSE      The size of the string you specified is invalid for
                      a Pascal program.

           ACTION     Modify your Pascal program so that the string is
                      from 1 through 32,767 bytes long, then
                      re-preprocess your program.

----------------------------------------------------------------------------

10942        MESSAGE    Invalid size for variable of that type.  (DBERR
                      10942)

           CAUSE      The size you specified for the FORTRAN host
                      variable is not valid for that type of host
                      variable.

           ACTION     Modify the declaration of the host variable so that
                      it is a valid size.  Refer to the ALLBASE/SQL 
                      FORTRAN Application Programming Guide for
                      additional information on host variables.

----------------------------------------------------------------------------

10943        MESSAGE    Include file open error.  (DBERR 10943)

           CAUSE      You encountered a system error while attempting to
                      open the specified include file.

           ACTION     Verify that the specified include file exists; if
                      so, check the spelling of the include file name.
                      Verify that the group and account exist.  Verify
                      that appropriate read privileges exist for the
                      specified include file.

----------------------------------------------------------------------------

10944        MESSAGE    Unrecognized syntax encountered.  Parse aborted.
                      (DBERR 10944)

           CAUSE      An unrecognized syntax error occurred.  The
                      preprocessor was unable to continue.

           ACTION     Correct the syntax in either the line specified in
                      the error message or the line immediately
                      preceding.  Refer to the ALLBASE/SQL application
                      programming guide for the language you are using
                      for additional information.

----------------------------------------------------------------------------

10945        MESSAGE    Illegal type for record field.  (DBERR 10945)

           CAUSE      The host variable type you specified in the DECLARE
                      section of your program was invalid.

           ACTION     Refer to the ALLBASE/SQL application programming
                      guide for the language you are using for valid host
                      variable types.

----------------------------------------------------------------------------

10946        MESSAGE    Illegal type for table element.  (DBERR 10946)

           CAUSE      Internal error.

           ACTION     Record as much information as possible and contact
                      your HP service representative or Response Center.

----------------------------------------------------------------------------

10947        MESSAGE    Preprocessor does not support this statement.
                      (DBERR 10947)

           CAUSE      You included an SQL statement which cannot be
                      embedded in the language you are using.

           ACTION     Delete the SQL statement and re-preprocess your
                      program.

----------------------------------------------------------------------------

10948        MESSAGE    Unrecognized WHENEVER action.  (DBERR 10948)

           CAUSE      The condition or action you specified in the
                      WHENEVER clause is invalid or the label specified
                      for a GOTO action is invalid.

           ACTION     Correct the syntax in your WHENEVER clauses and
                      re-preprocess your program.  Keep in mind that
                      valid conditions are SQLWARNING, SQLERROR, and NOT
                      FOUND. Valid actions are STOP, GOTO, and CONTINUE.

----------------------------------------------------------------------------

10949        MESSAGE    Undeclared host variable.  (DBERR 10949)

           CAUSE      The SQL statement you specified a host variable
                      which was either not declared or was incorrectly
                      declared in the host variable declaration section.

           ACTION     Either enter the host variable if it was not
                      declared or correct it if it was entered
                      incorrectly and re-preprocess your program.

----------------------------------------------------------------------------

10950        MESSAGE    Indicator variable type must be SQLIND.  (DBERR
                      10950)

           CAUSE      The host variable you used as an indicator variable
                      in an SQL statement was not declared as SQLIND in
                      the host variable declaration.

           ACTION     Either modify the SQL statement to use a host
                      variable declared as SQLIND or modify the
                      declaration of the host variable to be SQLIND and
                      re-preprocess your program.

----------------------------------------------------------------------------

10951        MESSAGE    Stand-alone SELECT statement requires INTO
                      clause.  (DBERR 10951)

           CAUSE      Your embedded SELECT statement did not include the
                      required INTO clause which defines the host
                      variables for holding rows returned to the
                      application program.

           ACTION     Modify the SELECT statement to include the required
                      INTO clause and re-preprocess your program.  Refer
                      to the ALLBASE/SQL Reference Manual for additional
                      information on the SELECT statement.

----------------------------------------------------------------------------

10953        MESSAGE    Cannot connect to DBEnvironment. (DBERR 10953)

           CAUSE      The DBEnvironment you specified does not exist
                      or
                      the DBEnvironment you specified is in use and the
                      user mode is set to SINGLE
                      or
                      you do not have the required authority to access
                      the DBEnvironment.

           ACTION     Check your spelling
                      or
                      wait until the DBEnvironment is not being accessed
                      or
                      contact your database administrator to obtain the
                      required CONNECT authority.

----------------------------------------------------------------------------

10954        MESSAGE    Cannot begin transaction. (DBERR 10954)

           CAUSE      A transaction could not begin.  An additional
                      message will be returned.

           ACTION     Refer to the cause and action of the additional
                      message.

----------------------------------------------------------------------------

10955        MESSAGE    Cannot drop module. (DBERR 10955)

           CAUSE      You do not have the required authority to drop the
                      specified module
                      or
                      an additional message will be returned.

           ACTION     No action is necessary.  You must either be the
                      owner or the database administrator to drop a
                      module
                      or
                      refer to the cause and action of the additional
                      message.

----------------------------------------------------------------------------

10956        MESSAGE    Cursor name must be a single identifier.  (DBERR
                      10956)

           CAUSE      You attempted to qualify a cursor with an owner or
                      module name.

           ACTION     Delete the cursor name qualification in the
                      specified statement and re-preprocess your program.

----------------------------------------------------------------------------

10957        MESSAGE    Indicator variables not allowed in this
                      statement.  (DBERR 10957)

           CAUSE      You specified an indicator variable in a statement
                      that does not allow indicator variables.

           ACTION     Remove the indicator variable from the statement
                      or
                      verify that the host variables have the correct
                      data types.

----------------------------------------------------------------------------

10958        MESSAGE    A query is already defined with this cursor name.
                      (DBERR 10958)

           CAUSE      You attempted to declare a cursor which was already
                      declared.

           ACTION     Modify one occurrence of the DECLARE CURSOR
                      statement to specify a unique cursor name and
                      re-preprocess your program.

----------------------------------------------------------------------------

10959        MESSAGE    There is no declared query with this cursor name.
                      (DBERR 10959)

           CAUSE      The SQL statement referenced a cursor which had not
                      been declared.

           ACTION     Insert a DECLARE CURSOR statement before
                      referencing the cursor and re-preprocess your
                      program.

----------------------------------------------------------------------------

10960        MESSAGE    Insufficient input host variables.  (DBERR 10960)

           CAUSE      You specified too few input host variables in the
                      OPEN statement to cover the columns specified in
                      the cursor declaration.

           ACTION     Make sure that there is a host variable listed for
                      each column specified and re-preprocess your
                      program.

----------------------------------------------------------------------------

10961        MESSAGE    Too many input host variables.  (DBERR 10961)

           CAUSE      You specified too many host variables in the OPEN
                      statement for the number of columns specified in
                      the cursor declaration.

           ACTION     Make sure that there is a column specified for each
                      host variable listed and re-preprocess your
                      program.

----------------------------------------------------------------------------

10962        MESSAGE    Command name must be a single identifier.  (DBERR
                      10962)

           CAUSE      You qualified a command name with the owner or
                      module name.

           ACTION     Delete the command name qualification.

----------------------------------------------------------------------------

10963        MESSAGE    This command already used.  (DBERR 10963)

           CAUSE      You attempted to PREPARE a statement using a
                      command name which has already been used in another
                      PREPARE statement.

           ACTION     Modify one of the PREPARE statements to specify a
                      unique command name and re-preprocess your program.

----------------------------------------------------------------------------

10964        MESSAGE    The host variable must be of type STRING or PAC.
                      (DBERR 10964)

           CAUSE      You specified host variables which were not of the
                      string or packed array type.

           ACTION     Modify the DECLARE section of your host variable so
                      that the host variable is of the string or packed
                      array type.  Refer to the ALLBASE/Pascal 
                      Application Programming Guide for additional
                      information.

----------------------------------------------------------------------------

10965        MESSAGE    Character string is too long.  (DBERR 10965)

           CAUSE      A string literal you specified in a PREPARE or
                      EXECUTE IMMEDIATE statement exceeded the maximum
                      limit of 2048 characters.

           ACTION     Modify the command to specify a value within the
                      valid limits.

----------------------------------------------------------------------------

10966        MESSAGE    No prepared query found by this command name.
                      (DBERR 10966)

           CAUSE      The EXECUTE statement contained a command name
                      which was not prepared in the same subprogram unit.

           ACTION     Check your spelling.  If the command name is
                      correct, insert an appropriate PREPARE statement
                      before the EXECUTE statement and re-preprocess your
                      program.

----------------------------------------------------------------------------



MPE/iX 5.5 Documentation