Data loading using Array data type

General
New Member

Data loading using Array data type

Hi All, 

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 [1];

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.

Regards,

Ramana