Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    33

    Question Unanswered: different data type

    Hi There,

    I wonder if the following pair will be considered as same data type or not:

    char(15) - char(18)
    char(15) - varchar(18)

    When I link the two columns char(15) to char(18), would DB2 do casting or not?

    Thanks

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    The length is completely irrelevant for type propagation considerations. Thus, you can't overload UDFs with CHAR(15) and CHAR(18), for example.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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