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