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

EDIT SQL Command

Use the EDIT SQL command to create or modify a source member. Enter the following command on the command line on a panel. The abbreviated command syntax is EDT.

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

source-member-name

(Optional) 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

(Optional) 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

(Optional) 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 Source Panel where you can perform one of the following functions:

• Edit the SQL statement(s) or enter additional SQL statements. Place a semicolon after each complete statement.
• Press PF9 (EXECUTE) to execute the source member. CA Datacom Datadictionary responds with the Output Panel which shows the results of SQL processing.
• Press PF2 (END) to obtain an SQLMAINT Panel where you can select the EDIT function and then specify another source member.
• Press CLEAR to return to the Interactive SQL Service Facility Panel to choose another function.