Version 4.2.6 for Mainframes
 —  Messages and Codes  —

Natural System Error Messages 3701-3750

NAT3701: Natural SQL interface error with reason code :1:.

Text Natural SQL interface error with reason code ....
Expl. Reason Codes:
3nnn - See corresponding Natural error message number.
100 - Invalid I/O request.
101 - UPDATE/DELETE statement too long for dynamic execution.
102 - GETMAIN failed: increase region size, or MEMRES (only Com-plete).
201 - Statement not supported.
202 - SELECT not found or cursor not opened.*
203 - Severe internal error.*
204 - Too many nested database loops: increase STATEMENT TABLE.
205 - SQLID could not be set.
206 - Database ID "250" is not a DB2 or SQL/DS database.
* may be caused by END/BACKOUT TRANSACTION inside a
database loop.
Actn. database loop. Contact Software AG

NAT3702: Invalid packed field.

Text Invalid packed field.
Expl. Fields defined with packed format must be in the form "nn.m".
"nn" represents the number of digits before the decimal point,
and "m" represents the number of digits after the decimal point.
The aggregate value of "nn" and "m" must not exceed 27, and the
value of "m" must not exceed 7.
Actn. Check program and correct error.

NAT3703: Field modified by another user or row not found.

Text Field modified by another user or row not found.
Expl. 1) The positioned UPDATE or DELETE command to DB2 checks if the record
contents is still identical to what the user had read before.
Because of the automatic "COMMIT" issued by IMS/TM or CICS pseudo-
conversational mode at terminal I/O time, the "hold" status of the
record is lost and the record is free to be modified by another user.
Natural then cancels the current transaction with this error message.
2) If sensitive dynamic scrollable cursors are used in an IMS/TM or CICS
pseudo-conversational environment across terminal I/Os, the sensitive
dynamic scrollable cursor is implicitly closed upon terminal I/O.
NDB re-opens the cursor after terminal I/O and tries to position the
cursor to the row which was current before the terminal I/O. The number
of re-positional fetches are limited by the parameter RETRYPO in each
direction from the position noted before the terminal I/O.
The default value of RETRYPO is 10.
Actn. The default value of RETRYPO is 10. 1)Retry this operation.
2)For sensitive dynamic scrollable cursors re-execute the program and
increase the RETRYPO value if necessary.

NAT3704: Update/repositioning not possible after automatic COMMIT.

Text Update/repositioning not possible after automatic COMMIT.
Expl. Natural tries to re-read a given DB2 record after a terminal I/O
which has caused IMS/TM or CICS in pseudo-conversational mode to issue
an automatic COMMIT. This COMMIT loses the current record.
The re-reading is only possible if the record can be identified
via a unique index and the corresponding fields are all read into
the data view. This error occurs also during repositioning of
sensitive dynamic scrollable cursors after a terminal I/O if the
desired row could not be repositioned due to a missing unique key
column.
Actn. Update the record before the automatic COMMIT,
or add a unique-index field to your data view.

NAT3705: File server error :1: with reason x":2:".

Text File server error ... with reason x"...".
Expl. The file server routine returned an error:
01 Global directory full. 14 Not enough space in dataset.
02 Local directory full. 15 Logical file not allocated.
03 Global directory inconsistent. 16 Logical file already open.
04 Dataset open error. 17 Logical file not open.
05 Dataset read error. 18 Logical file not closed.
06 Dataset write error. 19 Logical file open output on read.
07 ENQUEUE failed. 20 Logical file open output on write
08 DEQUEUE failed. 21 Invalid function code.
09 Time-out on global direct wait. 22 Invalid open mode.
10 DB2SIZE parameter too small. 23 Invalid re-read at top of file.
11 System GETMAIN failed. 24 Invalid read-back (top of file).
12 System FREEMAIN failed. 25 Recsize greater than 32K.
13 WAIT request failed. 26 User space exceeded.
Actn. 13 WAIT request failed. 26 User space exceeded. Restart Natural and retry the operation.
If the problem persists, contact your Natural administrator.

NAT3706: Static program :1: cannot be loaded.

