SQLCA.SQLWARN Settings Immediately after DATABASE Executes (ESQL/C)

Immediately after DATABASE executes, you can identify characteristics of the specified database by examining warning flags in the sqlca structure.

• If the first field of sqlca.sqlwarn is blank, then no warnings were issued.
• The second sqlca.sqlwarn field is set to the letter W if the database that was opened supports transaction logging.
• The third field is set to W if database is an ANSI-compliant database.
• The fourth field is set to W.
• The fifth field is set to W if database converts all floating-point data to DECIMAL format. (System lacks FLOAT and SMALLFLOAT support.)
• The seventh field is set to W if database is the secondary server (that is, running in read-only mode) in a data-replication pair.
• The eighth field is set to W if database has DB_LOCALE set to a locale different from the DB_LOCALE setting on the client system.