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.