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