Element: database.session { }

Type

procedure

Description

A function to conduct a dialogue with a database interface. <command_block> is a block of language commands, any of which starting with * are sent to the database interface. Any errors detected during execution of the command block (language errors or database errors reported by the database interface) will abort the command block.

In database commands which require identifier values, language identifiers may be specified by preceding them with a : character, e.g.

string s = 'test'
*select * from my_table where name = :s

Such language variables may be array expressions. They must not contain any embedded white space. The only permitted identifier types are numeric, string, time and point. An attempt to output other variables will produce an error. Colons within quoted strings are treated literally and are not assumed to prefix a language variable. Numeric values will be expanded without trailing zeros, string variables will be enclosed within quotes, time variables will be output using the current date_mode format, point variables will be output in the form (x,y,z).

If the procedure is passed a numeric parameter whose value is non-zero, the command block is executed in "abort mode" meaning that any errors detected by the server aborts the block, i.e. skips the remaining commands in the block. The database is not closed by this abort operation.

This procedure does the same as a db command, which should be consulted for more details of database commands.

Whenever the database interface detects an error, the attribute database.dberr (which is initialized to zero at the beginning of the block) is set to a non-zero value.

The code of the procedure cannot be redefined.

Parameters

database.session () {
    <command_block>
}

The procedure may be called in one of two ways:

# Assume mydb is the database identifier.
mydb.session(mydb,1) { ... } 

or

mydb.session(1) { ... }

Examples

Open a database interface to an ODBC database. Within a database session select and fetch some data.

database mydb,-prop=odbc,-name='myodbc'
string names[]
mydb.session(1) {
    * select * from mytable
    * multifetch into names
}
if (mydb.dberr) !Error during fetch
mydb.close

See Also