ERROR CODE -999 IN PROG keyDef AT LINE 1453 (SORTPRP)

Products

• Datacom
• DATACOM - AD
• Datacom/DB
• Datacom/AD

Issue/Introduction

A Datacom table can be successfully accessed in native non-SQL mode  but, when trying to read the same data via an SQL application, an  SQLRC -999 is returned to the application.

PXX dump shows the following error message:

S0004 SQLSTATE 56S19 OCCURRED WITH SQL ERROR CODE -999 IN PROG keyDef AT LINE 1453 (SORTPRP) 
S0004 ERROR MESSAGE TEXT: INTERNAL ERROR (keyDef @ LINE 1453): rowLn bad 

Similarly, an SQL query executed from CA Dataquery returns:

DQ093E - INTERNAL ERROR (keyDef@ LINE 1453): rowLn bad 

 

Environment

Release: 15.1
Component: Datacom SQL Option

Cause

This error is usually returned because one (or both) of the following reasons:

• SQL-ACCESS attribute for the table in Datadictionary is set to N
• SQL-INTENT is returned as an asterisk in CXX report (SQL-INTENT - *)

Resolution

• if SQL-ACCESS is set to N, make the table SQL accessible (see "Making Existing Tables SQL Accessible" section of Datacom documentation)
• if SQL-ACCESS is already set to Y but SQL-INTENT is an asterisk, catalog the related database