Library: Interfaces, Database access (OMDB) Import: omdb.xmd

Declaration

  define external function db.execute-in
         value db.database database
     sql value stream     statement

Argument definitions

database

is a db.database object obtained by opening a connection to a database using one of the dbOpen functions.

statement

is the SQL statement that you want to execute on the database.

Use db.execute-in to execute a single SQL statement on the specified database.

Requirements

The db.database object database must be:

• open (else external exception OMDB101)
• in scope (else external exception OMDB103)

The stream variable statement must not be empty (else external exception OMDB105).

Usage Notes

The SQL statement may modify the structure of the database or manipulate the data in the tables. It may be any non-select type of SQL statement.

Example:

This function makes use of the db.database OMX variable used to create the connection to the database. For example:

  import "omdb.xmd" prefixed by db.
  process
     local db.database my-database
           initial {db.open-odbc "dbDemo"}

     db.execute-in my-database
        sql ("insert into Course (cid, CourseName)"
             || " values ('456', 'Four-on-the-Floor Gearshifting')")

Related Syntax    db.query    db.database

Related Concepts    Using the OMDB library

Other Library Functions    db.advance-recordset    db.close    db.commit    db.compile-statement    db.database    db.delete    db.discard    db.execute    db.execute-in    db.field    db.insert    db.move-record    db.omdb-version    db.omdb-version-oci8    db.omdb-version-oci8i    db.omdb-version-odbc    db.open-oci8    db.open-oci8i    db.open-odbc    db.open-procedure    db.open-table    db.prepare    db.procedure    db.query    db.reader    db.record-exists    db.rollback    db.set-transaction-type    db.statement    db.streaming-execute    db.table    db.update    db.writer

[ INDEX ] [ CONCEPTS ] [ TASKS ] [ SYNTAX ] [ LIBRARIES ] [ LEGACYLIBRARIES ] [ ERRORS ]