ODBC Library/en

Aus expecco Wiki (Version 2.x)
Zur Navigation springen Zur Suche springen

Introduction[Bearbeiten]

The ODBC Library contains action blocks to access databases via the ODBC interface, which is a common database access layer providing a common API to different databases. Almost every relational database provides an ODBC driver and is thus accessable.

Make sure that ODBC has been installed and configured on your machine, when using ODBC actions (on most machines, this is already installed, and you have to define the mapping from logical database names to driver type, host, username etc. in a setup dialog).

Back to Online Documentation

Connecting / Disconnecting[Bearbeiten]

[ODBC] Connect[Bearbeiten]

Establishes a connection to a database. You have to provide the logical name of the database, and possibly a user/password combination. The logical name is typically specified in your operating systems ODBC configuration dialog. Upon success, a session handle is written to the output pin. This is needed to further talk to the database, and either stored in a variable, or passed along a pin-connection to one of the query actions below.

[ODBC] Disconnect[Bearbeiten]

Closes a database connection. Takes a connection handle as generated by "[ODBC] Connect" as input.

SQL Queries[Bearbeiten]

[ODBC] Execute-BlockOut[Bearbeiten]

Executes an SQL statement and provides the resulting rows as a single (possibly big) collection of individual rows. The statement is a string which must represent a valid SQL statement. The receiving action will be triggered once. For example, "select name,telno from myTable" will generate a collection consisting of 2-valued rows, each containing name and telno from the table.

[ODBC] Execute-StreamOut[Bearbeiten]

Similar to the above, but the resulting rows are sent individually to the output pin. Thus, for every result, one output table is generated, and the receiving action will be triggered once for each.



Copyright © 2014-2024 eXept Software AG