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" +
")";
"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
