Using the Interactive SQL Service Facility › Using Commands › DELETE SQL Command

DELETE SQL Command

You can use the DELETE SQL command to delete a source or output member.

Note: Use the SQL DROP statement to delete SQL-accessible tables, views, or synonyms. See Deleting SQL Objects and DROP.

Use the following format for the DELETE SQL command. The abbreviated command syntax is DEL.

on
DELETE SQL /[source-member-name][,output-member-name]/
off

source-member-name

(Optional) Enter the name of the source member that you are deleting.

Valid Entries:

1 to 8 characters

Default Value:

(No default)

,output-member-name

(Optional) 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 and/or output member name displayed. Press Enter on this panel to delete the member(s).

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

• Enter another source and/or output name to delete.
• 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.