Difference between revisions of "CREATE CURSOR"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
SQL Applications | SQL Applications | ||
| Line 27: | Line 24: | ||
[NOCPTRANS] | [NOCPTRANS] | ||
| − | [, | + | [, ...]] |
| [FROM ARRAY <array>] | | [FROM ARRAY <array>] | ||
| Line 81: | Line 78: | ||
<code lang="recital"> | <code lang="recital"> | ||
CREATE CURSOR tempstaff | CREATE CURSOR tempstaff | ||
| − | (staff_no CHAR(6) NOT NULL UNIQUE, | + | (staff_no CHAR(6) NOT NULL UNIQUE, |
| − | lastname CHAR(15) NOT NULL, | + | lastname CHAR(15) NOT NULL, |
| − | firstname CHAR(10), | + | firstname CHAR(10), |
| − | hiredate DATE, | + | hiredate DATE, |
| − | location CHAR(15), | + | location CHAR(15), |
| − | supervisor CHAR(6), | + | supervisor CHAR(6), |
| − | salary DECIMAL(6,0), | + | salary DECIMAL(6,0), |
| − | picture VARBINARY, | + | picture VARBINARY, |
| − | history LONG VARCHAR, | + | history LONG VARCHAR, |
| − | commission DECIMAL(4,1)); | + | commission DECIMAL(4,1)); |
</code> | </code> | ||
Revision as of 09:48, 28 April 2009
Class
SQL Applications
Purpose
Creates a database with the specified name
Syntax
CREATE CURSOR <cursor>
[(<column> <datatype> [(<precision> [,<scale>])]
[NULL | NOT NULL]
[CHECK <expression> [ERROR <text>]]
[AUTOINC [NEXTVALUE <NextValue> [STEP <StepValue>]]]
[DEFAULT <expression>]
[UNIQUE [COLLATE <cCollateSequence>]]
[NOCPTRANS]
[, ...]]
| [FROM ARRAY <array>]
See Also
ALTER INDEX, ALTER TABLE, CREATE TABLE, CREATE INDEX, CREATE VIEW, DROP DATABASE, DROP INDEX, DROP TABLE, USE
Description
The CREATE CURSOR command creates a temporary table with the specified name. Columns to be included in the table can be specified individually or details loaded from an existing array.
| Keywords | Description |
|---|---|
| cursor | The name of the temporary table to be created. |
| column | The name of the column to be created. |
| datatype | The column's data type. |
| precision | The width of the column where not fixed. |
| scale | The column's decimal places where required. |
| NOT NULL | Specifies whether this column can have NULL values. NULL allows NULL values, NOT NULL prohibits NULL values. |
| CHECK <expression> | Validation rule for the column. The <expression> must evaluate to true (.T.), valid value or false (.F.), invalid value. |
| ERROR <text> | An optional error message, <text>, to be displayed when the CHECK <expression> validation fails. |
| AUTOINC | Enables auto incrementing for the column |
| NEXTVALUE <NextValue> | The specified <NextValue> is the numeric start value for the auto incrementing. |
| STEP <StepValue> | The specified <StepValue> determines the increment value. By default values are incremented by 1. |
| DEFAULT <expression> | The specified <expression> is used as the default value for the column. |
| UNIQUE | Creates a unique index on this column. |
| COLLATE <cCollateSequence> | The specified <cCollateSequence> is used as the index collating sequence. |
| NOCPTRANS | Disables code page translation for character and memo columns. |
| FROM ARRAY <array> | The table structure is taken from an existing array, whose name is specified in <array>. The array contents must be the column name, type, precision and scale for each column in the temporary table. |
Example
CREATE CURSOR tempstaff (staff_no CHAR(6) NOT NULL UNIQUE, lastname CHAR(15) NOT NULL, firstname CHAR(10), hiredate DATE, location CHAR(15), supervisor CHAR(6), salary DECIMAL(6,0), picture VARBINARY, history LONG VARCHAR, commission DECIMAL(4,1));
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
