When the access service receives a SQL command that has embedded data values, the SQL transformation mode in effect determines whether or not any transformation is applied to these values:
If the access service is in passthrough mode, it does not perform transformation.
If the DB2 access service is in sybase mode, it performs the following transformation:
Removes the currency symbol from money constants
Transforms quoted strings to quoting conventions specific to the target DBMS
For more information about SQL transformation modes, see “SQL transformation modes”.
Datatype constants are transformed only as shown in
the preceding paragraphs. When passing datatype constants, the client
must ensure that the constants are in the proper format required
by the target DBMS.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
