Online Commands › DELETE › In Interactive SQL Service Facility

In Interactive SQL Service Facility

You can use the DELETE SQL command in Interactive SQL Service Facility to delete a source or output member. Use the following format for this function:

DELETE (in Interactive SQL Service Facility)

►►─┬─ DELETE ─┬─ SQL ─────────────────────────────────────────────────────────►
   └─ DEL ────┘

 ►─ / ─┬──────────────────────┬ ─┬──────────────────────────┬─ / ─────────────►◄
       └─ source-member-name ─┘  └─ , ─ output-member-name ─┘

source-member-name

Enter the name of the source member that you are deleting.

Valid Entries:

1 to 8 characters

Default Value:

(No default)

output-member-name

Enter the name of the output member that you are deleting.

Valid Entries:

1 to 8 characters

Default Value:

(No default)

After you enter the DELETE SQL command, CA Datacom Datadictionary displays the SQL Member Selection Criteria Fill-in Panel with the source or output member name displayed. Press Enter on this panel to delete the members.

After the members are deleted successfully, you can perform one of the following functions:

• Enter another SQL command on the command line
• Press PF2 (END) to return to the SQLMAINT Panel
• Press Clear to return to the Interactive SQL Service Facility Panel to perform another function

Note: If you are using the DEL margin command to place SQL source or output members in the online work queue and then process the queue by entering PRO (PROCESS) in the command line, first use the EOF key to clear out the member name you just deleted before processing the next member. If you do not do this, you receive an error message.