You can use the \set command to set Aster Database parameters from ACT. The syntax to use the \set command is:
\set [ <name> [ <value> [ ... ] ] ]
These are the database parameters you can set from ACT:
| Parameter | Description |
|---|---|
| auto-commit [1|0] | When set to 1 (on, the default), each SQL command is automatically committed upon successful completion. When set to 0 (off), you may manually commit your changes after each transaction or series of transactions by issuing the COMMIT command, or undo changes by issuing ROLLBACK. If you do not issue the COMMIT command, all transactions that occurred since the last COMMIT will rollback automatically. |
| fetch-count [int] | To limit the number of rows returned at a time. ACT uses a fetch count by default (i.e. even when fetch-count is not set explicitly.) The fetch-count (number of rows per fetch) should always be set to greater than 0, The default value is 1024 (1024 rows). |
| fetch-limit [int] | To set the maximum number of rows returned per query. A value less than 0 implies fetch all rows. A value greater than 0 implies fetch-limit rows in total. The default value is -1 (all rows). |
| use-server-cursors [1|0] | When set to 1, sets the server to use cursors (useful when the result set is very large). When set to 0 (the default, off), sets the server to not use cursors. |
| on-error-stop [1|0] | By default, this feature is disabled or set to off = 0.
When set to 1 (or “on”) ACT will stop and exit if it meets an error during SQL query processing.
The following are ACT exit messages:
|