## 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.

©2024 Fujitsu | BS2000 System Messages