| Text | ... class .../... failed, reason ... .... |
| Expl. | 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. |
| Text | Handle/dynamic variables and X-arrays cannot be redefined. |
| Expl. | 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. |
| Actn. | Check and correct the variable definitions. |
| Text | Incorrect OPTIMIZE FOR clause. |
| Expl. | 1) An OPTIMIZE FOR cannot be supplied for a SELECT SINGLE
statement. 2) The value specified in the OPTIMIZE FOR is not an integer constant. 3) The keyword ROWS is missing after the integer constant. |
| Actn. | Check and correct syntax. |
| Text | Incorrect use of UPDATE/DELETE .. WHERE CURRENT CURSOR. |
| Expl. | An UPDATE/DELETE table WHERE CURRENT CURSOR must reference a
SELECT statement. It cannot, for example, reference a FIND statement. |
| Actn. | Check and correct syntax. |
| Text | UPDATE/DELETE table mismatch with SELECT statement. |
| Expl. | 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. |
| Actn. | Check and correct syntax. |
| Text | Incorrect alphanumeric constant specified in <<...>>. |
| Expl. | The constant specified in <<...>> does not adhere to
the rules for Natural constants. For example, alpha constants must be enclosed in apostrophes. |
| Actn. | Check and correct syntax. |
| Text | Variable reference in <<...>> cannot be resolved. |
| Expl. | 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. |
| Actn. | Check and correct syntax. |
| Text | No valid correlation name after AS keyword in FROM clause. |
| Expl. | A correlation name is required after the keyword AS in the FROM clause of a SELECT statement. This name could not be found. |
| Actn. | Either drop the keyword AS or insert a valid correlation name behind the keyword. |
| Text | Keyword JOIN expected after INNER, LEFT, RIGHT, FULL, etc. |
| Expl. | The keyword JOIN is required after one of the keywords INNER, LEFT, LEFT OUTER, RIGHT, RIGHT OUTER, FULL, FULL OUTER. |
| Actn. | Insert the keyword JOIN. |
| Text | A correlation name is required in the FROM clause. |
| Expl. | When a subquery is specified in a FROM clause, a correlation name is required. This name must follow the SUBSELECT clause. |
| Actn. | Insert a correlation name after the subquery within the FROM
clause. |
| Text | No valid table reference found in FROM clause. |
| Expl. | The FROM clause contains no valid table name. Either specify a table name or a subquery of a joined table expression. |
| Actn. | Correct the FROM clause by specifying a valid table name. |
| Text | Illegal use of keyword VALUE or COALESCE in join. |
| Expl. | 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. |
| Actn. | Use VALUE and COALESCE keywords only if a FULL join is specified. |
| Text | Closing bracket missing in nested joined-table expression. |
| Expl. | In a nested joined-table expression, the number of opening
brackets must be equal to the number of closing brackets. |
| Actn. | Insert a closing bracket. |
| Text | Expression requires join-condition keyword ON. |
| Expl. | 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> |
| Actn. | Insert the keyword ON. |
| Text | Join-condition contains an invalid relational operator. |
| Expl. | 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. |
| Actn. | Specify a valid relational operator. |
| Text | At least two column names must follow VALUE or COALESCE. |
| Expl. | 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. |
| Actn. | Insert the missing comma, operand, or parenthesis. |
| Text | Column name does not belong to any table to be joined. |
| Expl. | 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. |
| Actn. | Check column names to determine which do not belong to a joined table. Correct the table name in the join expression. |
| Text | Program cannot be executed. |
| Expl. | While loading the Natural program, an internal, non-recoverable
error has occurred. The program could not be loaded into the Natural buffer pool. |
| Actn. | Check program and/or contact your Natural administrator. |
| Text | Buffer pool full. |
| Expl. | The Natural buffer pool is full. With Natural Version 2, the cataloged Natural program must be loaded into the Natural buffer pool. If there is not enough space available, the program cannot be executed. |
| Actn. | Contact your Natural administrator. |
| Text | Program not ready for execution. |
| Expl. | 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. |
| Actn. | Execute the program at a later point in time. |
| Text | Program cannot be executed. |
| Expl. | This message appears if Natural has tried unsuccessfully 32 times to load the program into the Natural buffer pool. |
| Actn. | Contact your Natural administrator. |
| Text | Invalid Case-Expression. |
| Expl. | The specified Case-Expression is invalid. Either the keywords ELSE, THEN, WHEN , END are misplaced or one of these keywords is missing or one of the Sub-Expressions is invalid. |
| Actn. | Check the syntax of the Case-Expression and correct it. |
| Text | Internal Natural DB2 error. |
| Actn. | Provide the Natural source and object program and contact Software AG support. |
| Text | No fields were selected by a FIND or READ statement. |
| Expl. | 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. |
| Actn. | Retrieve at least one field in the FIND or READ statement. |
| Text | Invalid Natural statement for DB2 access. |
| Expl. | The following Natural statements are not supported when accessing a DB2 database: - GET - STORE USING NUMBER (ISN) |
| Actn. | Check program and correct error. |
| Text | Insufficient space for SQL ... generation. |
| Expl. | 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. |
| Actn. | Start Natural in greater thread/partition/region, or reduce the
number or size of SQL statements. |
| Text | Internal Natural DB2 error. |
| Actn. | Provide the Natural source and object program, and contact Software AG support. |
| Text | No fields assigned for an UPDATE statement. |
| Expl. | Natural DB2: An UPDATE statement is present, but no database fields are specified for the view. |
| Actn. | Assign a value to a DB2 column. |
| Text | A read-only field may not be modified. |
| Expl. | Natural DB2: Read-only fields were specified in an UPDATE
statement. This is not allowed, because these fields may not be modified. |
| Actn. | Check program and correct error. |
| Text | UPDATE/DELETE must not be used in conj. with FIND SORTED. |
| Expl. | 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. |
| Actn. | Correct error in program. |
| Text | Field in SORTED BY clause is not referenced. |
| Expl. | Natural DB2: A field referenced in the SORTED BY clause is not referenced anywhere in the program. |
| Actn. | Check program and correct error. |
| Text | No primary key in an IMS access. |
| Expl. | Natural DB2 needs a primary key for UPDATE or DELETE if the loop contains a terminal statement. |
| Actn. | Change program according the Natural DB2 file-server logic. |
| Text | Data type not supported. |
| Expl. | 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) |
| Actn. | Do not use the above formats in a program that accesses a DB2
database. |
| Text | Null or length referenced without the master field. |
| Expl. | 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. |
| Actn. | Correct program. |
| Text | Null or length indicator cannot be used as descriptor. |
| Expl. | A null indicator or length indicator cannot be used as a
descriptor, only master fields can be used as search criteria. |
| Actn. | Change search criterion in Natural program. |
| Text | SELECT FOR UDPATE, but UPDATE not allowed. |
| Expl. | This message also appears with the statement SELECT SINGLE FOR UPDATE where UPDATE is not allowed. |
| Actn. | Check and correct program. |
| Text | Invalid use of set name in search criterion. |
| Expl. | 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. |
| Actn. | Change the search criterion in your program. |
| Text | Invalid common table expression. |
| Expl. | 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. |
| Actn. | Correct the common table expression. |
| Text | Scalar fullselect has to consist of a single column value. |
| Expl. | Scalar fullselect can be used as scalar values in expressions. Scalar fullselect is a fullselect enclosed in parantheses, which returns a single row consisting of a single column value. The specified fullselect result set consists of more than one column. |
| Actn. | Specify only one column in the selection list of the fullselect. |
| Text | Logon failed after ... consecutive errors. |
| Expl. | The Natural session has been terminated as a result of too many unsuccessful logon attempts. |
| Actn. | Start a new Natural session after verifying your user ID and/or password. |
