Stored procedure stage with DB2/ZOS 11 array functionality
Posted: Wed Dec 06, 2017 7:00 am
I am trying to test using the DB2 v11 array functionality to put values into a table which have been read in array format from DB2
e.g.
PERSON_ID|PERSON_ID_2
COL1,COL2|A1,A2
Would write two records to a table
PERSON_ID|PERSON_ID_2
COL1 | A1
COL2 | A2
I have not managed to get this to work, whereas other stored procedure calls to the same DB2 server
Has anyone managed to get this functionality to work ?
e.g.
PERSON_ID|PERSON_ID_2
COL1,COL2|A1,A2
Would write two records to a table
PERSON_ID|PERSON_ID_2
COL1 | A1
COL2 | A2
I have not managed to get this to work, whereas other stored procedure calls to the same DB2 server
Has anyone managed to get this functionality to work ?