SELECT COUNT(*) INTO :WS-COUNT
FROM TABLEA
WHERE ACC_N = :WS-ACC-N
FROM TABLEA
WHERE ACC_N = :WS-ACC-N
if WS-ACC-N not found in TABLEA
what will be the SQLCODE of the query 0 or 100??
If SQLCODE 0 can we safely assume this query will never give SQLCODE 100??
I think SQLCODE should be 0 and yes this query will never give SQLCODE 100 .Just wanted it to get confirmed.