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

Products

• Detector for DB2 for z/OS

Issue/Introduction

In a few PARAMETER MARKER lines on some Detector for Db2 for z/OS (PDT) 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?

Resolution

When PDT 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.