Re: ARRAY

[Stanley Bradbury]

Hong Ji wrote:
Hello,
 
How to create a table with a colume is of type ARRAY?
The following SQL statement fails at "ARRAY." 
 
"create table APP.Rooms (" +
        "ID                         INTEGER NOT NULL PRIMARY KEY 
GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)," +
        "SYMBOL                  VARCHAR(30), " +
        "TYPE                       VARCHAR(30), " +
         "TICKET_IDS             ARRAY" +
        ")";
 
So how to define the TICKET_IDS field as array of integers in Derby?
 
Thanks.
 
Hong
 
 
To set this up in Derby you could list the array values in a child table 
the load the array programatically when reading the records.