ODBCClose function for IBM Planning Analytics (TM1)


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

Leave a Reply

Your email address will not be published. Required fields are marked *