FUNCTION REFERENCE

  • Elementary Computational Operations
  • Algorithmic Capabilities
  • Model Handling
  • Data Management
    • Case Management
    • Data Change Monitor Functions
    • Database Functions
      • CloseDataSource
      • CommitTransaction
      • DirectSQL
      • LoadDatabaseStructure
      • RollbackTransaction
      • SaveDatabaseStructure
      • StartTransaction
      • TestDataSource
      • TestDatabaseTable
      • GetDataSourceProperty
      • SQLNumberOfColumns
      • TestDatabaseColumn
      • SQLNumberOfDrivers
      • SQLNumberOfTables
      • SQLNumberOfViews
      • SQLColumnData
      • SQLDriverName
      • SQLCreateConnectionString
      • SQLTableName
      • SQLViewName
    • Spreadsheet Functions
    • XML Functions
  • User Interface Related Functions
  • Development Support
  • System Interaction
  • Predefined Identifiers
  • Suffices
  • Deprecated
AIMMS Function Reference
AIMMS Logo
  • Function Reference »
  • Data Management »
  • Database Functions
  • Edit on Github

Database Functions

AIMMS supports the following database related functions:

  • CloseDataSource
  • CommitTransaction
  • DirectSQL
  • LoadDatabaseStructure
  • RollbackTransaction
  • SaveDatabaseStructure
  • StartTransaction
  • TestDataSource
  • TestDatabaseTable
  • GetDataSourceProperty
  • SQLNumberOfColumns
  • TestDatabaseColumn
  • SQLNumberOfDrivers
  • SQLNumberOfTables
  • SQLNumberOfViews
  • SQLColumnData
  • SQLDriverName
  • SQLCreateConnectionString
  • SQLTableName
  • SQLViewName
Last updated: May 03, 2025

Help & Feedback

Docs

Edit this page to fix an error or add an improvement in a pull request
Create an issue to suggest an improvement to this page

Product

Create a topic if there's something you don't like about this feature
Propose functionality by submitting a feature request

Support

Not what you where looking for? Search the docs

Remember we also have Community support

Still having trouble ? Reach out to us


Next Previous

AIMMS
AIMMS COMMUNITY
AIMMS DOCS
DISCLAIMER
PRIVACY STATEMENT
© 1989 - 2025 AIMMS B.V.