Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200

    Unanswered: Change a Data type

    Hai,
    I would like to know is there any method in db2 to alter a data type in db2,ie; from smallint to integer,varchar(256) to varchar(255) .

    I would also like to know whether db2 allows a dropping of a column,which is allowed from oracle 8i onwards.

    Regards,
    mickykt

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: Change a Data type

    which version of DB2 you are running on?

    dollar

    Originally posted by mickykt
    Hai,
    I would like to know is there any method in db2 to alter a data type in db2,ie; from smallint to integer,varchar(256) to varchar(255) .

    I would also like to know whether db2 allows a dropping of a column,which is allowed from oracle 8i onwards.

    Regards,
    mickykt

  3. #3
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200
    Hai,
    Thanks for your quick responce,
    I am running DB2 EE 7.2
    Regards,
    Micky

  4. #4
    Join Date
    Mar 2003
    Location
    chennai
    Posts
    1

    reply to your second Q

    pl. refer http://dbforums.com/t724607.html

    Originally posted by mickykt
    Hai,
    Thanks for your quick responce,
    I am running DB2 EE 7.2
    Regards,
    Micky

Posting Permissions

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