Text Static program ... cannot be loaded.
Expl. The static program referenced in the Natural SQL program
cannot be loaded for one of the following reasons:
- The static program is not contained in the load libraries currently
defined to Natural.
- There is not enough storage available for dynamic loading of a
static program.
- The limit for the number of dynamically loadable user programs was
exceeded (parameter CDYNAM).
- Under Com-plete, the program was neither defined as RESIDENTPAGE
nor cataloged via ULIB.
- Under Com-plete the thread into which the program is to be loaded
is too small.
- Under CICS a PPT entry for the program is missing.
Actn. - Under CICS a PPT entry for the program is missing. Check for the above error situations, or (as a by-pass)
recatalog the program to clear the reference to the static program.

NAT3707: Loaded static program does not match Natural program.

Text Loaded static program does not match Natural program.
Expl. The static program referenced in the Natural program has been loaded;
however, either the static program was not generated for this Natural
program, or its time-stamp is different from that of the Natural
program.
Actn. Replace the static program in the load library with the correct version,
or re-generate the static program.

NAT3708: Static program cannot handle current Natural statement.

Text Static program cannot handle current Natural statement.
Expl. The loaded static program has no reference to the current
Natural statement.
Actn. Replace the static program in the load library by the correct version,
or re-generate the static program.

NAT3709: Not enough storage for static program.

Text Not enough storage for static program.
Expl. The static program needs an area of main memory in which to
create the SQLDSECT. The area available, however, was not
large enough.
This can only happen if errors during the assembly of the
static program have been ignored.
Actn. Check the assembly of the static program for assembly errors
concerning variables in the SQLDSECT.

NAT3710: CICS/DB2 attachment facility is not active.

Text CICS/DB2 attachment facility is not active.
Expl. Natural tried to access DB2 via the CICS/DB2 attachment facility,
but this facility was not active.
Actn. Ask your CICS administrator to start the CICS/DB2 attachment facility.

NAT3711: Now it is too late for BACKOUT TRANSACTION.

Text Now it is too late for BACKOUT TRANSACTION.
Expl. The program contains a design error: it attempts to backout updates
which have already been committed. A terminal I/O has forced the end
of the logical unit of work; nevertheless, the BACKOUT TRANSACTION
has been issued. This means that the actual scope of the BACKOUT
TRANSACTION is different from the expected one.
Actn. Correct error in program.

NAT3712: Natural SQL interface not active.

Text Natural SQL interface not active.
Expl. The access to SQL is disabled for one of the following reasons:
- The parameter DB2SIZE is set to 0.
- During the initialization of Natural, the Natural SQL interface
could not be initialized because of a (reported) error.
Actn. Correct the error which occurred during the Natural initialization,
or specify DB2SIZE > 0.

NAT3713: Function code for DB2SERV must be "D", "E" or "P".

Text Function code for DB2SERV must be "D", "E" or "P".
Actn. Specify valid function code.

NAT3714: Error during CAF connection process, reason x":1:".

Text Error during CAF connection process, reason x"...".
Expl. An error has occurred during the CAF (Call Attachment Facility)
connection process, probably because no plan has been scheduled.
Reason contains the hexadecimal reason code returned from the CAF
interface.
Actn. See the relevant IBM literature for an explanation of the reason code.
If more information is required, activate DSNTRACE.

NAT3715: Error in Com-plete to DB2 connection, reason x":1:".

Text Error in Com-plete to DB2 connection, reason x"...".
Expl. An error occurred when Com-plete tried to connect the user
to DB2.
Reason codes (set by Com-plete):
04 - DB2 interface not defined to Com-plete.
08 - DB2 interface could not be initialized by Com-plete.
12 - No DB2 thread within Com-plete available.
Actn. Contact your Com-plete administrator.

NAT3716: ISQL processor not installed.

Text ISQL processor not installed.
Expl. During the installation of the Natural SQL interface, the module NDBISQ
was not included in the link-edit of the NDB nucleus.
Actn. Contact your Natural administrator.
Review the installation of the environment-independent NDB nucleus.

NAT3717: Special SQL statement in error.

Text Special SQL statement in error.
Expl. The special SQL statement used in the PROCESS SQL command is
- syntactically wrong
- not supported because of the use of literals
Actn. Correct the SQL statement and use Natural variables instead of literals.

NAT3718: Special SQL statement found, not prepared.

Text Special SQL statement found, not prepared.
Actn. Contact Software AG

NAT3719: Statement table overflow.

Text Statement table overflow.
Expl. No free DECLARE STATEMENT in the NDBIOMO is available to execute the SQL
statement in dynamic mode. This will only happen if all STATEMENTS are
actually used by open data base loops.
Actn. Contact your Natural administrator.
Increase the 2nd parameter in the generation of the NDBIOMO.

