SQL4010

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4010   DBMS CONNECTION MODULE FOR SQL WAS NOT INCLUDED IN APPLICATION

Meaning

A database connection module must be linked to each ISO/SQL application.

Response

Relink program with connection module.

SQL4011

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4011   DBMS CONNECTION MODULE INCLUDED FOR BOTH UDS/SQL AND SESAM/SQL

Meaning

Exactly one database connection module must be included for each ISO/SQL
application.

Response

Relink program with one connection module.

SQL4012

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4012   DMS ERROR '(&02)' WHEN OPENING LOG FILE '(&00)((&01)'; /HELP-MSG DMS(&02) IN SYSTEM MODE

Meaning

Write access and sufficient storage space is required for the log file
(diagnostic file).
This function is not active during normal operation.
For more detailed information about the DMS error code, enter /HELP-MSG in
system mode or see the BS2000 manual 'System Messages'
(&00)(&01): File name generated by ISO/SQL
     (&02): DMS code.

Response

Grant write access and/or make sufficient space available.

SQL4020

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4020   ISO/SQL NOT COMPATIBLE WITH AVAILABLE UTM VERSION

Meaning

The ISO/SQL version used must be compatible with the installed UTM
version.

Response

Have appropriate ISO/SQL version installed and repeat linking.

SQL4021

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4021   '(&00)' ILLEGAL LSSB NAME

Meaning

If ESQL programs are to execute in UTM applications, ISO/SQL requires
secondary storage space for processing SQL statements. The naming of
these secondary storage areas (LSSB) is subject to certain conventions.
The application program has used a name which does not conform with
these conventions.
(&00): Name of the LSSB.

Response

Change LSSB name (&00) to a name that does not conflict with the SQL
system
(at least the first character of the LSSB name must be modified).

SQL4022

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4022   SQL STATEMENT PRIOR TO KDCS INIT

Meaning

An SQL statement has been entered in a UTM dialog step prior to
executing the INIT function at the KDCS interface.

Response

Correct UTM program unit.

SQL4023

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4023   UTM APPLICATION LINK ERROR

Meaning

The SQL system requires access to KDCS in order to execute SQL statements
in UTM applications; this has to be taken into account when linking
the UTM application. The SQL system has detected that the application
has not been linked correctly.
The following errors occurred during the run of the static linkage loader:
- The INCLUDE statement for the SQLKDCS linkage module was omitted.
- The RENAME statement for the KDCS module was omitted or incorrect.
- The RENAME statement was executed for the SQLKDCS linkage module
   instead of the KDCS module.
- the INCLUDE statement for SQLCNVHP was omitted.

Response

Observe conventions for linking SQL statements with UTM.
Refer to the ESQL manual for the appropriate link statements.

SQL4101

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4101   UTM LSSB ERROR: ACCESS = '(&00)', LSSB NAME = '(&01)', KCRCCC = '(&02)'

Meaning

ISO/SQL requires secondary storage areas (LSSBs) for processing
SQL statements in UTM applications. This message is output if an
error occurs with SGET or SPUT.
(&01): LSSB name (internal ISO/SQL name)
(&02): KCRCCC; for meaning, refer to UTM manual.

Response

Submit diagnostic documentation to systems support, unless situation
can be dealt with be the user.

SQL4102

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4102   NOT ENOUGH OR NO EAM SPACE ON PVS

Meaning

ISO/SQL requires temporary areas for sorting tuple sets; these areas
are accessed via the EAM access method.

Response

Create or extend EAM space on PVS.

SQL4103

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4103   VERSION DEVIATION FROM ISO/SQL '(&00)' AND '(&01)'

Meaning

A deviation from the ISO/SQL version information has been detected.
(&00): Version of the  non-sharable part of ISO/SQL
(&01): Version of the sharable part of ISO/SQL.

Response

Link the application program using the most current ISO/SQL version.

SQL4104

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4104   SHARABLE PART OF ISO/SQL COULD NOT BE LOADED

Meaning

ISO/SQL consists of a sharable part and a non-sharable part.
The sharable part could not be loaded.

Response

Assign ISO/SQL library using the FILE statement.

SQL4105

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4105   TOO MANY CURSORS REQUIRING THE SQL CONVERTER DECLARED OR OPEN AT THE SAME TIME

Meaning

The converter work area for the storage of information on declared and
open cursors is exhausted.

Response

Reduce the number of cursors requiring the converter or the number of
cursors open at the same time.

SQL4111

Destination: USER-TASK             Routing code:                     Weight: 99

Warranty   : NO

SQL4111   SYSTEM ERROR OF ISO/SQL COMPONENT NO. (&00)

Meaning

An internal error occurred in ISO/SQL.
(&00): Code for the ISO/SQL component in which the error
       occurred:
       01: Runtime control
       02: ICSQL decoder
       03: TBX control
       04: TransBase
       05: ASN.1 generator
       06: DBH control
       07: UTM embedding / system embedding
       08: Logical resource manager
       09: Logging.

Response

Produce dump and submit error documentation to systems support.