!! Operator

eperich · #1 (**permalink**) 08-05-11, 08:12

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 ?

przytula_guy · #2 (**permalink**) 08-05-11, 08:33

I presume it should be || or CONCAT from concatenate
the display can vary according some environment settings...

eperich · #3 (**permalink**) 08-05-11, 09:27

That's what I thought but i typed the Pipes on the screen and one can see the difference between || and !!.

dbzTHEdinosaur · #4 (**permalink**) 08-06-11, 05:21

Quote:

Originally Posted by eperich

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 |.