SQL basics This section contains fundamental information to know about SQL programming with Genero BDL. Database and application localesChoose the right locale for your database and application programs.SQL execution diagnosticsIf an SQL statement execution fails, error description can be found in the SQLCA.SQLCODE, SQLSTATE, STATUS and SQLERRMESSAGE predefined registers.The SQLCA diagnostic recordThe SQLCA variable is a predefined record containing SQL statement execution information.SQL error identificationIdentify SQL exceptions in your programs with SQLCA.SQLCODE.Cursors and connectionsHow to use database cursors across connections?Concurrent data accessUnderstanding concurrent data access and data consistency.Database transactionsDatabase transactions define a set of SQL instructions to be executed as a whole, or rolled back as a whole.Using SQL interruptionInterrupt long running SQL queries, or interrupt queries waiting for locked data.Implicit database connectionAn implicit database connection is made with the DATABASE instruction used before MAIN; use SCHEMA to avoid the implicit connection.Debugging SQL statementsSet the FGLSQLDEBUG environment variable to print SQL debug info.The database utility libraryThe fgldbutl.4gl library provides several database-related utility functions.