HYip <hualinyip(at)earthlink(dot)net> writes:
> The code has no problem when both accountname, and account are not
> null. It gives me an errror code of -209 when the account is null.
> Anyone has any idea of fixing it.
(1) Try printing sqlca.sqlerrm.sqlerrmc, not sqlca.sqlcode, if you
don't want to look up error codes.
(2) You need an indicator variable if you want to fetch NULLs.
Else how will you know that the value is NULL?
regards, tom lane