To create a new table, click the Tables icon in the main TRAN-IDE window, then click New below the Table Objects list in the left pane. The Table Maintenance window opens.
When you have existing tables, double-click the table
name in the Table Objects list. TRAN-IDE loads the table in the
Table Maintenance window.
Enter the Table Name. The name can be a maximum of eight characters and contain only letters, numbers, and the underscore (_) character. TRAN-IDE uses this name to reference the table in a rule object.
WARNING! All table names must be in lowercase letters.
Enter an optional Description of the table’s content.
Add the columns that you need:
Click Add Column. The Add Column window appears.
Enter the Column Name, then select the Datatype from the drop-down list—raw, alpha, or numeric.
WARNING! You can access the Datatype only when you first build the table.
Repeat steps 7a and 7b for each column you need in the table. You now have columns, but no data. Now you need to add rows and the data that each row contains.
To specify that a column cannot have any duplicate entry, click Edit Column, select Key in the Column Information window, then click OK.
After you add columns, click Add Row to add a new row. The row you added is highlighted in the display pane. Add the row data:
In the Cell Value field, enter the data for the cell where the row and column intersect, then press Enter.
TRAN-IDE adds the data and also adds default data to the other columns in the row. If the column’s datatype is alpha or raw, the default data is double quotes (“”). If the column’s datatype is numeric, the default data is a zero (0).
Edit the default data for the new row.
Repeat step 5 until you build all of the necessary rows.
To change any table data:
To change column data, click Edit Column in the Table Maintenance window. You can change the column name and whether the column is a key, but you cannot change the datatype.
To change cell data, highlight the cell you want to change, enter the new value in the Cell Value field, and press Enter.
To delete a row, select the row in the display pane, then click Remove Row.
Click Save As to save the table for the first time or under a different name if you are editing an existing table. By default, TRAN-IDE saves tables in the multi-column format—Table Files (*TBL). To save an old tag/value or tokenized value table in its current format, select Tag Value Table (*.TBL) in the Save As field.
See “Table Maintenance window fields” for additional details about each
field.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
