|
Database
 |
Configuration |
Security |
|
DB2/400
An understanding of the company's standard business rules begins with the database layout and definition.
If we are required to extract information to display on a web site we need to know where the information
is coming from. The AS/400 deploys a Relation Data Base Management System (RDBM). This means the required information
may be distributed across multiple files, file system and even multiple AS/400.
If the information we wish to display is to complicated or time consuming to retrieve there may be an alternative.
For example, data obtained for month end may require hours of calculations and several dozens modules to execute.
We may chose not to repeat these steps by simply converting the spool output to a data base file or create a
temporary file to hold the data.
NOTE: Be aware that all print control codes are striped when we convert the spool file. This may not be appropriate as
we have removed the formatting of line and page breaks.
Physical
Logical
Join Files
Triggers
RDM Files
Spool File
Intergrated File System (IFS)
In addition to supporting DB2/400 known as QSYS.LIB the AS/400 has the ability to support multiple file system known as the Integrated File System (IFS).
Several important file system that Java Developers are well aware of is the Root and QOpenSys. Both support stream files in a
DOS like hierarchical directory structure. The only difference between the two is case sensitive and Unix Posix compatible, thus
Java developers favor the QOpenSys file system. It is within this system we may wish to create HTML, images such as .gif, or .png
or Java programs.
|
|
Configuration |
Security |
|
Related Articles
| 