Natural System Error Messages 0750-0799

#### Search Results

Search

# Natural System Error Messages 0750-0799

#### NAT0751: :1: class :2:/:3: failed, reason :4: :5:.

    Text
    ... class .../... failed, reason ... ....
    Explanation
    Reason 1: Error during "SEARCH CLASS" occurred.
           2: Class or classes not found.
           3: COM not available.
           4: NATGWCOM cannot be loaded.
           5: Return code from NATGWCOM.
           6: Class already registered with a different class GUID.
           7: Cannot OPEN registry.
           8: Error during register server information.
           9: Error during register client information.
          10: No valid Natural environment (NATDIR/NATVERS).
          11: Invalid activation policy or no default server specified.
          12: Internal error.

#### NAT0759: Handle/dynamic variables and X-arrays cannot be redefined.

    Text
    Handle/dynamic variables and X-arrays cannot be redefined.
    Explanation
    A variable declared                   DEFINE DATA LOCAL
      - with type HANDLE,             ->  1 #H HANDLE OF OBJECT
      - as an alphan. or binary field ->  1 #AD (A) DYNAMIC
        with a dynamic length,
      - as an array with a variable   ->  1 #VA (A10/1:*)
        number of occurrences             END-DEFINE
    cannot be redefined, and it must not result from a redefinition.
    If a group contains one of these fields in the first position, the
    group cannot be redefined.
    Action
    Check and correct the variable definitions.

#### NAT0760: FETCH FIRST, OFFSET, OPTIMIZE FOR, UNION/EXCEPT/INTERSECT invalid

    Text
    FETCH FIRST, OFFSET, OPTIMIZE FOR, UNION/EXCEPT/INTERSECT invalid.
    Explanation
    1) Neither an OPTIMIZE FOR nor an UNION/EXCEPT/INTERSECT clause may be
       specified for a SELECT SINGLE statement.
    2) The value specified in the FETCH FIRST, OFFSET, OPTIMIZE FOR clause
       is neither an integer constant nor a numeric variable.
    3) The keyword ROWS or ROWS ONLY is missing after the integer constant
       or numeric variable.
    4) The OFFSET clause is not allowed at that place (CTE, fullselect)
    Action
    Check and correct syntax.

#### NAT0761: Incorrect use of UPDATE/DELETE .. WHERE CURRENT CURSOR.

    Text
    Incorrect use of UPDATE/DELETE .. WHERE CURRENT CURSOR.
    Explanation
    An UPDATE/DELETE table WHERE CURRENT CURSOR must reference a SELECT
    statement. It cannot, for example, reference a FIND statement.
    Action
    Check and correct syntax.

#### NAT0762: UPDATE/DELETE table mismatch with SELECT statement.

    Text
    UPDATE/DELETE table mismatch with SELECT statement.
    Explanation
    The table referenced in an
    UPDATE table WHERE CURRENT CURSOR or
    DELETE FROM table WHERE CURRENT CURSOR statement
    is not the table specified in the corresponding SELECT statement.
    Action
    Check and correct syntax.

#### NAT0763: Incorrect alphanumeric constant specified in <<...>>.

    Text
    Incorrect alphanumeric constant specified in <<...>>.
    Explanation
    The constant specified in <<...>> does not adhere to the
    rules for Natural constants.
    For example, alpha constants must be enclosed in apostrophes.
    Action
    Check and correct syntax.

#### NAT0764: Variable reference in <<...>> cannot be resolved.

    Text
    Variable reference in <<...>> cannot be resolved.
    Explanation
    1) The token directly following the variable indicator (:)
       does not adhere to the rules for variable names.
    2) The variable specified is not defined in the program.
    Action
    Check and correct syntax.

#### NAT0765: No valid correlation name after AS keyword in FROM clause.

    Text
    No valid correlation name after AS keyword in FROM clause.
    Explanation
    A correlation name is required after the keyword AS in the FROM
    clause of a SELECT statement. This name could not be found.
    Action
    Either drop the keyword AS or insert a valid correlation name
    behind the keyword.

#### NAT0766: Keyword JOIN expected after INNER, LEFT, RIGHT, FULL, etc.

    Text
    Keyword JOIN expected after INNER, LEFT, RIGHT, FULL, etc.
    Explanation
    The keyword JOIN is required after one of the keywords INNER,
    LEFT, LEFT OUTER, RIGHT, RIGHT OUTER, FULL, FULL OUTER.
    Action
    Insert the keyword JOIN.

#### NAT0767: A correlation name is required in the FROM clause.

    Text
    A correlation name is required in the FROM clause.
    Explanation
    When a subquery is specified in a FROM clause, a correlation name
    is required. This name must follow the SUBSELECT clause.
    Action
    Insert a correlation name after the subquery within the FROM clause.

