Hello,

The following SQL Statement returns NULL from the sql prompt
and returns 0 inside the Stored Procedure when the WHERE
condition is not met. Is it an expected behaviour ?

SELECT FIRST 1 PD.product_id
FROM purchase_det PD
WHERE ( PD.company_id = :dCID ) AND ( PD.isbn = :sString )
INTO :liPrID;

Thank you.

Sudheer P