Using the SQLM Menu Options

Entering File and Table Names

All the SQLM menu options prompt you to enter a file and/or table name. For example:

Define Filenames to be Processed....
Enter Filename :

Type a file name and press RETURN. You will then be prompted again.

Enter Filename :

At this point, you can enter a second file name, or simply press RETURN. If you enter another file name, you will be prompted for a third file name. The prompts will repeat until you press RETURN without entering a file name.

When you press RETURN without entering a file name, you will proceed to the next stage of the SQLM option.

Selection Completed: Enter <FI>le or <EX>it :

If, at the Enter Filename :  prompt shown above, you enter a question mark (?), a list of files is displayed, from which you can select (see below).

Selecting from a List

Some SQLM screens display a list from which you can select. For example, if you enter a question mark (?) at the Enter Filename :  prompt shown above, you will see a screen similar to the following:

                        SQL MAINTENANCE - Verify Table
                        ==============================
Select existing Table
1. CUSTOMERS
2. ORDERS
3. PRODUCTS







Enter # to select (*)=all, (FI)le or (EX)it :

If there are more items than can be displayed on a single screen, the prompt at the bottom of the screen will be:

Enter # to select (*)=all, (FI)le or (EX)it :
OR Enter (F)orward (B)ackward to page.

Enter F  to display the next page, or B  to display the previous page.

To select an item from the list, enter the number shown beside the item concerned. The word Selected  will be displayed beside the item concerned. For example.

2. ORDERS................................Selected

Repeat for each item you wish to process. To select all the items, enter *.

To deselect a selected item, enter the number of the item concerned. If all items are selected, entering *  will deselect them all.

When you have selected all the items you require, enter FI. To exit from the current option, enter EX.

Amendments Screens

When using the commands in SQLM option 4 (Amend Table definitions), you will see screens similar to that shown below.

                    Current Grants for Table 'GUESTS'
                    =================================
User_ID / ~Security_Profile ......      Grants ...............................
1. DAVEH                                Owner
2. PUBLIC                               None

Enter Ins,Del,Upd,Copy or <CR> (I/Dn/Un/Cn) :

This screen allows you to insert new entries, delete and update existing entries and copy existing entries to create new ones (some screens have only the insert and delete options).

• To insert a new entry, enter I.

  On some screens, you must also specify the position for the new entry, by entering In, where n is the required line number. The new entry will be inserted before the existing entry with the same number. To add an entry to the end of the list, specify a line number one greater than that of the last entry.

  When you press RETURN, a screen that allows you to set up the entry may be displayed.

• To delete an entry, enter D  followed by the line number of the required entry. When you press RETURN, the entry will be deleted.
• To update an entry, enter U  followed by the line number of the required entry. A screen that allows you to update the entry will be displayed.

• To copy an entry, enter C  followed by the line number of the required entry. When you press RETURN, you will be prompted:

  Enter destination name :

  Enter a name for the new entry. In some cases, you will then be prompted:

  Enter position # for 'NewEntry' :

  Enter the required line number for the new entry. The new entry will be inserted before the existing entry with the same number. To add an entry to the end of the list, specify a line number one greater than that of the last entry.

  When you press RETURN, a screen that allows you to set up the entry may be displayed.

Enter Line Number for action U :