What will be the SQLCODE for below select query?

[Nitin Jain]

Hi,

I was asked this question in an Interview:

What will be the SQLCODE for below select query

Code: Select all

SELECT COUNT(*) FROM EMP WHERE EMPNO=1234

and suppose row with employee number 1234 is not present in table.

Thanks,

[Anuj Dhawan]

Hello,

If you run the query in COBOL as an embedded SQL -- you'll get SQLCODE as 0, when row EMPNO=1234 is not present in the table. OTOH, if you remove COUNT then you'll get the SQLCODE as +100.

Hope this helps.

[Nitin Jain]

Thank you Anuj!

[Anuj Dhawan]

You're welcome and Good Luck!