source ~db2inst1/db2cshrc
which db2
/home/users/db2inst1/sqllib/bin/db2
db2
db2=>
' prompt
db2=>connect to <your_database> user
<your_DB2_userid> using <your_DB2_password>
db2=>create table test (num
int)
db2=>insert into test
values(10)
db2=> select *
from test
db2 => create distinct
type mp3 as blob(100M)
db2 => create function mplay(mp3) returns integer external name
'MP3!play' language java parameter style db2general no sql
deterministic no external action not fenced
db2=> quit
create type Address_t AS (street VARCHAR(30), number CHAR(15))
MODE DB2SQL
create table student (name VARCHAR(20), add Address_t)
create type USAddress_t UNDER Address_t AS(zip CHAR(10),
state VARCHAR(20)) MODE DB2SQL
and they work. LISTOF and SETOF are not supported.