Diagnostics
Product: Reporting Server
Release: 8205
Primary OS: Linux
Solution Date:
Symptom
(FOC1400) SQLCODE IS -330 (HEX: FFFFFEB6) XOPEN: 22021
(FOC1500) : [22021] [IBM][CLI Driver][DB2] SQL0330N A string cannot be used because it cannot be processed. Reason code="16". Code point=" ".
(FOC1500) : Host variable position="1". SQLSTATE=22021
(FOC1406) SQL OPEN CURSOR ERROR. : FTIISID
Problem
Joining a HOLD file to Db2 on z/OS results in the error message above from Db2.
Solution
One of the HOLD files has an incorrect block type variable. Also, the numeric fields in the HOLD file's Master File Description needed to specify an alpha (An) format.
Correcting the HOLD file's block definition and the synonym resolved the issue.