OLQ 143012 in CA-OLQ SELECT statement

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

An IDMS statement in CA-OLQ results in the following error message:

 

OLQ 143012 08 Field too large to be in expression. 

Environment

CA-IDMS any supported release.

Cause

The internal design of OLQ restricts the length of any character field used in a COMPUTE statement, a built-in function, or a WHERE clause to 88 bytes.

 

An attempt to use a longer field results in the OQ143012 message.

Resolution

Use IDMS mode SQL (SET ACCESS IDMS) instead of OLQ mode (SET ACCESS OLQ).

This can be done in OLQ but it means that the SQL statement will be executed via the CA IDMS SQL Option. This is a much more robust engine which has no such restriction.

Using IDMS mode SQL will require the following:-

1.    The dictionary in use has a catalog component.

2.    There is an SQL schema defined for the non-SQL schema and database in use.

3.    Record names containing a hyphen ("-") will need to be double quoted, e.g "DENTAL-CLAIM" as opposed to DENTAL-CLAIM.

4.    Record names will need to be qualified with the SQL schema name (if not otherwise set at profile level), e.g. EMPNET."DENTAL-CLAIM".

 

5.    Hyphens ("-") in element names will need to be replaced with underscores ("_"), e.g. EMP_ID_0415 as opposed to EMP-ID-0415.

Additional Information

For more information, see the following CA IDMS DocOps pages:

Accessing Network-Defined Databases in the SQL Reference guide

Introducing the OLQ SELECT statement