You can create a new personal table by copying an existing table that has your authorization ID and fewer than 99 columns. The new table contains all the same column names, types, and lengths. You can change or delete any part of the definitions or add new columns.
Action
To begin copying a personal table definition, follow these steps:
Display DIRECTORY OF TABLES (DQT10) panel.
Select a table to copy by positioning the cursor on its name. It must have fewer than 99 columns.
Press <PF5> DISPLAY.
View DISPLAY TABLE (DQT20) panel.
Press <PF5> COPY.
The CREATE TABLE (DQT30) panel appears containing the copied definition.
Panel
Following is an example of the CREATE TABLE (DQT30) panel as it appears when an existing table has been copied with <PF5> COPY.
=> Enter information for table columns and press appropriate PF key --------------------------------------------------------------------------DQT30 DATAQUERY: CREATE TABLE TABLE NAME: ________________________________ ------------------------------------------------------------------------------- COLUMN NAME | TYPE | LENGTH ------------------------------------------------------------------------------- CUST-ID | CHARACTER | 5 IND-CD | CHARACTER | 1 CUST-NO | CHARACTER | 4 NAME | CHARACTER | 30 ADDR-1 | CHARACTER | 30 ADDR-2 | CHARACTER | 30 CITY | CHARACTER | 15 STATE | CHARACTER | 2 ZIP | CHARACTER | 9 CRED-IND | CHARACTER | 1 PHONE | CHARACTER | 10 AREA-CD | CHARACTER | 3 PH-EXCH | CHARACTER | 3 PH-NO | CHARACTER | 4 ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> ADD TABLE <PF4> NOT USED <PF5> INSERT COLUMN <PF6> DELETE COLUMN <PF7> BACKWARD <PF8> FORWARD
Action
You can change any part of the definition copy.
Use the Tab key to move the cursor from one field on the panel to another. Do not press <PF3> ADD TABLE until changes are complete. Otherwise, you will be unable to make further changes.
To edit the new table definition, follow these instructions:
Type the new definition over the existing definition.
Place the cursor on a column name and press <PF6> DELETE COLUMN.
Place the cursor on the name of the column you want the new column to follow and press <PF5> INSERT COLUMN. A blank line appears for entering a name, type, and length in the appropriate panel fields.
Use the INSERT COLUMN and DELETE COLUMN PF keys to manually change the order of columns.
Procedure
To add the new table to your database, follow these steps during display of the CREATE TABLE (DQT30) panel.
Enter a unique table name in the field called TABLE NAME. Be careful not to duplicate the name of an existing table in your database.
The table name should begin with an alphabetic character. You can use letters, numbers, and underscores as part of the name. The maximum name length is 32 characters. After creation, CA Datacom Datadictionary assigns the table an entity-name and that name appears on directories. Where duplicate names occur, CA Datacom Datadictionary may modify a name to make it unique. Also, any table you create is stored under your permanent SQL authorization ID, maintained by your CA Dataquery Administrator. Changing the ID on your User Profile does not affect this storage. Check with your CA Dataquery Administrator for a table name if yours does not appear on a directory.
Press <PF3> ADD TABLE to create the new table.
|
Copyright © 2014 CA.
All rights reserved.
|
|