SQLSetConnect Command

SQLSetConnect

Obsolete

Refer to the SQLSetConnect method in the cSQLHandleManager class.

SQLSetConnect sDriver sConnectString

The SQLSetConnect command allows the programmer to set up a default driver and connection for embedded SQL commands that follow. It is expected that using more than one driver in an environment, although possible, will not be very common.

The second argument is a connect string that identifies the connection to use in embedded SQL commands that follow. If you are always using the DB2 on your company server, you could set this up once by:

SQLSetConnect "DB2_DRV" "DSN=CompanyServer;UID=John;PWD=Secret"