Reference: |
This section lists the valid database engine settings that you can:
The following table lists valid database engine settings. If you are using a Hub or Full-Function Server, you may include one of the settings in a stored procedure.
SQLDBC |
Teradata |
SQLDS or DB2 |
DB2, DB2/6000, DB2/2 (for MVS, UNIX, and Windows NT) |
SQLINF |
Informix |
SQLING |
Ingres |
SQLIPX |
Unisys DMS/RDMS 1100/2200 |
SQLMAC |
Microsoft Access |
SQLMSS |
Microsoft SQL Server |
SQLNUC |
Nucleus |
SQLODBC |
ODBC (Generic ODBC when DBMS is not supported) |
SQLORA |
Oracle |
SQLPRO |
Progress |
SQLRDB |
Rdb |
SQLRED |
Red Brick |
SQLSYB |
Sybase |
SQLUV |
Universe |
EDA or SQLEDA |
The SQL command or environment command is processed by the server, not by SQL Passthru). Note: This setting is not valid for CREATE SYNONYM. |
OFF |
Terminates SQL Passthru mode if previously activated in a stored procedure. |
The following table lists the valid database engine settings for use in API applications.
0 |
NOENGINE |
1 |
DB2 |
2 |
ORACLE |
3 |
TERADATA |
4 |
SQL/DS |
6 |
Microsoft SQL Server |
8 |
INGRES |
9 |
SYBASE |
10 |
RDB |
11 |
INFORMIX |
13 |
Internal |
15 |
SQL-400 |
16 |
NONSTOP-SQL |
17 |
ALLBASE |
18 |
PROGRESS |
19 |
RED BRICK |
20 |
UNIVERSE |
23 |
IDMS/SQL |
25 |
SQLODBC |
26 |
SQLMSQ |
27 |
SQLNUC |
28 |
SQLMAC |
iWay Software |