Editing Database Files and other Data - Revision history

PoC: De-whichified

2020-03-12T21:57:09Z

De-whichified

← Older revision		Revision as of 23:57, 12 March 2020
Line 9:		Line 9:
	== Database Files ==		== Database Files ==
	There are basically 3½ 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> that 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 that 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>.		* Utilize the interactive SQL facility <code>strsql</code>.

PoC: Reworked

2020-02-23T20:04:52Z

Reworked

← Older revision		Revision as of 22:04, 23 February 2020
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 />

	~~== Beyond ==~~
	~~[[Editing Source Files using Eclipse and FTP]]~~

	[[Category: Basic Knowledge]]		[[Category: Basic Knowledge]]

Heiko: /* Footnotes */

2019-10-07T20:30:48Z

Footnotes

← Older revision		Revision as of 22:30, 7 October 2019
Line 17:		Line 17:
	== Footnotes ==		== Footnotes ==
	<references />		<references />

			== Beyond ==
			[[Editing Source Files using Eclipse and FTP]]

	[[Category: Basic Knowledge]]		[[Category: Basic Knowledge]]

PoC: SQL

2019-09-08T16:02:49Z

SQL

← Older revision		Revision as of 18:02, 8 September 2019
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 ==

PoC: /* Database Files */ Linkfix

2019-03-04T23:37:31Z

Database Files: Linkfix

← Older revision		Revision as of 01:37, 5 March 2019
Line 12:		Line 12:
	** 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 [[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.

	== Footnotes ==		== Footnotes ==

PoC: Cat

2018-12-31T17:19:01Z

Cat

← Older revision		Revision as of 19:19, 31 December 2018
Line 16:		Line 16:
	== Footnotes ==		== Footnotes ==
	<references />		<references />

			[[Category: Basic Knowledge]]

PoC: Revised

2018-12-30T23:20:52Z

Revised

New page

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 <code>EDTF</code> in a command line and press <code>F4</code> to learn about parameters.

== Source Files ==
''Members'' of source files are edited with the Source Entry Utility (SEU)<ref>Enter <code>STRSEU</code> in a command line and press <code>F4</code> to learn about parameters.</ref>. Since SEU requires manual declaration of Library, File and Member to edit, it's more often indirectly invoked with a command part of PDM<ref>Program Development Manager, a collection of programs to ease development and dependency tracking of medium to large size projects.</ref>, <code>WRKMBRPDM</code>.<ref>Enter <code>WRKMBRPDM</code> in a command line and press <code>F4</code> to learn about parameters.</ref> 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 2½ ways to edit (or view) database file contents:
* 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,
** 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.

== Footnotes ==
<references />