XCII. SESAM database functions

Introduction



Huomaa :

Runtime Configuration

sesam_oml string

sesam_configfile string



sesam_messagecatalog string

Configuration notes

Taulu 1 .

Name of BS2000 PLAM library containing the loadable SESAM driver modules. Required for using SESAM functions.



Name of SESAM application configuration file. Required for using SESAM functions.

It will usually contain a configuration like (see SESAM reference manual):

Name of SESAM message catalog file. In most cases, this directive is not neccessary. Only if the SESAM message file is not installed in the system's BS2000 message file table, it can be set with this directive.







Runtime considerations

Cursor Types

Taulu 2 .



Porting note

Security concerns

Migration from other SQL databases

  • instead of "... VALUES(0, ...)" to take advantage of SESAM-implied auto-increment.



Notes on the use of various SQL types

Taulu 3 .

When retrieving a complete row, the result is returned as an array. Empty fields are not filled in, so you will have to check for the existence of the individual fields yourself (use isset() or empty() to test for empty fields). That allows more user control over the appearance of empty fields (than in the case of an empty string as the representation of an empty field).

Support of SESAM's "multiple fields" feature

Esimerkki 1 .




and can be filled in using:

Esimerkki 2 .




Note that (like in this case) leading empty sub-fields are ignored, and the filled-in values are collapsed, so that in the above example the result will appear as multi(1..2) instead of multi(2..3).

See Also

Sisällys
sesam_affected_rows -- Get number of rows affected by an immediate query
sesam_commit -- Commit pending updates to the SESAM database
sesam_connect -- Open SESAM database connection
sesam_diagnostic -- Return status information for last SESAM call
sesam_disconnect -- Detach from SESAM connection
sesam_errormsg -- Returns error message of last SESAM call
sesam_execimm -- Execute an "immediate" SQL-statement
sesam_fetch_array -- Fetch one row as an associative array
sesam_fetch_result -- Return all or part of a query result
sesam_fetch_row -- Fetch one row as an array
sesam_field_array -- Return meta information about individual columns in a result
sesam_field_name -- Return one column name of the result set
sesam_free_result -- Releases resources for the query
sesam_num_fields -- Return the number of fields/columns in a result set
sesam_query -- Perform a SESAM SQL query and prepare the result
sesam_rollback -- Discard any pending updates to the SESAM database
sesam_seek_row -- Set scrollable cursor mode for subsequent fetches
sesam_settransaction -- Set SESAM transaction parameters