Difference between revisions of "Information Systems:EZVIEW"
(Created page with "The Easy View (EZVIEW) command will display virtually any AS/400 database file. Other functions, such as scan/replace, change/delete, data base relations, modeling, e...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
change/delete, data base relations, modeling, etc, can be accessed as well, depending on the users AS/400 and/or Easy View authority. |
change/delete, data base relations, modeling, etc, can be accessed as well, depending on the users AS/400 and/or Easy View authority. |
||
| − | [[DFU]] cannot be used on a file that has fields so long that they cannot fit on the display. An example of this is the cart file in Web Orders (XL_WEBSPT/PW_TRNF); it has a field that is 32,672 characters long. You must use EZVIEW to manually edit it. |
+ | [[Information Systems:DFU]] cannot be used on a file that has fields so long that they cannot fit on the display. An example of this is the cart file in Web Orders (XL_WEBSPT/PW_TRNF); it has a field that is 32,672 characters long. You must use EZVIEW to manually edit it. |
Figure out the logical file that will allow you to access the record you want. In this example, we know the transaction number (cart number) for the ecommerce transaction file. |
Figure out the logical file that will allow you to access the record you want. In this example, we know the transaction number (cart number) for the ecommerce transaction file. |
||
| Line 68: | Line 68: | ||
X = Export record to physical file. Use F23 to set up |
X = Export record to physical file. Use F23 to set up |
||
the file, or just use X and you will be prompted. |
the file, or just use X and you will be prompted. |
||
| + | |||
| + | [[Category: IBM i Tools/Utilities]] |
||
Latest revision as of 00:47, 23 June 2016
The Easy View (EZVIEW) command will display virtually any AS/400 database file. Other functions, such as scan/replace, change/delete, data base relations, modeling, etc, can be accessed as well, depending on the users AS/400 and/or Easy View authority.
Information Systems:DFU cannot be used on a file that has fields so long that they cannot fit on the display. An example of this is the cart file in Web Orders (XL_WEBSPT/PW_TRNF); it has a field that is 32,672 characters long. You must use EZVIEW to manually edit it.
Figure out the logical file that will allow you to access the record you want. In this example, we know the transaction number (cart number) for the ecommerce transaction file.
Key in EZ and press enter.
Easy View a File (EZVIEW)
Type choices, press Enter.
File Name: . . . . . . . . . . . pw_trnf Name, *PRV, *SELECT
Library Name: . . . . . . . . xl_webspt Name, *LIBL
Member Name: . . . . . . . . . . Character value
Access Method . . . . . . . . . *KEY *KEY, *ARRIVAL
Starting Key . . . . . . . . . .
Additional Parameters
Intial Display Mode . . . . . . *USRDFT *USRDFT, 1, 2, 3, 4, 5, 6...
RRN,Format,Member . . . . . . . *USRDFT *USRDFT, *RRN, *FORMAT...
Upper or Lower Case . . . . . . *USRDFT *USRDFT, *UPPER, *LOWER
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display
F24=More keys
Fill in the file and library, then press enter again.
Rec. Length.: 32742 File: PW_TRNF Library: XL_WEBSPT Member: PW_TRNF
Rec. Count..: 2218 Access.: *KEY Mode..: INQUIRY
SCAN........: to -OR- *EQ
Field number: 1 field/text locate:
Lower Limits. 00000288claim 0002 US
Transacti Subtrans Name TXSEQN TXLIFE
8641 288 claim 2 0
8623 288 claim 3 0
8664 288 claim 4 0
433 295 0 30
35 299 0 30
2029 299 claim 1 0
3617 299 claim 2 0
7687 299 claim 3 0
3172 299 regular 1 0
3173 299 regular 2 0
3174 299 regular 3 0
4147 299 regular 4 0
4115 299 regular 5 0
4260 299 regular 6 0
291 305 0 30
557 319 0 30
F2=Previous Files F3=Exit F4=Select Mode F24=More Keys
You can go directly to the record you want by filling in the 'Lower Limits'. You can see that it is transaction, sub transaction name, and sequence number. Fill in those values for the record you want - making sure to use the same positions. Press enter.
Your options are -
C = CHANGE An update screen will appear, and you may
make changes to the record.
R = REPLICATE To create a new record based on the
data in the one next to the "R".
D (or 4) = DELETE To remove records from the file.
E = To display the record in EZFIELD format.
P = Print record.
S = Save record to clipboard
X = Export record to physical file. Use F23 to set up
the file, or just use X and you will be prompted.