| SQL support / Database connections | |
Connecting to a database server is not just specifying a database name: The current user must be identified by the database server. Database users must be declared in the database server and must be explicitly identified by a login name and password at connection time. However, some database servers support external authentication methods, and do not require login/password information at connection time. See database vendor specific documentation for more details.
If the database server does not support external user authentication methods, you must use the CONNECT TO instruction with the USER/USING clause to identify the database user. Additional user authentication solutions are provided in Genero Business Develoment Language to simplify migration from IBM® Informix®databases, but should not be used in production for security reasons.