EDIT SQL

You can use the EDIT command in the Interactive SQL Service Facility to modify a source member containing SQL statements. Enter the following command on the command line in the Interactive SQL Service Facility:

►►─┬─ EDIT ─┬─ SQL ─ / ─┬──────────────────────┬──────────────────────────────►
   └─ EDT ──┘           └─ source-member-name ─┘

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

source-member-name

Enter the name of the member containing the SQL statements you want to edit.

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

,output-member-name

Enter the name of the member containing the results of executing a source member.

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

,description

You can enter the 32-character description of the source member.

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

After you enter the EDIT command, CA Datacom Datadictionary displays the SQL Member Selection Criteria Fill-in Panel where you can:

Enter another source, output, or description
Press Enter which displays the SQL Source Panel, where you can perform one of the following functions:
- Enter or modify one or more SQL statements. Place a semi-colon (;) after each complete statement. For more information and for syntax details on entering SQL commands, see the CA Datacom/DB SQL User Guide.
- Press PF9 (EXECUTE) to execute the source member. CA Datacom Datadictionary responds with the SQL Output Panel which shows the results of SQL processing. For more information and details on the SQL Output Panel, see the CA Datacom/DB SQL User Guide.
- Press PF2 (END) to return to the SQLMAINT Menu, where you can specify another function.
- Press Clear to return to the Interactive SQL Service Facility Panel to choose another option.