Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
General information [Table of Contents] Chapter 7 Using Sybase mode commands

Access Service User's Guide DirectConnect for AS/400

[-] Chapter 6 Issuing SQL statements
[-] SQL Transformation modes

SQL Transformation modes

Every database has its own dialect of SQL, including the AS/400. Adaptive Server uses a dialect of SQL called Transact-SQL (T-SQL). Both IBM and Adaptive Server SQL syntaxes support the ANSI SQL-1 standard. Thus, applications written for specific tables are relatively portable between Adaptive Server and the AS/400.

However, the access service does not support all Transact-SQL statements. If unsupported extensions exist in a SQL statement, the access service passes the SQL statement to the target, which may accept it or return a syntax error.

To make the various dialects look like common SQL, the access service supports two transformation modes, called Sybase and Passthrough. The section called "Description of Passthrough and Sybase transformation modes" describes these two modes in more detail.

Although the transformation mode primarily affects the way the access service treats incoming SQL statements, it also affects the following functional areas:

When you configure the access service with a specific transformation mode, that mode is effective for all client connections, unless you use a set statement to alter it for a specific connection.

Using the SQLTransformation property, you can specify how the access service processes SQL syntax. The SQLTransformation property is described on .

The access service never transforms the following SQL statements:

Instead, the access service processes these statements and takes any corresponding action needed.

Description of Passthrough and Sybase transformation modes
Passthrough mode
Sybase mode
Changing the Transformation mode
[-] Types of commands
Language commands
[+] Dynamic commands
[+] Cursor commands
[+] Error handling for cursor declare and open commands

General information [Table of Contents] Description of Passthrough and Sybase transformation modes