This section lists the error messages that may be issued during static generation under Natural for DB2 or Natural for SQL/DS.
- 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 aNDBCHNK
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 neither0
(OK
) nor4
(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 neither0
(OK
) nor20
(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 secondUPDATE
orDELETE
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 programNDBSTAT.
- 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 theDBRMLIB
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 toYES
but theXREF
option in theCMD
command is set toNO
.- STAT9032 XREF option "FORCE" but no Predict documentation found.
With the
XREF
optionFORCE
, the static generation continues and writesXREF
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 theXREF
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 toFORCE
, but theXREF
option in theCMD
command is set toNO
orYES
.- 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
orSTOW
are not allowed in your security environment. However, theCAT
orSTOW
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 noXREF
option is specified in the CMD command and theXREF
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.