OLQ 143012 in CA-OLQ SELECT statement

Document ID : KB000005046
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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