All Forums General
Ramana71 1 post Joined 03/15
23 Mar 2015
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

You must sign in to leave a comment.