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
  • Community
    • Welcome
    • Product Q&A
    • Common Interests
    • Product Updates & Roadmap
  • Documentation
    • User Guide
    • Language Reference
    • Modeling Guide
    • Function Reference
    • WebUI
    • PRO Platform
    • Cloud Platform
    • Library Repository
  • How To
    • Getting Started
    • AIMMS Developer
    • Application UI
    • Deployment
    • Software Evolution
    • Examples
    • Recently Added
  • Downloads
  • Release Notes
    • AIMMS Development RELEASE NOTES
    • AIMMS Deployment RELEASE NOTES
    • AIMMS SC App Store RELEASE NOTES
  • 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: Mar 13, 2023

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 - 2023 AIMMS B.V.