What is the meaning of the error messages in PARAMETER MARKER lines on some SQL Error Call Text panels?.
Article ID: 107682
Bind Analyzer for DB2 for z/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem Analyzer for DB2 for z/OS
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?.
Release: 1BINMI00200-19.0-Bind Analyzer-for DB2 for z/OS-MIPS Component:
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.