Microsoft SQL Server translator (sqlserver)

Also see common JDBC translators information.

The Microsoft SQL Server translator, known by the type name sqlserver, is for use with SQL Server 2000 or later. A SQL Server JDBC driver version 2.0 or later (or a compatible driver such as, JTDS 1.2 or later) should be used. The SQL Server DatabaseVersion property can be set to 2000, 2005, 2008, or 2012, but otherwise expects a standard version number, for example, 10.0.

Sequence support

With Teiid 8.5+, sequence operations may be modeled as source functions.

With Teiid 10.0+, sequences may be imported automatically import properties. <<<<<<< HEAD

>>>>>>> 16f16ed8ccfcdc976c3327389836a5cc1d609397

Example: Sequence native query

CREATE FOREIGN FUNCTION seq_nextval () returns integer OPTIONS ("teiid_rel:native-query" 'NEXT VALUE FOR seq');

SQL Server specific execution properties:

JtdsDriver: Specifies that use of the open source JTDS driver. Defaults to false.

results matching ""

No results matching ""