Why are the column names missing on the Detector SQL Error Call Text display

Products

• Detector for DB2 for z/OS

Issue/Introduction

Why are the column names missing on the Detector for Db2 for z/OS (PDT) SQL Error Call Text display?

Resolution

The names in question were defined both as columns in the CREATE TABLE statement and as SQL variables in
the CREATE PROCEDURE statement. Db2 views them as "SQL variables" (host variables) in the SQL text.