Natural System Error Messages 3700-3749

NAT3700: Error :1: with SQLSTATE :2: from call to :3:.

Text
Error ... with SQLSTATE ... from call to ....
Explanation
Each non zero SQLCODE is reported with this error message.
Action
Execute the program SQLERR to display the SQLCODE and
the related tokens. See the relevant IBM literature for an
explanation of the error condition.

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

Text
Natural SQL interface error with reason code ....
Explanation
Reason codes:
nnnn: See corresponding Natural error message number;
or one of the following:
100: HOST invalid function code       306: PRSS NATCVERT call failed
103: HOST error in GETMAIN            320: REQI internal save area full
104: HOST error in FREEMAIN           401: SQLP invalid function code
105: HOST error in ENQUEUE            402: SQLP invalid statement ID
106: HOST error in DEQUEUE            403: SQLP invalid statement number
201: REQI ADABAS command not emulated 404: SQLP command ID not found
202: REQI command ID not found        405: SQLP invalid statement CMCD
301: PRSS special SQL parse error     421: DB2P invalid function code
302: PRSS negative statement length   431: NSQO RDI coding > 254
303: DB2P special stmt not in NDBIOMO 432: NSQO MVC not found
305: PRSS special SQL parse error     433: NSQO LA not found
Action
305: PRSS special SQL parse error     433: NSQO LA not found
Contact Software AG.

NAT3702: Invalid packed field.

Text
Invalid packed field.
Explanation
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 value of "m" must not exceed 29, and the sum of the values of
"nn" and "m" must not exceed 29.
Action
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.
Explanation
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.
Action
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.
Explanation
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.
Action
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"...".
Explanation
The file server routine returned an error:
 01 Global directory full.          16 Logical file already open.
 02 Local directory full.           17 Logical file not open.
 03 Global directory inconsistent.  18 Logical file not closed.
 04 Dataset open error.             19 Logical file open output on read.
 05 Dataset read error.             20 Logical file open input on write.
 06 Dataset write error.            21 Invalid function code.
 07 ENQUEUE failed.                 22 Invalid open mode.
 08 DEQUEUE failed.                 23 Invalid re-read at top of file.
 10 DB2SIZE parameter invalid.      24 Invalid read-back (top of file).
 11 System GETMAIN failed.          25 Invalid buffer length.
 12 System FREEMAIN faile.          26 User space exceeded.
 14 Not enough space in dataset.    27 Global space map invalid.
 15 Logical file not allocated.     28 Global directory invalid.
Action
 15 Logical file not allocated.     28 Global directory invalid.
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.
Explanation
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.
Action
- 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.
Explanation
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.
Action
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.
Explanation
The loaded static program has no reference to the current
Natural statement.
Action
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.
Explanation
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.
Action
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.
Explanation
Natural tried to access Db2 via the CICS/Db2 attachment facility,
but this facility was not active.
Action
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.
Explanation
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.
Action
Correct error in program.

NAT3712: Natural SQL interface not active.

Text
Natural SQL interface not active.
Explanation
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.
Action
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".
Action
Specify valid function code.

NAT3714: Error :1: during :2: processing :3:, reason x":4:".

Text
Error :1: during :2: processing :3:, reason x":4:".
Explanation
Error code :1: occurred during the :2: processing of function :3:,
and reason code :4: was returned.
:2: is the name of the Db2 interface used, either CAF (call attachment
facility) or RRSAF (resource recovery services attachment facility).
:4: is the name of the failing function.
Action
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"...".
Explanation
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.
Action
Contact your Com-plete administrator.

NAT3716: ISQL processor not installed.

Text
ISQL processor not installed.
Explanation
During the installation of the Natural SQL interface, the module NDBISQ
was not included in the link-edit of the NDB nucleus.
Action
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.
Explanation
The special SQL statement used in the PROCESS SQL command is
- syntactically wrong
- not supported because of the use of literals
Action
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.
Action
Contact Software AG

NAT3719: Statement table overflow.

Text
Statement table overflow.
Explanation
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.
Action
Contact your Natural administrator.
Increase the 2nd parameter in the generation of the NDBIOMO.

NAT3720: Invalid SQL database type encountered during processing.

Text
Invalid SQL database type encountered during processing.
Explanation
The SQL database type encountered does not exist.
Action
Contact your Natural administrator.

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

