What is the meaning of the error messages in PARAMETER MARKER lines on some SQL Error Call Text panels?.

book

Article ID: 107682

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

In a few PARAMETER MARKER lines on some SQL Error Call Text panels there are error messages - SQLDA ERROR: SQLDATA OFFSET ZERO.
 
What is the meaning of these error messages in PARAMETER MARKER lines?.

Environment

Release: 1BINMI00200-19.0-Bind Analyzer-for DB2 for z/OS-MIPS
Component:

Resolution

When host variables cannot be displayed the following error messages were added by PTF SO00574.

SQLDA ERROR: SQLDATA OFFSET ZERO
SQLDA ERROR: SQLDATA OFFSET BEYOND MAX
SQLDA ERROR: SQLLEN LENGTH NEGATIVE

Messages are for information only and explain why the host variable could not be collected correctly. The SQL statement has an invalid underlying SQLDA host variable structure and values could not be displayed.

Without PTF SO00574 applied you will get an Abend S0C4 instead of the error messages as the host variable structure in SQLCA is corrupted.