Difference between revisions of "Information Systems:F4 Prompt Windows"

From uniWIKI
Jump to navigation Jump to search
Line 1: Line 1:
−
If a field on an ASW screen must contain a value from a particular table, pressing F4 will show the possible values. This can also be used to find out the name of the file that contains those values - if, for example, you want to use it in a query. The program that displays these values can be either a specific program for the specific file, or a generic program that can display any file.
+
If a field on an ASW screen must contain a value from a particular table, pressing F4 will show those values. This can also be used to find out the name of the file that contains them - if, for example, you want to use it in a query. The program that displays these values can be either a specific program for the specific file, or a generic program that can display any file.
−  
   
  +
Open the prompt window on one session.
   
 
*PL/480B* Account file maintenance 1/06/16 11:58:09 FMR01005
 
*PL/480B* Account file maintenance 1/06/16 11:58:09 FMR01005
Line 22: Line 22:
 
| Pos. to _____________________ |
 
| Pos. to _____________________ |
 
|_____________________________________|
  
|_____________________________________|
  +
  +
On another session, do WRKACTJOB, and page down to the first session. Do option 5-Work with, then 11-Display call stack.
  +
  +
Display Call Stack
  +
System: BART
  +
Job: SHEILA1 User: SHEILAV Number: 242530
  +
Thread: 0000020B
  +
  +
Type Program Statement Procedure
  +
STRASWINL A450AP _CL_PEP
  +
STRASWINL A450AP 25200 STRASWINL
  +
QUICMENU QSYS /00C1
  +
1 QUIMNDRV QSYS /0D9B
  +
ASGC800 U480BP _CL_PEP
  +
ASGC800 U480BP 20500 ASGC800M
  +
FMR010 U480AP _QRNP_PEP_FMR010
  +
FMR010 U480AP 5193 FMR010
  +
WNDR001 U480AP _QRNP_PEP_WNDR001
  +
WNDR001 U480AP 1718 WNDR001
  +
QRNXIO QSYS 63 _QRNX_WS_EXFMT
  +
QWSGET QSYS /065F
  +
QT3REQIO QSYS /0256
  +
Bottom
  +
F3=Exit F5=Refresh F11=Display activation group F12=Cancel
  +
F16=Job menu F17=Top F18=Bottom F21=Include F22=Display entire field
  +
  +
Find the last application program. Ones that begin with 'Q', and in library 'QSYS' are system programs. So the last application program is WNDR001. That is the generic program. To see what file it is displaying, you Can use SQL.
  +
  +
On a command line in ASW, key in STRSQL and press enter. Copy and paste this statement -
  +
  +
select * from wnownd where wntx50 like 'XXXXX%'
  +
  +
where XXXXX is the heading from the prompt wind, in this case Summary. (Note that the entire heading has to be entered - the % is a wild card, for and number of characters.) So the SQL statement is
  +
  +
select * from wnownd where wntx50 like 'Summary%'

Revision as of 13:48, 6 January 2016

If a field on an ASW screen must contain a value from a particular table, pressing F4 will show those values. This can also be used to find out the name of the file that contains them - if, for example, you want to use it in a query. The program that displays these values can be either a specific program for the specific file, or a generic program that can display any file.

Open the prompt window on one session. 

*PL/480B*  Account file maintenance               1/06/16 11:58:09 FMR01005 
 _____________________________________                                                                              
|  Summary ID's                       | ---------------------------------------
|  Sum id  Summmary                   |    Petty Cash - Snow Plow              
|  part    identity   Description     | ---------------------------------------
|   4      ADV        Advertising an  | dation type.. 1                        
|   4      AMORT      Amortization    |                                        
|   4      CASH DISCO Cash discounts  |                                           
|   4      COMPUTERS  Computers       |                                           
|   4      CONSULTING Consulting fee  | e............                          
|   4      CORPORATIO Corporation ca  |                                           
|   4      COST OF GO Cost of goods   |                                           
|   4      DIRECTORS  Directors expe  |                                           
|   4      EQUIPMENT  Equipment leas  |                                           
|   4      FREIGHT    Freight         | mt section...                          
|   4      GL         Gain/loss on d  |                                           
|                            More...  |                                           
|  Pos. to _____________________      |                                           
|_____________________________________|

On another session, do WRKACTJOB, and page down to the first session. Do option 5-Work with, then 11-Display call stack. 

                              Display Call Stack                               
                                                            System:   BART     
Job:   SHEILA1        User:   SHEILAV        Number:   242530                  
Thread:   0000020B                                                             
                                                                               
Type  Program                  Statement         Procedure                     
      STRASWINL  A450AP                          _CL_PEP                       
      STRASWINL  A450AP        25200             STRASWINL                     
      QUICMENU   QSYS                     /00C1                                
   1  QUIMNDRV   QSYS                     /0D9B                                
      ASGC800    U480BP                          _CL_PEP                       
      ASGC800    U480BP        20500             ASGC800M                      
      FMR010     U480AP                          _QRNP_PEP_FMR010              
      FMR010     U480AP        5193              FMR010                        
      WNDR001    U480AP                          _QRNP_PEP_WNDR001             
      WNDR001    U480AP        1718              WNDR001                       
      QRNXIO     QSYS          63                _QRNX_WS_EXFMT                
      QWSGET     QSYS                     /065F                                
      QT3REQIO   QSYS                     /0256                                
                                                                        Bottom 
F3=Exit        F5=Refresh   F11=Display activation group   F12=Cancel          
F16=Job menu   F17=Top   F18=Bottom   F21=Include   F22=Display entire field

Find the last application program. Ones that begin with 'Q', and in library 'QSYS' are system programs. So the last application program is WNDR001. That is the generic program. To see what file it is displaying, you Can use SQL.

On a command line in ASW, key in STRSQL and press enter. Copy and paste this statement - 

select * from wnownd where wntx50 like 'XXXXX%'

where XXXXX is the heading from the prompt wind, in this case Summary. (Note that the entire heading has to be entered - the % is a wild card, for and number of characters.) So the SQL statement is 

select * from wnownd where wntx50 like 'Summary%'
Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:F4_Prompt_Windows&oldid=1594"