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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.