#### NAT0768: No valid table reference found in FROM clause.

    Text
    No valid table reference found in FROM clause.
    Explanation
    The FROM clause contains no valid table name. Either specify
    a table name or a subquery of a joined table expression.
    Action
    Correct the FROM clause by specifying a valid table name.

#### NAT0769: Illegal use of keyword VALUE or COALESCE in join.

    Text
    Illegal use of keyword VALUE or COALESCE in join.
    Explanation
    The keywords VALUE and COALESCE can only be used in a join
    expression if the related join operation is a FULL join or
    a FULL OUTER join.
    Action
    Use VALUE and COALESCE keywords only if a FULL join is specified.

#### NAT0770: Closing bracket missing in nested joined-table expression.

    Text
    Closing bracket missing in nested joined-table expression.
    Explanation
    In a nested joined-table expression, the number of opening brackets
    must be equal to the number of closing brackets.
    Action
    Insert a closing bracket.

#### NAT0771: Expression requires join-condition keyword ON.

    Text
    Expression requires join-condition keyword ON.
    Explanation
    The keyword ON is missing in a joined-table expression. The joined-
    table expression must have a join-condition which starts with the
    keyword ON. The join-condition expression looks like:
    ON <join-expression> <relational-operator> <join-expression>
    Action
    Insert the keyword ON.

#### NAT0772: Join-condition contains an invalid relational operator.

    Text
    Join-condition contains an invalid relational operator.
    Explanation
    The join-condition contains an invalid relational operator.
    The following relation operators are valid:
       =
      <>
       >
       <
      >=
      <=
    For a FULL join or FULL OUTER join, only "=" is valid.
    See the Natural Statements documentation for further information.
    Action
    Specify a valid relational operator.

#### NAT0773: At least two column names must follow VALUE or COALESCE.

    Text
    At least two column names must follow VALUE or COALESCE.
    Explanation
    After the keyword VALUE or COALESCE, at least two column names must
    follow. These column names must be separated by a comma and placed
    within parentheses. For example:
    VALUE (column1,column3,...,columnX)
    Ensure that none of the following syntax elements is missing:
    - An opening parenthesis.
    - A closing parenthesis.
    - A separating comma.
    Action
    Insert the missing comma, operand, or parenthesis.

#### NAT0774: Column name does not belong to any table to be joined.

    Text
    Column name does not belong to any table to be joined.
    Explanation
    The join-expression may only contain column names which belong
    to one of the tables to be joined. At least one of the column names
    does not belong to any of the joined tables.
    Action
    Check column names to determine which do not belong to a joined
    table. Correct the table name in the join expression.

#### NAT0776: Program cannot be executed.

    Text
    Program cannot be executed.
    Explanation
    While loading the Natural program, an internal, non-recoverable error
    has occurred. The program could not be loaded into the Natural buffer
    pool.
    Action
    Check program and/or contact your Natural administrator.

#### NAT0777: Buffer pool full.

    Text
    Buffer pool full.
    Explanation
    The Natural buffer pool is full. To execute a Natural object,
    it must be loaded into the Natural buffer pool.
    If not enough space is available in the Natural buffer pool,
    the Natural object cannot be executed.
    Action
    Contact your Natural administrator.

#### NAT0778: Program not ready for execution.

    Text
    Program not ready for execution.
    Explanation
    The program to be executed is in the process of being cataloged by
    another user. When loading this program into the Natural buffer pool,
    Natural can not guarantee that the program code is in a correct and
    executable state.
    Action
    Execute the program at a later point in time.

#### NAT0779: Program cannot be executed.

    Text
    Program cannot be executed.
    Explanation
    This message appears if Natural has tried unsuccessfully 32 times
    to load the program into the Natural buffer pool.
    Action
    Contact your Natural administrator.

#### NAT0780: Invalid Case-expression or invalid WHEN-clause in MERGE statement

    Text
    Invalid Case-expression or invalid WHEN-clause in MERGE statement.
    Explanation
    1) The specified Case-Expression is invalid:
    The keywords ELSE, THEN, WHEN , END are misplaced,
    or one of these keywords is missing,
    or one of the sub-expressions is invalid.
    2) The specified WHEN-clause in the MERGE statement is invalid:
    Either no WHEN-clause or duplicate WHEN-clauses or invalid WHEN-clauses
    are specified in a MERGE statement.
    Action
    Check the syntax of the case-expression or of the MERGE statement.

#### NAT0781: Internal Natural Db2 error.

    Text
    Internal Natural Db2 error.
    Action
    Provide the Natural source and object program and contact
    Software AG support.

#### NAT0782: No fields were selected by a FIND or READ statement.

    Text
    No fields were selected by a FIND or READ statement.
    Explanation
    A FIND or READ statement does not retrieve any fields (empty view),
    but is directed to access an SQL database (e.g. Db2). This will
    result in the generation of an SQL SELECT statement with an empty
    column list. However, this is not permitted.
    Action
    Retrieve at least one field in the FIND or READ statement.

