How to generate Columns default values as GENERATE_UNIQUE

sushma007 · #1 (**permalink**) 10-09-09, 05:11

Hi ,

I have a create table query as below

Quote:

CREATE TABLE Address (rowguid VARGRAPHIC(36) DEFAULT GENERATE_UNIQUE NOT NULL)

My intention is to have a value generated by GENERATE_UNIQUE function as default .

When i try to execute the above query, too many errors are thrown .

Please suggest me the correct syntax .

Thanks in advance.......

DB2Plus · #2 (**permalink**) 10-09-09, 22:09

Quote:

Originally Posted by sushma007

Hi ,

I have a create table query as below

My intention is to have a value generated by GENERATE_UNIQUE function as default .

When i try to execute the above query, too many errors are thrown .

Please suggest me the correct syntax .

Thanks in advance.......

Syntax:
5.41 "DB2 V9.1 for z/OS SQL Reference" IBM Library Server

Internet Services

Web Development

Digital Marketing

Consumer Tech