Connect Using a JNDI DataSource Object

You can connect to a JNDI DataSource object using the CONNECT embedded SQL statement, much the same as for ODBC connections:
EXEC SQL 
  CONNECT TO DataSourceObject [USER userID.password]
END EXEC

If you have not specified a user ID and password within the DataSource object for a database connection that requires them, you can specify them as part of the CONNECT statement as indicated.