Static Generation Messages and Codes Issued under NDB

#### Search Results

Search

# Static Generation Messages and Codes Issued under NDB

This section lists the error messages that may be issued during static generation under Natural for Db2 or Natural for SQL/DS.

STAT9001 | STAT9019 | STAT9030 | STAT9063
STAT9002 | STAT9020 | STAT9031 | STAT9064
STAT9003 | STAT9021 | STAT9032 | STAT9065
STAT9004 | STAT9022 | STAT9033 | STAT9066
STAT9005 | STAT9023 | STAT9034 | STAT9072
STAT9006 | STAT9024 | STAT9036 | STAT9073
STAT9007 | STAT9025 | STAT9039 | STAT9092
STAT9009 | STAT9026 | STAT9040 | STAT9093
STAT9014 | STAT9027 | STAT9041 | STAT9094
STAT9016 | STAT9028 | STAT9050 | STAT9095
STAT9017 | STAT9029 | STAT9062 | STAT9096

> STAT9001 Object buffer allocation failed. RC = return code

>   Program `NDBCHNK` has been invoked to allocate space for Natural object load, but the allocation has failed; retry or increase the free storage pool.

> STAT9002 Write on object area failed. RC = return code

>   Program `NDBCHNK` has been invoked to write a Natural object row into the appropriate buffer, but the write has failed; this is probably a `NDBCHNK` program error.

> STAT9003 Statement entry retrieve error. RC = return code

>   Program `NDBSTAT` has been invoked to retrieve next Db2 statement information from the Natural object loaded in main storage, but the retrieval has failed (RC was neither `0` (`OK`) nor `4` (`EOP`)); the probable cause is a Natural object inconsistency.

> STAT9004 Unsupported Adabas command: command

>   Program `NDBSTAT` has been invoked to retrieve next Db2 statement information from the Natural object loaded in main storage, but the Adabas command code returned was invalid; the probable cause is a Natural object inconsistency.

> STAT9005 Freemain failed. RC = return code

>   Program `NDBCHNK` has been invoked to free the area allocated for Natural object load, but the release has failed; this is probably a program error.

> STAT9006 Call for timestamp of program failed. RC = return code

>   Program `NDBSTAT` has been invoked to know the time stamp associated to the loaded Natural object, but the call has failed; this is probably a program error.

> STAT9007 A-List item retrieve failed. RC = return code

>   Program `NDBSTAT` has been invoked to retrieve the next compilation A-list element, but the retrieval has failed (`RC` was neither `0` (`OK`) nor `20` (`EOL`)); the probable cause is a Natural object inconsistency.

> STAT9009 Invalid database field format: format

>   Program `NDBSTAT` has been invoked to retrieve the next compilation A-list element, but the Db2 format code returned is invalid; the probable cause is a Natural object inconsistency.

> STAT9014 Warning, may indicate a problem: second select table reset.

>   The table for a second selection logs the statement number of all second `SELECT` statements. The table is reset if there are more than 100 entries, which means with many nested program loops. If the table is reset, no second `UPDATE` or `DELETE` statements are generated.

> STAT9016 Versions of NDBSTAT and SQLGEN Natural programs do not match.

>   The versions of the Natural programs used for the static generation (library `SYSSQL`) must be the same as one of the dynamically loaded Assembler program `NDBSTAT.`

> STAT9017 address of program program in library library not found.

>   A Natural object address was not found and the object cannot be modified. Either the object was not found or the address was wrong.

> STAT9019 *** Warning: Natural terminates abnormally, run may continue. ***

>   Warning: Natural terminates abnormally with `RC=4`. A Natural member was explicitly entered which does not exist or does not have SQL access. The static generation can continue.

> STAT9020 Start run of SQLGEN for DBRM dbrm.

> STAT9021 Start merging temporary datasets.

> STAT9022 Precompile input input written to temporary dataset.

>   The temporary assembler program for the precompiler input was written to a temporary dataset (Natural work file 6).

> STAT9023 *** END OF DATA ***

> STAT9024 No program with SQL access found.

>   None of the programs processed by the `CMD` command accessed an SQL system.

> STAT9025 Program program in library library not found.

> STAT9026 DB access module names module and module do not match.

>   The module name specified with the `CMD CREATE` command must be the same as the name of the DBRM specified in the `DBRMLIB` job card of the precompilation step.

> STAT9027 Error error purging program, library in buffer pool. Run continues.

> STAT9028 Number of programs to be generated exceeds 999.

>   The number of programs to be generated statically into one DBRM exceeds the maximum number of 999.

> STAT9029 Limit of limit NULL indicators per SQL statement exceeded.

>   The maximum number of 1500 `NULL` indicators per SQL statement has been exceeded.

> STAT9030 Number of variables to be generated exceeds 9999.

>   The number of variables to be generated statically for one program exceeds the maximum number of 9999.

> STAT9031 XREF option NO and Predict DDA default "YES" do not match.

>   The Predict DDA default setting for static SQL `XREF` is set to `YES` but the `XREF` option in the `CMD` command is set to `NO`.

> STAT9032 XREF option "FORCE" but no Predict documentation found.

>   With the `XREF` option `FORCE`, the static generation continues and writes `XREF` data only if Predict documentation exists for a given DBRM. If there is no Predict documentation available, static generation is not performed.

> STAT9033 No XREF data exist for member member.

>   Either the Natural program which is to be statically generated cannot be cataloged with `XREF=ON` or the `XREF` data are not on the used Predict file.

> STAT9034 XREF option "YES" or "NO" but Predict DDA default "FORCE".

>   The Predict DDA default setting for static SQL `XREF` is set to `FORCE`, but the `XREF` option in the `CMD` command is set to `NO` or `YES`.

> STAT9036 Given DBRM library not defined as 3GL Predict application.

>   The library for the DBRM entered with the `LIB` option is not defined as 3GL application in Predict. Check the library name in Predict which contains the DBRM.

> STAT9039 Library name must not be blank.

> STAT9040 CAT or STOW not allowed for library library.

>   The commands `CAT` or `STOW` are not allowed in your security environment. However, the `CAT` or `STOW` privilege is needed for static generation.

> STAT9041 Natural Security restriction. Message code: message code

> STAT9050 No Predict documentation for specified DBRM found.

>   No documentation was found in Predict for the DBRM specified with the `CMD` command. Either the DBRM is not documented in the used Predict file or a wrong DBRM name has been specified.

> STAT9062 No Predict installed or SM level less than SM4.

> STAT9063 XREF interface not linked. XREF option reset, run continues.

> STAT9064 XREF option not set. Predict DDA default default taken.

>   The Predict DDA default setting for static SQL `XREF` is read, because no `XREF` option is specified in the CMD command and the `XREF` interface and Predict are installed.

> STAT9065 DBRM name must start with an uppercase character.

> STAT9066 No Predict installed or SM level less than SM4, run continues.

> STAT9072 DBRM name must not be blank.

> STAT9073 Invalid syntax for parameter/option specified.

> STAT9092 Error occurred. XREF data for DBRM will be deleted.

> STAT9093 Error error occurred in program program on line line.

> STAT9094 Return code return code on call of program.

> STAT9095 Error in parameter parameter on call of program.

> STAT9096 program in library library timestamp mismatch.

>   The program was recataloged during the static generation process. The modify step did not change the program object. Static generation modify step continues with the next program.