Database Physical File

Chapter 19. Example of an Interactive Application

This chapter illustrates some common workstation applications and their I coding.

The application program presented in this chapter consists of four mo module illustrates a common use for WORKSTN files. The first module (CU provides the main menu for the program. Based' selecontheion, userit calls the procedure in the appropriate module which provides the function requ

Each

module uses a WORKSTN

file to

prompt the user

for

input

and dis

mation

on the screen. Each

module,

except for the

main

module

CUSMAIN,

uses a logical file whichviewpresentsof thea master database file. This vie consists of only the fields of the master file which the module re essing.

Note: Each module, except CUSMAIN, can be compiled as a free standing program, that is, they can each be used as an independent pr

Table

 

29.

Description of Each Module in the Interactive Application Example

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Module

 

 

 

 

 

 

Description

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

“Main

Menu Inquiry”

on

 

An example of a basic

 

menu

 

inquiry

program

that

page

 

346

 

 

 

 

uses

a

WORKSTN

file to

 

display

menu

choices

 

 

 

 

 

 

 

 

and

 

accept input.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

“File

Maintenance”

on

page

349An

example

of

a

maintenance

program

which

 

 

 

 

 

 

 

 

allows customer records in a master file to be

 

 

 

 

 

 

 

updated,

deleted,

added,

and

displayed.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

“Search

by

Zip

Code”

on

An

example

program

which

uses

WORKSTN

 

 

 

page

 

358

 

 

 

 

subfile

processing

to

display

all matched records

 

 

 

 

 

 

 

for a specified zip code.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

“Search

and

Inquiry

by

 

Name”An example

program

which

uses

WORKSTN

 

 

 

on page 364

 

 

 

 

subfile

processing

to display all matched records

 

 

 

 

 

 

 

for

a

specified

customer name, and then allows t

 

 

 

 

 

 

 

user

to

 

select

a

record

from

the

subfile

to d

 

 

 

 

 

 

 

the

complete

customer

information.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Database Physical File

Figure 169 on page 346 shows the data description specifications (DDS) master customer file. This file contains important information for each such as name, address, account balance, and customer number. Every mo which requires customer information uses this database file (or a l

Copyright IBM Corp. 1994, 1999

345

Page 368 Page 370
Page 369
Image 369
IBM AS/400 manual Example of an Interactive Application, Database Physical File, 345
Page 368 Page 370

AS/400 specifications

The IBM AS/400, now known as the IBM iSeries, is a midrange computer system that has been a cornerstone of enterprise computing since its introduction in 1988. Designed to provide a robust platform for business applications, the AS/400 is celebrated for its reliability, scalability, and integrated database capabilities.

One of the key features of the AS/400 is its Integrated Operating Environment, which blends hardware and software resources seamlessly. This integration allows businesses to execute diverse workloads, ranging from traditional applications to modern web-based services, all on a single platform. The operating system, OS/400 (now IBM i), offers a rich set of APIs and tools for developers, simplifying application development and management.

Another standout characteristic of the AS/400 is its built-in database, DB2 for i. This powerful relational database management system allows for efficient data handling and provides advanced features such as support for SQL, XML, and JSON, making it easier for businesses to manage their data and integrate it with other systems. The database's tight integration with the operating system enables high performance and security.

In terms of scalability, the AS/400 can accommodate small businesses as well as large enterprises, with the ability to support hundreds of users simultaneously. Its architecture allows for easy upgrades in hardware, meaning that organizations can scale their systems without replacing the entire infrastructure.

Security is another critical attribute of the AS/400. With a sophisticated security model, it offers built-in user authentication, access control, encryption, and auditing capabilities to protect data and applications from unauthorized access.

The AS/400 also supports multiple programming languages, including RPG, COBOL, Java, and PHP, giving organizations the flexibility to choose the development tools that best fit their needs. This diversity helps maintain legacy applications while also developing new ones that leverage modern technologies.

Moreover, the platform supports both traditional green-screen interfaces and modern graphical user interfaces, allowing organizations to transition smoothly into contemporary user experience paradigms.

Overall, the IBM AS/400 stands out as a resilient, flexible, and secure computing platform that enables organizations to effectively manage their business operations, streamline processes, and adapt to changing market demands. Its unique combination of integrated features and capabilities ensures that it remains relevant in today's fast-paced technology landscape.
Top Page Image Contents