ODBCOutput function for IBM Planning Analytics (TM1)
Where can the ODBCOutput function be used?
Which TM1 Server version is the ODBCOutput function available for?
What is the syntax for ODBCOutput?
- DBSource = Database source
- SQLquery = SQL query to update tables in ODBC database
Relevant Functions
- ODBCClose = Closes an ODBC connection
- ODBCOpen = Opens a connection between TM1 to an ODBC database
- ODBCOpenEx = Opens an ODBC data source for output specifying that the connection should be opened as a Unicode connection
- ODBCOutput = Executes a SQL query from TM1 to an ODBC database. Used in conjunction with ODBCOpen
- SetODBCUnicodeInterface = Sets whether the ODBC interface should use the Unicode wide functions or the regular single-byte character functions