Writing an SQL Program › SQL Status Checking and Error Handling › Using GET DIAGNOSTICS

Using GET DIAGNOSTICS

The use of GET DIAGNOSTICS instead or in addition to checking SQLCA offers the following advantages:

• Better portability because of the SQL standards compliance
• Availability of more diagnostic information
• Independent of host language
• Built-in formatting of all diagnostic information

Note: For more information about GET DIAGNOSTICS, see the CA IDMS SQL Reference Guide.