Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    86

    Unanswered: adding long varchar field to a table

    Hi All,
    I am working with db2v7.2 aix,
    I need to add lon varchar field with 10001 length, I get error and it seems I can not especify the length and db2 by default put 32700 lenght for field, is it true? please help

    Thanks

  2. #2
    Join Date
    May 2003
    Location
    Phoenix, US
    Posts
    39

    Re: adding long varchar field to a table

    Hi,
    long varchar doesn't accept any size for the column.
    Probably you can use varchar data type for 10001 size

    Thanks
    Sateesh

    Originally posted by David2002
    Hi All,
    I am working with db2v7.2 aix,
    I need to add lon varchar field with 10001 length, I get error and it seems I can not especify the length and db2 by default put 32700 lenght for field, is it true? please help

    Thanks

Posting Permissions

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