Database connections Explains how to manage database connections in a program. Understanding database connections This is an introduction to database connections. Opening a database connection A database connection identifies the SQL database server and the database entity the program connects to, in order to execute SQL statements. Database client environment To connect to a database server, Genero BDL programs use vendor's database client software. Connection parameters This section describes the different parameters which need to be specified in order to connect to a database. Connection parameters in database specification Connection parameters can be provided in the database specification string passed to the DATABASE and CONNECT TO instructions. Direct database specification method Genero BDL applies direct database source specification when no FGLPROFILE entry corresponds to the database name used in programs. Indirect database specification method Genero BDL allows to define database connection parameters in FGLPROFILE, that can be referenced by a single identifier in programs. IBM Informix emulation parameters in FGLPROFILE Emulation of Informix® specific SQL features can be controlled with FGLPROFILE entries. Database type specific parameters in FGLPROFILE Specific connection parameters can be configured with FGLPROFILE entries. SQL connection identifier Database client programs can be identified by name with some database server types. Database user authentication Different database user authentication methods exist. Unique session mode connection instructions Opening and closing a database for a unique session. Multi-session mode connection instructions Opening and closing a database for a unique session. Miscellaneous SQL statements These are particular SQL statements supported in the static SQL syntax.