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