Displaying Source and Output Members

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

Displaying Source and Output Members

You can display the contents of a specific source or output member or a list of all members created by a person. The person can be a named person or the person currently signed on to CA Datacom Datadictionary.

Display Specific Member

Use one of the following to display a specific member.

Select option 2 (DISPLAY) on the SQLMAINT Panel and complete the entries on the SQL Member Selection Criteria Fill-in Panel.
Enter the full DISPLAY SQL command. See DISPLAY SQL Command for information on entering this command.
Leave the panel blank and press Enter to receive the list of members. You can then enter the DIS margin command next to the member you want to display.
Enter only DISPLAY SQL to receive the panel and press Enter to receive the list of members. You can then enter the DIS margin command next to the member you want to display.

Display Member List

Use one of the following to display a specific member.

Leave the SQL Member Selection Criteria Fill-in Panel blank and press Enter to display a list of all source and output members.
Specify only the person on the SQL Member Selection Criteria Fill-in Panel to display a list of all source and output members for that person.
Enter the DIS SQL LIST command in the command line of a panel to obtain the list for the person currently signed on or include a valid PERSON occurrence name in the command to obtain the list for that person. See DISPLAY SQL Command for information on entering this command.

If you select option 2 (DISPLAY) on the SQLMAINT Panel, CA Datacom Datadictionary displays a SQL Member Selection Criteria Fill-in Panel. The panel displays the function you are requesting on the left side of the panel.

 =>
 =>
 =>
 
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLMAINT
 
                     SQL Member Selection Criteria Fill-in                  S02F
 
 
 DISPLAY  SQL  / ________ , ________ , __________________ /
 DIS             (source)   (output)   (person)
                 (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 displaying a specific source and/or output member.

source name

(Optional) Enter the name of the member that contains the SQL statements you want to display. Leave this field blank if you want to display the output member only. Leave both fields blank to obtain the SQL Member List Panel.

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

output name

(Optional) Enter the name of the member that contains results of executing a source member. Leave this field blank if you want to display the source member only. Leave both fields blank to obtain the SQL Member List Panel.

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

person

(Optional) Enter the name of the person who created the source and output members. Leave this field blank to obtain the SQL Member List for the person currently signed on to CA Datacom Datadictionary.

Valid Entries:: The first 18 characters of the 1- to 32-character PERSON occurrence name
Default Value:: PERSON occurrence name associated with the person currently signed on to CA Datacom Datadictionary

After completing the SQL Member Selection Criteria Fill-in Panel, press Enter to display the Source or Output Panel. If you have left the source and output member names blank, a list of all current source and output members for the specified person displays, as in the following example:

 =>
 =>
 =>
 
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLMAINT
 
                                SQL Member List                             S01N
                           Person: JONES
 
        Name     Type Description                      Updated  Lines
 ====== ========   =   ============ T O P =============  ======  =====
 000001 $DDSQL    O   CREATE MY SCHEMA                  112099  00004
 000002 DEPTTBL   O   DEPARTMENT ORGANIZATION TABLE     112099  00011
 000003 $DDSQL    S   CREATE MY SCHEMA                  112099  00001
 dis004 DEPTTBL   S   DEPARTMENT ORGANIZATION TABLE     112099  00006
 ====== ========  =   ========= B O T T O M ==========  ======  =====
 
 
 
 
 PF1=HELP         PF2=END         PF3=SPLIT         PF4=PROCESS
 PF5=TOP          PF6=BOTTOM      PF7=BACKWARD      PF8=FORWARD
 PF9=EXECUTE      PF10=LEFT       PF11=RIGHT        PF12=ALTERNATE

When the display is longer than the screen, you can use the scroll commands or PF keys to move backwards and forwards through the display. Another panel to display the additional fields follows the description of the fields on this panel.

The following information is displayed for each member.

Name: The name of the source or output member.
Type: Identifies whether the member is a source (S) or output (O) member.
Description: The description entered for the source member when the member was created.
Updated: The date the member was updated in month, day, and year format (mmddyy).
Lines: The number of lines in the member.

The members are listed in alphabetical order by type with the output members first.

Example

The previous SQL Member List Panel shows an example of entering the DIS margin command on line 004. See Using Margin Commands for more information on these commands. After entering margin commands, you can perform either of the following:

Press Enter or any scrolling PF key to refresh the screen and enter additional margin commands as desired.
Press PF4 or enter the PROCESS command to bring the first activity from the online work queue. In this example, CA Datacom Datadictionary displays the SQL Member Selection Criteria Fill-in Panel for DISPLAY where you can enter the associated source or output member name, or change the displayed names.

After you have completed any entries on the SQL Member Selection Criteria Fill-in Panel, press Enter to display the source and/or output members. CA Datacom Datadictionary always displays the source members first, if you have entered a source member name on the prompter panel.

The following panel illustrates the results of using the DIS margin command to display the source member for DEPTTBL.

 =>
 =>
 =>
 
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLMAINT
 
                                 Source Panel                               S01S
            EDIT     Member: DEPTTBL   Output Line Limit:  01000
                     Person: JONES
             Current Authid: JONES
                Description: CREATE TABLE DEPTTBL
 -------------------------------------------------------------------------------
 ====== ========================== T O P =======================================
 000001 CREATE TABLE DEPTTBL
 000002       (DEPTNO CHAR(2) NOT NULL,
 000003        DEPTNAME CHAR(24) NOT NULL);
 ====== ======================= B O T T O M ====================================
 
 
 
 PF1=HELP         PF2=END         PF3=SPLIT         PF4=PROCESS
 PF5=TOP          PF6=BOTTOM      PF7=BACKWARD      PF8=FORWARD
 PF9=EXECUTE      PF10=LEFT       PF11=RIGHT        PF12=ALTERNATE

To exit from either the Source or Output Panels, you can do one of the following:

Press PF12 (ALTERNATE) to obtain the associated source or output member you named on the prompter panel.
Press PF2 (END) to obtain an SQLMAINT Panel where you can select another option.
Press CLEAR to return to the Interactive SQL Service Facility Panel to select another function.