syntego@gmail.com wrote:
> Will do. Thanks.
Thanks, I asked backstage and they tried to repro. Without success.
So we are looking forward to your PMR to get to the bottom of this.

Cheers
Serge

Result:

> sqlprepare 1 "call RG.NULLTEST(null)" -3
SQLPrepare: rc = 0 (SQL_SUCCESS)
> sqlexecute 1
SQLExecute: rc = 0 (SQL_SUCCESS)
> fetchall 1
FetchAll: Columns: 1
R1
PARM1 IS NULL
FetchAll: 1 rows fetched.
> sqlfreestmt 1 SQL_CLOSE
SQLFreeStmt: rc = 0 (SQL_SUCCESS)
>
> sqlprepare 1 "call RG.NULLTEST(NULL)" -3
SQLPrepare: rc = 0 (SQL_SUCCESS)
> sqlexecute 1
SQLExecute: rc = 0 (SQL_SUCCESS)
> fetchall 1
FetchAll: Columns: 1
R1
PARM1 IS NULL
FetchAll: 1 rows fetched.
> sqlfreestmt 1 SQL_CLOSE
SQLFreeStmt: rc = 0 (SQL_SUCCESS)
>
> sqlprepare 1 "call RG.NULLTEST('null')" -3
SQLPrepare: rc = 0 (SQL_SUCCESS)
> sqlexecute 1
SQLExecute: rc = 0 (SQL_SUCCESS)
> fetchall 1
FetchAll: Columns: 1
R1
PARM1 IS not NULL
FetchAll: 1 rows fetched.
> sqlfreestmt 1 SQL_CLOSE
SQLFreeStmt: rc = 0 (SQL_SUCCESS)
>
> sqlprepare 1 "call RG.NULLTEST('NULL')" -3
SQLPrepare: rc = 0 (SQL_SUCCESS)
> sqlexecute 1
SQLExecute: rc = 0 (SQL_SUCCESS)
> fetchall 1
FetchAll: Columns: 1
R1
PARM1 IS not NULL
FetchAll: 1 rows fetched.



--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/