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: Incorrect FETCH FIRST, OFFSET, OPTIMIZE FOR clause.

Text
Incorrect FETCH FIRST, OFFSET, OPTIMIZE FOR clause.
Explanation
1) An OPTIMIZE FOR cannot be supplied 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.
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 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 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 DB2 needs a primary key for UPDATE or DELETE
if the loop contains a terminal statement.
Action
Change program according the Natural 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:
     N     (numeric unpacked)
     I1    (integer with length of 1)
     L     (logical)
     D     (date)
     T     (time)
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.