Issuing Db2® commands from the command line
You can issuing a Db2® command from the
command line on these ZDT/Db2 panels:
- Table Browse panel
- Table Edit panel
- Table View panel
- Object list panels displayed with the Object List utility
- Privilege details panels
- Enter, Execute and Explain SQL Statements panel
To issue a Db2® command from the command line of a Z Data Tools/Db2 panel:
- Type
DB2
, followed a space, and then the Db2® command you want to issue.For example, to issue the Db2® command DISPLAY ARCHIVE, type:DB2 DISPLAY ARCHIVE
- Press Enter.
ZDT/Db2 displays the output from the Db2® command in an ISPF View session as shown in Example of output displayed by Db2 after Db2 command issued.
File Edit Edit_Settings Menu Utilities Compilers Test Help ─────────────────────────────────────────────────────────────────────────────── VIEW SYS07228.T121015.RA000.HFMUSER.R0227849 Columns 00001 00072 ****** ***************************** Top of Data ****************************** ==MSG> -Warning- The UNDO command is not available until you change ==MSG> your edit profile using the command RECOVERY ON. 000001 DSNV401I -DFE2 DISPLAY THREAD REPORT FOLLOWS - 000002 DSNV402I -DFE2 ACTIVE THREADS - 000003 NAME ST A REQ ID AUTHID PLAN ASID TOKEN 000004 DB2CALL T 144 HFMUSER HFMUSER HFM2PLN1 00C0 302 000005 DB2CALL T * 2 HFMUSER HFMUSER 00C0 303 000006 DISPLAY ACTIVE REPORT COMPLETE 000007 DSN9022I -DFE2 DSNVDT '-DISPLAY THREAD' NORMAL COMPLETION ****** **************************** Bottom of Data **************************** Command ===> Scroll ===> PAGE F1=Help F2=Split F3=Exit F5=Rfind F6=Rchange F7=Up F8=Down F9=Swap F10=Left F11=Right F12=Cancel
Related references