CA Datacom SQLCA field SQLCA-LUWID internal
search cancel

CA Datacom SQLCA field SQLCA-LUWID internal

book

Article ID: 70365

calendar_today

Updated On:

Products

Datacom

Issue/Introduction

After upgrading to CA Datacom/DB Version 14.0 or above, compile of my existing COBOL program received this error on a "DISPLAY SQLCA-LUWID" because field SQLCA-LUWID was no longer present in the generated SQLCA: 

   IGYPS2121-S   "SQLCA-LUWID" was not defined as a data-name.  The statement was discarded.

I am only displaying the field and have no other purpose. 

This worked prior to Datacom/DB Version 14.0.

Environment

Release:    15.1 15.0 14.0

CA Datacom/DB

Cause

Starting with CA Datacom/DB Version 14.0, the following fields replaced SQLCA-LUWID: 

  05 SQLCA-STAMP PIC X(4). 
  05 SQLCA-FLAG1 PIC X(1). 
  05 SQLCA-FLAG2 PIC X(1). 
  05 SQLCA-FLAG3 PIC S9(4) COMP. 

Resolution

The SQLCA fields were and remain internal fields so there is no need for an application program to reference them.
The user program needs to be modified.

Additional Information

Refer to CA Datacom Core 15.1 section "SQL Communication Area (SQLCA)".

CA Datacom/DB SQL User Guide 14.02 still refers to SQL_LUWID.