<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

ODBCClose function for IBM Planning Analytics (TM1)

    ODBCClose closes an ODBC connection.

    In this video, ODBCClose will be used to show the impact of using ODBCClose before a query.

    Where can the ODBCClose function be used?

    TurboIntegrator

      Which TM1 Server version is the ODBCClose function available for?

      Version 11 and 12

        What is the syntax for ODBCClose?

        ODBCClose(DBSource)

        • ​​DBSource = Database source

        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