Previous Topic: DELETE SQL CommandNext Topic: EDIT SQL Command


DISPLAY SQL Command

Use the DISPLAY SQL command to display a specific source or output member, or display a list of the members for the person currently signed on to CA Datacom Datadictionary. To display a specific source or output member, use the following format for this command. The abbreviated command syntax is DIS.

on
DISPLAY SQL /[source-member-name][,output-member-name][,person-occurrence-name]/
off
source-member-name

(Optional) Enter the name of the member that contains the SQL statements you want to display.

Valid Entries:

1 to 8 characters

Default Value:

(No default)

,output-member-name

(Optional) Enter the name of the member that contains the results of executing a source member.

Valid Entries:

1 to 8 characters

Default Value:

(No default)

,person-occurrence-name

(Optional) Enter the name of the person who created the source member.

Valid Entries:

1- to 32-character PERSON occurrence-name

Default Value:

PERSON occurrence-name associated with the person currently signed on to CA Datacom Datadictionary

To display a list of all source and output members for a specific PERSON occurrence, use the following command. The abbreviated command syntax is DIS.

on
DISPLAY SQL LIST [person-occurrence-name]
off

person-occurrence-name

(Optional) Enter the name of the person who created the source members you want to display.

Valid Entries:

1- to 32-character PERSON occurrence name

Default Value:

PERSON occurrence name associated with the person currently signed on to CA Datacom Datadictionary

After entering the DISPLAY SQL LIST command, CA Datacom Datadictionary displays the SQL Member List Panel. If the display is longer than the screen, you can use the scroll commands or PF keys to move backward or forward through the display.

You can enter the following SQL margin commands on the SQL Member List Panel: COP or CPY, DEL, DIS, and EDT. See Using Margin Commands.