I have a question regarding "Typed Tables" in DB2. Suppose we have following User Defined Structure Type and a table using this type.
CREATE TYPE db2admin.Person_t AS
REF USING VARCHAR(13) FOR BIT DATA
CREATE TABLE db2admin.Person OF db2admin.Person_t
(REF IS Oid USER GENERATED)
INSERT INTO db2admin.Person (Oid, Name, Age,Address)
VALUES(db2admin.Person_t('a'), 'Andrew', 20 ,'Indore');
select * from db2admin.Person
All these sqls work fine. Now my queston is Does i can do the same job through JDBC. I mean insert/update/select can be done using JDBC.
Problem being the table will be having four columns Oid,Name,Age and Address. The Oid is Ref type and really interested in how to handle it. I will be thankful if some one can explain with suitable eample.