Results 1 to 2 of 2

Thread: db2 sql

  1. #1
    Join Date
    Jan 2003
    Location
    banglore
    Posts
    7

    Unanswered: db2 sql

    Hello,
    Can anyone suggest me how to set a NOT NULL for an existing null field in DB2

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: db2 sql

    You can use a check constraint ...

    Eg

    db2 alter table t add constraint c1 check (I is not null)

    HTH

    Cheers

    Sathyaram

    Originally posted by kishorep
    Hello,
    Can anyone suggest me how to set a NOT NULL for an existing null field in DB2

Posting Permissions

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