NAT3720: Invalid SQL database system specified in macro NDBID.

Text Invalid SQL database system specified in macro NDBID.
Expl. The DBID specified in the macro NDBID does not exist.
This error will also occur if you use DBSERV with function code "U" but
you are not running SQL/DS.
Actn. Contact your Natural administrator.

NAT3721: Buffer for ISQL processor (DB2SIZE5) could not be allocated.

Text Buffer for ISQL processor (DB2SIZE5) could not be allocated.
Expl. The ISQL processor requires an buffer of 8K which is allocated in the
Natural thread but the Natural thread is not large enough to hold this
buffer.
Actn. Contact your Natural administrator.
Reduce Natural"s total area size allocations, or increase the Natural
thread.

NAT3722: Too many nested database loops.

Text Too many nested database loops.
Expl. An overflow occurred in the internal table which maintains the open
(=nested) database loops.
Actn. Contact your Natural administrator.
Increase the MAXLOOP parameter in the generation of the NDBPARM.

NAT3723: No more space available.

Text No more space available.
Expl. During the execution of an SQL statement working storage is GETMAINed
outside the Natural thread but there is not enough space available.
Actn. Contact your Natural administrator.
Increase the region size, or MEMRES (only Com-plete).

NAT3724: Error in ET processing via TP driver, reason x":1:".

Text Error in ET processing via TP driver, reason x"...".
Expl. Under CICS and IMS/TM, the ET is processed via the corresponding TP
driver, but the ET failed.
Under IMS/TM, the reason is the hexadecimal representation of the DL/I
status code.
Under CICS, the reason is the hexadecimal representation of the
EIBRCODE.
Actn. Check the reason against the DL/I or CICS documentation.

NAT3725: ET in message-driven IMS region could not be executed.

Text ET in message-driven IMS region could not be executed.
Expl. In a message-driven IMS/TM region (MPP or message-oriented BMP) no
Natural programmed ET is executed. Depending on the setting of the
parameter ETIGN in the NDBPARM, the ET is aborted with this error
message, or ignored without any further notification.
Actn. Check your program for obsolete ETs.

NAT3726: Error during BT processing via TP driver, reason x":1:".

Text Error during BT processing via TP driver, reason x"...".
Expl. Under CICS and IMS/TM, the BT is processed via the corresponding TP
driver, but the BT failed.
Under IMS/TM, reason is the hexadecimal representation of the DL/I
status code.
Under CICS, reason is the hexadecimal representation of the EIBRCODE.
Actn. Check the reason against the DL/I or CICS documentation.

NAT3727: Error during ET/BT processing via NDL, reason x":1:".

Text Error during ET/BT processing via NDL, reason x"...".
Expl. In the DSNMTV01 environment, ET and BT calls are processed by the e
Natural to DL/I interface, but the ET/BT failed.
Reason contains the hexadecimal representation of the reported NDL
error.
Actn. Check reason.

NAT3728: Invalid parameter for GET/SET GA.

Text Invalid parameter for GET/SET GA.
Actn. Contact Software AG.

NAT3729: SQL statement "COMMIT" not allowed.

Text SQL statement "COMMIT" not allowed.
Expl. The SQL statement "COMMIT" is not allowed with PROCESS SQL.
Actn. Use the Natural statement COMMIT or END TRANSACTION.

NAT3730: SQL statement "ROLLBACK" not allowed.

Text SQL statement "ROLLBACK" not allowed.
Expl. The SQL statement "ROLLBACK" is not allowed with PROCESS SQL.
Actn. Use the Natural statement ROLLBACK or BACKOUT TRANSACTION.

NAT3731: Not enough cursors defined in NDBIOMO.

Text Not enough cursors defined in NDBIOMO.
Actn. Contact Software AG.

NAT3732: No :1: in NDBIOMO available.

Text No ... in NDBIOMO available.
Expl. During runtime a Natural for DB2 user program requests one of the
following features
1) "ALLOCATE CURSOR" (READ RESULT SET statement)
2) "CURSOR with RETURN" (SELECT WITH RETURN STATEMENT)
3) "CURSOR WITH HOLD" (SELECT WITH HOLD statement)
but the appropriate DB2-environment parameter was not set correctly
during NDBIOMO generation
1) DB2V5
2) DB2V5
3) DB2V23
Actn. Generate the NDBIOMO with the first parameter set to DB2V5/DB2V23 or
remove the failing statement from the Natural program if you do not
have the right DB2 environment.

