Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
Can we use COBOL local arrays in DB2 queries in the application program?
SELECT * FROM TABLE
WHERE FIELD = :WS-EMPLOYEE (WS-INDEX)
The above query is giving me errors....
Can't we not use arrays inside embedded SQL?
This straight from the Application Programming & SQL Guide
"You cannot define host variables, other than indicator variables, as arrays. You can specify OCCURS only when defining an indicator structure. You cannot specify OCCURS for any other type of host variable.".