Results 1 to 6 of 6

Thread: !! Operator

  1. #1
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    Unanswered: !! Operator

    Hi all

    I have to analyze a DB2 Application.
    In SQL
    case xy when 'X' then substr(x,2,3)!!' '
    when 'Y' then substr(y,2,3)!!' '
    else substr(z,2,9) end,

    there is a !! operator used.
    I cannot find it in the db2 docs.

    Has anyone an idea for what it is good for ?
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    I presume it should be || or CONCAT from concatenate
    the display can vary according some environment settings...
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400
    That's what I thought but i typed the Pipes on the screen and one can see the difference between || and !!.
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  4. #4
    Join Date
    Jun 2007
    Location
    germany
    Posts
    155
    Quote Originally Posted by eperich View Post
    That's what I thought but i typed the Pipes on the screen and one can see the difference between || and !!.
    good, you can see the trees, but you still can't see the forest.
    you need to understand that DB2 interprets things - based on site environmental variables, code page, etc ........)
    differently than you do.

    depending upon the complexity of your connects, it maybe that by the time db2 sees the sql, the ! has been converted to |.
    Dick Brenholtz, Ami in Deutschland

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    eperich - Join Date: Sep 2001

    I don't think I've seen any user who joined prior to 2002 (at least not on DB2 forum)

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    oops. taking my words back. Satya joined at the same time.

Posting Permissions

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