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

book

Article ID: 33192

calendar_today

Updated On:

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 ([email protected] LINE 1453): rowLn bad 

 

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 - *)

Environment

Release: 15.1
Component: Datacom SQL Option

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