Online Commands › DISPLAY › In Interactive SQL Service Facility

In Interactive SQL Service Facility

You can use the DISPLAY command to display a specific source or output member, or display a list for the person currently signed on to CA Datacom Datadictionary in Interactive SQL Service Facility. To display a specific source or output member, use the following format for this command:

DISPLAY SQL (in Interactive SQL Service Facility)

►►─┬─ DISPLAY ─┬─ SQL ─ / ─┬──────────────────────┬───────────────────────────►
   └─ DIS ─────┘           └─ source-member-name ─┘

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

source-member-name

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

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

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.

DISPLAY SQL LIST (in Interactive SQL Service Facility)

►►─┬─ DISPLAY ─┬─ SQL ─ LIST ─┬──────────────────────────┬────────────────────►◄
   └─ DIS ─────┘              └─ person-occurrence-name ─┘

person-occurrence-name

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. For more information and a functional description of these margin commands, see the CA Datacom/DB SQL User Guide.