Text
Buffer for ISQL processor (DB2SIZE5) could not be allocated.
Explanation
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.
Action
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.
Explanation
An overflow occurred in the internal table which maintains the open
(=nested) database loops.
Action
Contact your Natural administrator.
Increase the MAXLOOP parameter in the NTDB2 macro.

NAT3723: No more space available.

Text
No more space available.
Explanation
During the execution of an SQL statement working storage is GETMAINed
outside the Natural thread but there is not enough space available.
Action
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"...".
Explanation
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.
Action
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.
Explanation
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 NTDB2 macro, the ET is either aborted with
this error message, or ignored without any further notification.
Action
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"...".
Explanation
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.
Action
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"...".
Explanation
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.
Action
Check reason.

NAT3728: Invalid parameter for GET/SET GA.

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

NAT3729: SQL statement "COMMIT" not allowed.

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

NAT3730: SQL statement "ROLLBACK" not allowed.

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

NAT3731: Not enough cursors defined in NDBIOMO.

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

NAT3732: No :1: in NDBIOMO available.

Text
No ... in NDBIOMO available.
Explanation
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
Action
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.
Action
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.
Explanation
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.
Action
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.
Explanation
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:)
Action
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.
Explanation
The used NDBIOMO in the Natural session was generated with a DB2Vnn
version parameter, which does not support the special Db2 SQL statement
to be executed.
Action
Generate the NDBIOMO with the necessary DB2Vnn version or do not use
the DB2 special 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 ....
Explanation
The Natural object was STOWed using the NDB version
in .1. but executed in the older version .2.
Action
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.
Explanation
The Natural interface .1. for the requested SQL system .2.
is not installed.
Action
Contact your Natural administrator.

NAT3739: SQLDISCONNECT not allowed while a transaction is open.

Text
SQLDISCONNECT not allowed while a transaction is open.
Explanation
SQLDISCONNECT cannot be executed while a transaction is open.
Action
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:
Explanation
The refresh of either CURRENT SERVER or CURRENT PACKAGESET or CURRENT
SQLID failed with SQLCODE :2: during begin of Db2 Database transaction.
Action
Contact Customer Service.

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

Text
GETMAIN for dynamic SQL string failed with code X"...".
Explanation
Natural statement containing text variables failed
due to GETMAIN problems during dynamic creation of
the SQL string.
Action
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.
Explanation
During creation of the dynamic SQL string built
from text variables an internal logical problem
occurred.
Action
Contact Customer Service

NAT3744: IF NO RECORDS not allowed in SELECT with SCROLL and GIVING.

Text
IF NO RECORDS not allowed in SELECT with SCROLL and GIVING.
Explanation
IF NO RECORDS FOUND is not allowed in a SELECT statement with SCROLL
and GIVING clause. When using SCROLL and GIVING clauses the application
requests to act on the returned SQLCODE in the GIVING variable. This
causes the NO RECORDS FOUND block never to be executed. Therefore the
NO RECORDS FOUND clause is useless and not allowed.
Action
Remove either the NO RECORDS FOUND clause or the GIVING clause
from the SQL statement.

NAT3748: Error :1: in Natural for Db2 for zIIP with reason :2:.

Text
Error ... in Natural for Db2 for zIIP with reason ....
Explanation
An error occurred when a SQL statement was being processed using
Natural for Db2 for zIIP. See the NDZ started task log and
NDZ documentation for more details about the error.
Following are error return codes and their meaning:

201 - NDZ Sever not available
202 - Invalid client address
203 - Error releasing pause element
204 - Error pausing client task
205 - Pending stop request for client
206 - Client JOBID doesn't match
207 - Pending request for client
500 - Error creating User Context
501 - Error registering static statement
502 - Error opening static statement
550 - Error while establishing a connection
551 - Error while creating pooled connection
552 - Error creating pooled connections. Number of connections exceed maximum clients
600 - The statement type ... is not supported by NDZ
601 - The type ... is not supported by NDZ
602 - NDZ does not support the set var statement requested
650 - The encoding ... is not supported
700 - Error while creating a LOB file ...
701 - Error while reading a LOB file ...
703 - Error fetching data from LOB column

NAT3749: NDB tools internal error.

Text
NDB tools internal error.
Action
Contact Software AG