User name and password (username/password)

In database connection parameters, the username and password parameters define the default database user, when the program uses the DATABASE instruction or the CONNECT TO instruction without the USER/USING clause.

The username and password FGLPROFILE entries are not encrypted. These parameters are provided to simplify migration and should not be used in production. You better use CONNECT TO with a USER / USING clause to avoid any security hole, setup OS user authentication or use the connection callback method. Example of database servers supporting OS user authentication: IBM^® Informix^®, Oracle and SQL Server.

Important: Do not write clear user passwords in your sources! The username and password parameters should be set from a variables.

For backward compatibility reasons, when using the IBM Informix driver, the username / password specification is ignored by the DATABASE instruction, only the CONNECT TO instruction takes external (or callback) login parameters into account.