ODBCOPENEx

This function opens an ODBC data source for output specifying that the connection should be opened as a Unicode connection.

This is a TM1® TurboIntegrator function, valid only in TurboIntegrator processes.

Format is: ODBCOPENEx (dataset name, dataset client name, client password, (use-Unicode-interface flag) )

Syntax

ODBCOpenEx(Source, ClientName, Password, UseUnicodeODBC);

Argument	Description
Source	An ODBC data source name.
ClientName	A valid client on the data source.
Password	A password for the ClientName.
UseUnicodeODBC	Defines the type of Unicode connection to use.

Example

ODBCOpenEx( TestTable, sa, , 1 );

chinese= ;
chinese = CHARW( 37123 );
fieldval = chinese | SomeNewText;
sql= Update TestTable set ForeName = N | fieldval |  WHERE CustomerId= 1
ODBCOUTPUT( Unicode, sql );

The result SQL statement looks like:

Update TestTable set ForeName = N?SomeNewText WHERE
CustomerId = 1