ODBC Database Access Library

Aus ExpeccoWiki

The ODBC Library provides blocks to access a relational database via the ODBC connect interface. As almost every relational database does provide an ODBC interface, there is virtually no relational database which cannot be accessed via expecco.

Database Connection

• ODBC [ Connect ]
  Connects to a database.
• ODBC [ Disconnect ]
  releases a databse connection.
• ODBC [ GetODBCInfo ]
  Retrieve information about the underlying ODBC implementation.

SQL Queries

• ODBC [ Execute-StreamOut]
  Execute. Send result rows streamwise to the output
• ODBC [ Execute-BlockOut]
  Execute. Send result en-bloque to the output

• ODBC [ Execute-with PinParameters - StreamOut]
  Execute with parameters from pins. Send result rows streamwise to the output
• ODBC [ Execute-with PinParameters - BlockOut]
  Execute with parameters from pins. Send result rows en-bloque to the output

• ODBC [ Execute-with Parameter Vector - StreamOut]
  Execute with parameters from a vector. Send result rows streamwise to the output
• ODBC [ Execute-with Parameter Vector - BlockOut]
  Execute with parameters from a vector. Send result rows en-bloque to the output

• ODBC [ Execute-with MultiRow Parameter Vector - StreamOut]
  Execute with parameters from a vector. Send result rows streamwise to the output
• ODBC [ Execute-with MultiRow Parameter Vector - BlockOut]
  Execute with parameters from a vector. Send result rows en-bloque to the output

Example

See ODBC_Connection.

Back to Online Documentation