Chapter 6: Issuing SQL Statements

Transformations in sybase mode

The sybase mode makes the following transformations to SQL syntax:

Provides standard transformations of parameter marker names beginning with the “@” character
Removes T-SQL comments in the form /*
Converts T-SQL comparison operators (such as ! and =) into the target DBMS equivalent
Converts single and double quotation marks used as string delimiters to the appropriate delimiter for the target DBMS
Strips dollar signs from money constants

Unsupported syntax passes unchanged to the DBMS for processing.

The sybase mode does not convert nonquoted tokens to uppercase.