Difference between revisions of "Information Systems:F4 Prompt Windows"
m |
|||
| (3 intermediate revisions by one other user not shown) | |||
| Line 48: | Line 48: | ||
F16=Job menu F17=Top F18=Bottom F21=Include F22=Display entire field |
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 |
+ | 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 - |
On a command line in ASW, key in STRSQL and press enter. Copy and paste this statement - |
||
| Line 54: | Line 54: | ||
select * from wnownd where wntx50 like 'XXXXX%' |
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 |
+ | where XXXXX is the heading from the prompt wind, in this case Summary. (Note that the entire heading does not have to be entered - the % is a wild card, for any number of characters.) So the SQL statement is - |
select * from wnownd where wntx50 like 'Summary%' |
select * from wnownd where wntx50 like 'Summary%' |
||
| + | |||
| + | The result is - |
||
| + | |||
| + | Display Data |
||
| + | Data width . . . . . . : 4003 |
||
| + | Position to line . . . . . Shift to column . . . . . . |
||
| + | ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...10 |
||
| + | Window Sub App. PTF Mod Identity Change File Window Text description |
||
| + | ID set code level no date Library |
||
| + | key |
||
| + | ANBSLH 9 GEN 19990325 ANBSLH *LIBL Summary levels |
||
| + | SRBSID 9 FIN 19990325 SRBSID *LIBL Summary ID's |
||
| + | ******** End of data ******** |
||
| + | |||
| + | F3=Exit F12=Cancel F19=Left F20=Right F21=Split F22=Width 80 |
||
| + | |||
| + | Summary identities are in SRBSID, which is a logical view of SROSID. |
||
| + | |||
| + | [[Category: Using IBM i]] |
||
Latest revision as of 10:47, 22 August 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 does not have to be entered - the % is a wild card, for any number of characters.) So the SQL statement is -
select * from wnownd where wntx50 like 'Summary%'
The result is -
Display Data
Data width . . . . . . : 4003
Position to line . . . . . Shift to column . . . . . .
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...10
Window Sub App. PTF Mod Identity Change File Window Text description
ID set code level no date Library
key
ANBSLH 9 GEN 19990325 ANBSLH *LIBL Summary levels
SRBSID 9 FIN 19990325 SRBSID *LIBL Summary ID's
******** End of data ********
F3=Exit F12=Cancel F19=Left F20=Right F21=Split F22=Width 80
Summary identities are in SRBSID, which is a logical view of SROSID.