ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 33192

calendar_today

Updated On:

Products

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services Datacom/AD CA ecoMeter Server Component FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA On Demand Portal CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET 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: