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

Document ID : KB000107682
Last Modified Date : 24/07/2018
Show Technical Document Details
Issue:
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?.
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.