When checking the return status of 4GL application statements such as PROMPT, why is it advisable to use STATUS instead of SQLCA.SQLCODE?

When checking the return status of 4GL application statements such as PROMPT, why is it advisable to use STATUS instead of SQLCA.SQLCODE?

A. The STATUS variable is always set by INT_FLAG.

B. The SQLCA.SQLCODE variable may have been incorrectly defined by the developer.

C. The STATUS variable is not set by 4GL application statements, only by SQL statements.

D. The STATUS variable is the only way to check the return status of 4GL application statements.

View Answer

Answer: D