Page History
...
For a MS SQL SERVER connection, use charset as in the example below:
Some charset options are:
...
- For a DB2 connection, you cannot use charset. This is because the IBM DB2 Driver for JDBC and SQLJ has no information about the server-side CCSID that is used for output parameter values; the driver requests the stored procedure output data in UTF-8 Unicode.
- The prepareSQL attribute (defaults to 3 for SQL Server, 1 for Sybase):This parameter specifies the mechanism used for Prepared Statements.
Value Description 0 SQL is sent to the server each time without any preparation, literals are inserted in the SQL (slower) 1 Temporary stored procedures are created for each unique SQL statement and parameter combination (faster) 2 sp_executesql is used (fast) 3
...
sp_prepare and sp_cursorprepare are used in conjunction with sp_execute and sp_cursorexecute (faster, SQL Server only)
- The useCursors attribute (defaults to false):
...