I would like to load the array data type data into table. I've created like '
CREATE TYPE sysudtlib.person AS(id_num VARCHAR (10),first_name VARCHAR (20), Salary VARCHAR (20)) NOT FINAL; CREATE TYPE ID_NBR AS sysudtlib.person ARRAY ;
CREATE MULTISET TABLE temp_work.EMP ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( MSAL CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC, COL003 SYSUDTLIB.ID_NBR) PRIMARY INDEX ( MSAL );
Now, How to write a insert statement into EMP table? Please throw some lights on this.