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