soup_or_power_at_yahoo.com wrote:
> sybrandb_at_yahoo.com wrote:
>
>>1 No. The second statement won't parse because you forgot a quote to
>>end b1.
>>If you add the quote, they won't be the same.
>>2 The second question means you are treating this forum as a
>>replacement for reading manuals.
>>
>
> I don't have ORAKILL manuals. I have this link that has the ASCII
> table. If you care to explain how using || will be better or worse
> compared to using DECODE without ||, I'd be eternally indebted.
>
> http://www.techonthenet.com/ascii/chart.php
>
You got a serious misconnect here DECODE has absolutely nothing to do
with || or the ASCII table.
Maybe if you defined your understanding of CHR(), DECODE() and || the
group can tell you where you took the wrong turn and put you back on track.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Received on Wed Aug 03 2005 - 09:49:59 CDT
