syntego@gmail.com wrote:
> Brian,
>
> The server and the client are both at V8 FP 12. I'm running the Admin
> Client on my workstation.
>
> Here's the results of casting the null to a varchar(26) using RapidSQL
> 7.4 over ODBC:
>
> call rg.nulltest(cast(null as varchar(26)))
> R1
> PARM1 IS NOT NULL
>
> call rg.nulltest(cast(NULL as varchar(26)))
>
> R1
> PARM1 IS NOT NULL
>
> The error seems to be ODBC related. Whenever we have used the DB2
> Command Line Processor, the results return correctly.
>
> FYI - I've submitted the case to our DBA team who will be creating the
> PMR and will update the thread with the number when it gets created.
>
> Thanks,
>
> Bob

Our error was also ODBC releated but only when the server was V8 and
the client V7. The CLP returned the error, ODBC crashed the server (not
the connection, the server had to be brought back up). Ironic as it may
be, one case was with a CHAR(26) (being passed to a VARCHAR(25), which
worked but crashed when accessing the final character via SUBSTR).

Inbteresting that both are now NOT NULL. That is highly odd.

B.