Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007
    Posts
    64

    Thumbs up Unanswered: How to generate Columns default values as GENERATE_UNIQUE

    Hi ,

    I have a create table query as below
    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.......

  2. #2
    Join Date
    Jul 2009
    Posts
    150
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •