Fields
Fields can be defined for stored procedures. These are fields that are returned by any SELECT statements in the stored procedures.
Currently, fields are only supported for MSSQL and DB2 databases.
To edit stored procedure fields:
- Select the Fields node in the navigation pane.
- Ensure that the stored procedure is locked, by selecting the lock button in the toolbar.
- To insert a field: right-click in the details pane and select Insert.
- To delete a field: right-click the field name and choose Delete.
- Field properties are set using the object inspector. You can also set properties using the bulk mode screen by right-clicking in the details pane and choosing Bulk Mode. The bulk mode screen lets you view and edit fields in a free-format text window. See Bulk Mode for more information.
You can set the following properties on the Fields screen:
|
Property: |
Description: |
Value: |
|
Name |
The name of the field. The name must match the name of the result set column. | <Text> |
|
Type |
Field type. | <Alpha | Boolean | Financial | Integer | Numeric | Signed | String> |
|
Length |
Maximum number of characters for the field, including any decimal positions. This setting doesn't apply to String, Integer, or Boolean types. |
<Integer> |
|
Decimals |
The number of decimal places for the field, which is included in the Length value. This setting doesn't apply to Alpha, String, Integer, or Boolean types. |
<Integer>
|
| Array |
Array dimensions. Up to 6 dimensions can be specified, separated by commas. |
<[Integer], [Integer], ..]> |
| Inherits from |
The name of the dictionary item from which the field properties are inherited. |
<Dictionary item name> |
|
Comments
|
Description of the field. | <Text> |
| Encrypted |
Select True if the field values are stored encrypted in the runtime database. |
<True>/<False> |