Ive created a type called person_type that has the attributes name and birthdate. When i make a table from that type i need to add (ref is .......user generated) at the end of the create statement. The thing is when i add the informaiton into the table what do i do? Ive written
Insert into person values('1','James','1982') but it does not like the 1. What is the ref for? And if it can be an integer is there anyway to auto increment it?
BTW Im using IBM DB2