Stored procedure stage with DB2/ZOS 11 array functionality

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
clarcombe
Premium Member
Premium Member
Posts: 515
Joined: Wed Jun 08, 2005 9:54 am
Location: Europe

Stored procedure stage with DB2/ZOS 11 array functionality

Post by clarcombe »

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 ?
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
Post Reply