SQL SELECT DQ093E INVALID DATA SQLCODE -161 DBVVRPR

Products

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

Issue/Introduction

Running a Datacom SQL SELECT against a table defined with user compression DBVVRPR fails with error -161:

In Dataquery:

DQ093E - column_name UNUMERIC(10,0) INVALID DATA: 000000000000000000F0
CMD=QEXEC,SQLRC=0161-,ERRPGM=err161  ,ERRD2=0000000002

In DBSQLPR: 

SQLCODE = -161, SQLSTATE=22S03
MESSAGE = column_name UNUMERIC(10,0) INVALID DATA: 000000000000000000F0

The table is defined with:

USER COMPRESSION - YES(DBVVRPR )

Environment

Release: 15.1

Cause

DBVVRPR is used by Datacom VSAM Transparency for tables with variable length records converted from VSAM.

Resolution

Tables defined with compression exit DBVVRPR cannot be used by SQL. See the VSAM Transparency manual in section SQL Restrictions:

Datacom/DB tables that are defined as variable-length tables (those with user compression exit DBVVRPR) are not accessible using SQL