CONNX Data Integration Suite 14.8.0 | CONNX Embedded SQL for Adabas | ACEAPI | ACEAPI SQL Functions | SAGQCONN
 
SAGQCONN
Description
The SAGQCONN function establishes a connection with an SQL Server.
Example
sagqconn (
int anchor,
SQL_CTR_BLOCK * sql_cb_ptr,
int statement_type,
char * server_ptr,
char * session_ptr,
char * user_ptr,
char * password_ptr,
char * charset_ptr
);
statement_type
CONNECT_USER_STMT (1)
The user-defined connection will be identified by the name given in session_ptr.
OTHER_STMT (99) or NULL
The connection will be made using the server name supplied in server_ptr (default).
server_ptr
Server name
Default server if NULL.
session_ptr
Session name
User-defined connection specifier used to set different connections. If not specified, the server name will be used as the connection name.
user_ptr
User name
Default user if NULL.
password_ptr
Password
No password if NULL.
charset_ptr
Character set
Default character set if NULL.
NONULLTERMINATE
All input and output strings will be processed without null termination considerations.
Recommended for all non C/C++ applications.
For information about anchor (required by each SAGQ* SQL function), see the ACEAPI SQL Functions page.