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

book

Article ID: 33192

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

Issue/Introduction

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

 

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

Environment

Release: DATABB00200-14-Datacom/AD
Component: