ROW

If you enter ROW in the line command area, FM/Db2 displays the column name (and its value) as held in the Db2® catalog table for each column of the specified object,

You can enter more than one ROW line command at a time.

Using the ROW line command shows the use of the ROW line command, placed in the line command area for the synonym object TCONA.
Figure 1. Using the ROW line command
  Process   Options   Utilities   Help
 ______________________________________________________________________________
 FM/Db2 (DFG2)                      Synonyms                  Row 1 to 11 of 36

 Location:

                                                                    Created
 Cmd   Synonym          + Owner  + Table/View Name  + Owner  +      By     +
       *_________________ *_______ *_________________ *_______      *_______

 _____ DEPT               HARFOUJ  DEPT               DSN8810       HARFOUJ
 _____ DEPT               KIEFERA  DEPT               DSN8810       KIEFERA
 _____ SDEPT              KIEFERA  DEPT               DSN8810       KIEFERA
 _____ VPSTRDE1           BRADB    VPSTRDE1           FMDB2         BRADB
 _____ VPSTRDE2           BRADB    VPSTRDE2           FMDB2         BRADB
 _____ VASTRDE1           BRADB    VASTRDE1           FMDB2         BRADB
 _____ EMP                BRADB    EMP                FMDB2         BRADB
 _____ VPHONE             BRADB    VPHONE             FMDB2         BRADB
 ROW__ TCONA              BRADB    TCONA              FMDB2         BRADB
 _____ DEPT               BRADB    DEPT               FMDB2         BRADB
 _____ VDEPT              BRADB    VDEPT              FMDB2         BRADB

 Command ===> _____________________________________________________ Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Result of using the ROW line command shows the result. In this case, the column names are from the Db2® catalog table, SYSSYNONYMS.
Figure 2. Result of using the ROW line command
  Process   Options   Utilities   Help
────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                    Display Row                   Row 1 to 7 of 7

 Column Name        Column Value
 *_________________ *___________________________________________________________

 NAME               TCONA
 CREATOR            BRADB
 TBNAME             TCONA
 TBCREATOR          FMDB2
 IBMREQD            N
 CREATEDBY          BRADB
 CREATEDTS          2001-05-02-10.01.58.268038
 ******************************* END OF Db2 DATA *******************************






 Command ===> _____________________________________________________ Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

You can limit the number of entries shown on the panel by entering search criteria in the areas marked by an asterisk (*) immediately below the headings.

Related tasks