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

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

Issue: 

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 

 

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 "Database and System Administration Guide" manual - "Modifying Definitions in Datadictionary" chapter - "Making Existing Tables SQL Accessible" section)
  • if SQL-ACCESS is already set to Y but SQL-INTENT is an asterisk, catalog the related database