You are writing a program that retrieves data from a remote database using an SQL query. However the query returns no data. How would you detect this condition, and what value would the SQLCODE variable have in this case?

Question $13$ options:

Check the value of the SQLSTATE variable, which should be $\text{'}00000\text{'}$ in case of success. The SQLCODE variable would have a value of $0$ in this case.

Check the value of the SQLSTATE variable, which should be $\text{'}100\text{'}$ in case of success. The SQLCODE variable would have a value of $100$ in this case.

Check the value of the SQLCODE variable, which should have a value of $100$ in case the query returns no data.

None of the above.