Editing Database Files and other Data: Difference between revisions

From Try-AS/400
Jump to navigation Jump to search
(SQL)
Line 8: Line 8:


== Database Files ==
== Database Files ==
There are basically 2½ ways to edit (or view) database file contents:
There are basically 3½ ways to edit (or view) database file contents:
* Create a DFU program with <code>STRDFU</code> which directs you to the appropriate menu and
* Create a DFU program with <code>STRDFU</code> which directs you to the appropriate menu and
** allows some possibilities in UI design via item 2,
** allows some possibilities in UI design via item 2,
** Create a throwaway temporary DFU program which gets deleted after using via item 5,
** Create a throwaway temporary DFU program which gets deleted after using via item 5,
* 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>.


== Footnotes ==
== Footnotes ==

Revision as of 17:02, 8 September 2019

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 STRDFU which 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.

Footnotes

  1. ↑ Enter STRSEU in a command line and press F4 to learn about parameters.
  2. ↑ Program Development Manager, a collection of programs to ease development and dependency tracking of medium to large size projects.
  3. ↑ Enter WRKMBRPDM in a command line and press F4 to learn about parameters.
Retrieved from "http://try-as400.pocnet.net/index.php?title=Editing_Database_Files_and_other_Data&oldid=280"