Valid Database Engine Settings

Reference:

Engine Settings for a Server Profile or Stored Procedure

Engine Settings for API Applications

This section lists the valid database engine settings that you can:

Top of page

Reference: Engine Settings for a Server Profile or Stored Procedure

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.

Top of page

Reference: Engine Settings for API Applications

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