Deleting Source and Output Members

Using the Interactive SQL Service Facility › Maintaining Source and Output Members › Deleting Source and Output Members

Deleting Source and Output Members

You can use the delete function of the Interactive SQL Service Facility to remove a source or output member. Only the source or output member is deleted with the delete function. The objects created by the statements in a member remain intact.

To delete a member, either:

Select option 3 (DELETE) on the SQLMAINT Panel.
Enter the DEL margin command on the SQL Member List Panel. See Displaying Source and Output Members for details.
Enter the DEL SQL command in the command line in Interactive SQL Service Facility. See DELETE SQL Command for details.

If you select option 3 on the SQLMAINT Panel, CA Datacom Datadictionary displays the SQL Member Selection Criteria Fill-in Panel. Use this panel to identify the source member and/or the output member being deleted. The panel displays the option you are requesting on the left of the panel.

 =>
 =>
 =>
 
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLMAINT
 
                     SQL Member Selection Criteria Fill-in                  S01F
 
 
 DELETE   SQL  / ________ , ________ , ________________________________ /
 DEL             (source)   (output)   (description)
                 (name  )   (name  )
 
 
 
 
 
 NOTE:  Press Enter to obtain a list of source/output members.
 
 
 PF1=HELP         PF2=END         PF3=SPLIT         PF4=PROCESS
 PF5=TOP          PF6=BOTTOM      PF7=BACKWARD      PF8=FORWARD
 PF9=EXECUTE      PF10=LEFT       PF11=RIGHT        PF12=ALTERNATE

Complete your specifications on the SQL Member Selection Criteria Fill-in Panel according to the following descriptions if you are deleting a specific source and/or output member.

source name

(Optional) Enter the name of the member that you are deleting. If you obtain this panel after entering the DEL margin command on the SQL Member List Panel, the source member name and person name are displayed.

Leave this field blank if you are requesting a display of all members or if you only intend to delete an output member.

Valid Entries:: 1 to 8 characters
Default Value:: (No default)

output name

(Optional) Enter the name of the member that you are deleting. If you obtain this panel after entering the DEL margin command on the SQL Member List Panel, the output member name and person name are displayed.

Leave this field blank if you are requesting a display of all members or if you only intend to delete a source member.

Valid Entries:: 1 to 8 characters
Default Value:: (No default)

description

The description you entered on the SQL Member Selection Criteria Fill-in Panel displays.

Review your entries, and press Enter. CA Datacom Datadictionary automatically deletes the member(s) indicated and displays a message indicating the status of the deletion.

 =>
 =>
 =>
 1-DDOL000002I - S1FP - SUCCESSFUL DELETE OF MEMBER(S)
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLMAINT
 
                     SQL Member Selection Criteria Fill-in                  S01F
 
 
 DELETE   SQL  / DEPTTBL  , ________ , DEPARTMENT ORGANIZATIONAL TABLE   /
 DEL             (source)   (output)   (description)
                 (name  )   (name  )
 
 
 
 
 NOTE:  Press Enter to obtain a list of source/output members.
 
 
 
 PF1=HELP         PF2=END         PF3=SPLIT         PF4=PROCESS
 PF5=TOP          PF6=BOTTOM      PF7=BACKWARD      PF8=FORWARD
 PF9=EXECUTE      PF10=LEFT       PF11=RIGHT        PF12=ALTERNATE

If you do not know the source or output member name, press ENTER on the SQL Member Selection Criteria Fill-in Panel to display a listing of source and output members. Enter the DEL margin command in the line of the source and/or output members you want to delete.

Press Enter on the SQL Member Selection Criteria Fill-in Panel to delete the source and/or output members. If you have entered the DEL margin command, you can press PF4 (PROCESS) to delete the first member selected and proceed to the next selection or the SQL Member Selection Criteria Fill-in Panel.

After deleting the source and/or output members, you can perform one of the following:

Enter another source and/or output name to delete.
Press PF2 (END) to return to the SQLMAINT Panel.
Press CLEAR to return to the Interactive SQL Service Facility Panel to perform another function.