#### NAT0783: Invalid Natural statement for Db2 access.

    Text
    Invalid Natural statement for Db2 access.
    Explanation
    The following Natural statements are not supported when accessing
    a Db2 database:
      - GET
      - STORE USING NUMBER (ISN)
    Action
    Check program and correct error.

#### NAT0784: Insufficient space for SQL :1: generation.

    Text
    Insufficient space for SQL ... generation.
    Explanation
    During the generation, the corresponding buffer has overflowed.
    Either provide a greater thread/partition/region,
    or split the program"s SQL parts and put them into different programs.
    The message relates either to the buffer containing the SQL
    statements or to the buffer containing the SQL XREF data.
    Action
    Start Natural in greater thread/partition/region, or reduce the number
    or size of SQL statements.

#### NAT0785: Internal Natural Db2 error.

    Text
    Internal Natural Db2 error.
    Action
    Provide the Natural source and object program, and contact
    Software AG support.

#### NAT0786: No fields assigned for an UPDATE statement.

    Text
    No fields assigned for an UPDATE statement.
    Explanation
    Natural Db2: An UPDATE statement is present, but
    no database fields  are specified for the view.
    Action
    Assign a value to a Db2 column.

#### NAT0787: A read-only field may not be modified.

    Text
    A read-only field may not be modified.
    Explanation
    Natural for Db2: Read-only fields were specified in an UPDATE statement.
    This is not allowed, because these fields may not be modified.
    Action
    Check program and correct error.

#### NAT0788: UPDATE/DELETE must not be used in conj. with FIND SORTED.

    Text
    UPDATE/DELETE must not be used in conj. with FIND SORTED.
    Explanation
    UPDATE/DELETE must not be used in conjunction with  READ BY,
    FIND ... ORDER BY, SELECT ... ORDER BY or READ RESULT SET
    according to Db2 processing logic.
    Action
    Correct error in program.

#### NAT0789: Field in SORTED BY clause is not referenced.

    Text
    Field in SORTED BY clause is not referenced.
    Explanation
    Natural for Db2: A field referenced in the SORTED BY clause
    is not referenced anywhere in the program.
    Action
    Check program and correct error.

#### NAT0790: No primary key in an IMS access.

    Text
    No primary key in an IMS access.
    Explanation
    Natural for Db2 needs a primary key for UPDATE or DELETE
    if the loop contains a terminal statement.
    Action
    Change program according to the Natural for Db2 file-server logic.

#### NAT0791: Data type not supported.

    Text
    Data type not supported.
    Explanation
    The search criterion contains a Natural variable or constant
    of a format that is not supported by the Db2 database manager.
    Unsupported formats are:
         I1    (integer with length of 1)
         L     (logical)
    Action
    Do not use the above formats in a program that accesses a Db2 database.

#### NAT0792: Null or length referenced without the master field.

    Text
    Null or length referenced without the master field.
    Explanation
    When referencing a length-indicator or null-indicator field,
    the corresponding master field to which the length or null
    indicator applies must also be referenced.
    Action
    Correct program.

#### NAT0793: Null or length indicator cannot be used as descriptor.

    Text
    Null or length indicator cannot be used as descriptor.
    Explanation
    A null indicator or length indicator cannot be used as a descriptor,
    only master fields can be used as search criteria.
    Action
    Change search criterion in Natural program.

#### NAT0794: SELECT FOR UDPATE, but UPDATE not allowed.

    Text
    SELECT FOR UDPATE, but UPDATE not allowed.
    Explanation
    This message also appears with the statement
    SELECT SINGLE FOR UPDATE where UPDATE is not allowed.
    Action
    Check and correct program.

#### NAT0797: Invalid use of set name in search criterion.

    Text
    Invalid use of set name in search criterion.
    Explanation
    A set name has been specified in the basic search criterion of a
    FIND statement; however
    - the file to be accessed is not an Adabas file, or
    - the search criterion belongs to a COUPLED criterion.
    In either case, a set name must not be used.
    See the Natural documentation, FIND statement, for information on
    the use of a set name.
    Action
    Change the search criterion in your program.

#### NAT0798: Invalid common table expression.

    Text
    Invalid common table expression.
    Explanation
    The specified common table expression is invalid. A common table
    expression has to follow the keyword WITH̲CTE and has the syntax:
    cte-name (colname,...) AS (fullselect).
    Most likely, parentheses, the keyword AS or commas are missing or
    specified too often.
    Action
    Correct the common table expression.

#### NAT0799: Scalar fullselect has to consist of a single column value.

    Text
    Scalar fullselect has to consist of a single column value.
    Explanation
    Scalar fullselect can be used as scalar values in expressions.
    Scalar fullselect is a fullselect enclosed in parentheses which
    returns a single row consisting of a single column value. The
    specified fullselect result set consists of more than one column.
    Action
    Specify only one column in the selection list of the fullselect.