Editing Database Files and other Data: Difference between revisions
(Reworked) |
|||
| Line 14: | Line 14: | ||
* Use the AS/400 facilities to [[How to program an Application|Program an Application]] yourself. This sounds a lot more complicated than it is. | * Use the AS/400 facilities to [[How to program an Application|Program an Application]] yourself. This sounds a lot more complicated than it is. | ||
* Utilize the interactive SQL facility <code>strsql</code>. | * Utilize the interactive SQL facility <code>strsql</code>. | ||
== Beyond == | |||
See also: [[Editing Source Files using Eclipse and FTP]] | |||
== Footnotes == | == Footnotes == | ||
<references /> | <references /> | ||
[[Category: Basic Knowledge]] | [[Category: Basic Knowledge]] | ||
Revision as of 22:04, 23 February 2020
As explained in Filesystems and Files on the AS/400, the AS/400 supports multiple file types. We will focus on database files in this article, though.
Stream Files
The AS/400 permits green-screen editing of stream files in the IFS with the edtf command. Enter EDTF in a command line and press F4 to learn about parameters.
Source Files
Members of source files are edited with the Source Entry Utility (SEU)[1]. Since SEU requires manual declaration of Library, File and Member to edit, it's more often indirectly invoked with a command part of PDM[2], WRKMBRPDM.[3] This command provides one with a member list of a chosen source file and thus makes it easy to navigate between members.
Database Files
There are basically 3½ ways to edit (or view) database file contents:
- Create a DFU program with
STRDFUwhich directs you to the appropriate menu and- allows some possibilities in UI design via item 2,
- Create a throwaway temporary DFU program which gets deleted after using via item 5,
- Use the AS/400 facilities to Program an Application yourself. This sounds a lot more complicated than it is.
- Utilize the interactive SQL facility
strsql.
Beyond
See also: Editing Source Files using Eclipse and FTP