Specifying a user name and password with CONNECT

In order to specify a user name and password, use the CONNECT instruction with the USER/USING clause:

MAIN
  DEFINE uname, upswd STRING
  CALL login_dialog() RETURNING uname, upswd 
  CONNECT TO "dbname" USER uname USING upswd
  ...
END MAIN

This is the recommended way to connect to a database server.