NAT3733: "CID" already in use.

Text "CID" already in use.
Actn. Contact Software AG.

NAT3734: Invalid data type for Natural variable used in PROCESS SQL.

Text Invalid data type for Natural variable used in PROCESS SQL.
Expl. Some special SQL statements which cannot be executed in dynamic mode are
executed by NDBIOMO in static mode. As all host variables are predefined
in the NDBIOMO, the corresponding Natural variables must be of the same
data type.
Actn. Correct the data type of your Natural variable.
The correct definition for the variable can be found in the DB2
documentation.

NAT3735: Invalid data length for Natural variable used in PROCESS SQL.

Text Invalid data length for Natural variable used in PROCESS SQL.
Expl. Some special SQL statements which cannot be executed in dynamic mode are
executed by NDBIOMO in static mode. As all host variables are predefined
in the NDBIOMO, the length of the corresponding Natural variable must be
- not longer for input variables (:U:)
- not shorter for output variables (:G:)
Actn. Correct the data length of your Natural variable
The correct length for the variable can be found in the DB2
documentation.

NAT3736: SQL statement in PROCESS SQL is not available in NDBIOMO.

Text SQL statement in PROCESS SQL is not available in NDBIOMO.
Expl. During the generation of the NDBIOMO the first parameter was not set to
DB23 but one of the special DB2 2.3 SQL statements should be executed.
Actn. Generate the NDBIOMO with the first parameter set to DB23 or don"t use
an DB2 2.3 statement in the PROCESS SQL.

NAT3737: NAT object STOWed under NDB :1: but executed under :2:.

Text NAT object STOWed under NDB ... but executed under ....
Expl. The Natural object was STOWed using the NDB version
in .1. but executed in the older version .2.
Actn. Re-STOW your Natural program using version .2. .

NAT3738: Natural interface :1: for SQL system :2: not installed.

Text Natural interface ... for SQL system ... not installed.
Expl. The Natural interface .1. for the requested SQL system .2.
is not installed.
Actn. Contact your Natural administrator.

NAT3739: SQLDISCONNECT not allowed while a transaction is open.

Text SQLDISCONNECT not allowed while a transaction is open.
Expl. SQLDISCONNECT cannot be executed while a transaction is open.
Actn. Issue END TRANSACTION or BACKOUT TRANSACTION before executing
SQLDISCONNECT.

NAT3740: Refresh of :1: failed with SQLCODE :2:

Text Refresh of :1: failed with SQLCODE :2:
Expl. The refresh of either CURRENT SERVER or CURRENT PACKAGESET or CURRENT
SQLID failed with SQLCODE :2: during begin of DB2 Database transaction.
Actn. Contact Customer Service.

NAT3741: GETMAIN for dynamic SQL string failed with code X":1:".

Text GETMAIN for dynamic SQL string failed with code X"...".
Expl. Natural statement containing text variables failed
due to GETMAIN problems during dynamic creation of
the SQL string.
Actn. Increase DB2SIZE or Natural threadsize
or decrease size of SQL string containing text
variables in program

NAT3742: Logic error during creation of dynamic SQL string.

Text Logic error during creation of dynamic SQL string.
Expl. During creation of the dynamic SQL string built
from text variables an internal logical problem
occurred.
Actn. Contact Customer Service

NAT3743: NDBPARM module could not be located.

Text NDBPARM module could not be located.
Expl. The runtime of Natural for DB2 failed to locate the
NDBPARM module (ENTRY XCMSQLE) although the module
could be located earlier during the Natural session.
Actn. Contact Customer Service

NAT3749: NDB tools internal error.

Text NDB tools internal error.
Actn. Contact Software AG

NAT3750: Invalid statement.

Text Invalid statement.
Expl. 1. The Natural program contains a statement which cannot
be executed against a DL/I database,
such as STORE ISN, GET ISN, etc.
2. The Natural nucleus issued a request to the Natural DL/I nucleus
to execute an invalid Adabas command.
Module name: NDPRRR00
Problem Determination: Item 1 (a snap of Adabas control block is
provided, trace parameter = (CMD)).
Actn. Check program and correct error.
If necessary, contact Software AG support.

Top of page