Select Database File

 

 

 

 

 

 

 

 

 

 

 

 

 

 

à

 

 

 

 

 

ð

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Select Database File

 

 

 

Library

. . . . . . . . . :

 

QGPL

 

 

 

Position to

 

 

Starting characters

 

 

 

Type option, press Enter.

 

 

 

 

 

 

 

 

 

1=Select

 

 

 

 

 

 

 

 

 

Opt

File

 

Text

 

 

 

 

 

 

 

 

 

 

QAAPFILE

Symbol set symbol definitions logical file

 

 

 

 

 

 

QAAPFILE$

Symbol set small symbol definitions

 

 

 

 

 

 

QAAPFILE#

Symbol set medium symbol definitions

 

 

 

 

 

 

QAAPFILE@

Symbol set large symbol definitions

 

 

 

 

 

 

QAFCGRPH

SAMPLE GDF

 

 

 

1

 

QAFCPFDDTA

SAMPLE DATABASE FILE FOR PFU

 

 

 

 

 

 

QAFCTUTDBF

SAMPLE DATABASE FILE FOR TUTORIAL

 

 

 

 

 

 

QAFCTUTOR

AFPU TUTORIAL TEXT

 

 

 

 

 

 

QAFCTUTPFD

AFP Utilities for AS/4ðð tutorial PFD file

 

 

 

 

 

 

QAFCTUTXMP

Sample PFD File

 

 

 

 

 

 

QAFCXMPAI2

SAMPLE DATABASE FILE (AIAG_B2)

 

 

 

F5=Refresh

F12=Cancel

 

 

 

More...

 

 

 

 

 

 

 

 

 

 

á

 

 

 

 

 

ñ

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

On this display, the names and the descriptions of database files library are listed.

The following table explains each field of the Select Database File

Field Name

Description

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Library

The

name

of the library in which the database files resid

Position to

This

prompt

is

 

used

for

quick

repositioning

of

the

list,

not

 

subset

of

the

list.

 

Choose

one

of

the

following:

 

 

 

 

 

*TOP

 

To

go

to

the

top

of

the

list.

 

 

 

 

 

 

 

*BOT

 

To

go

to

the

bottom of

the

list.

 

 

 

 

 

 

name

or

partial

name

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Specifies

the

name

or

partial

name for positioning

the

 

 

 

The

list

 

is

positioned

to

the

first

name

beginning

wit

 

 

 

string

specified.

 

 

 

 

 

 

 

 

 

 

 

1=Select

To

select

a database file from the list.

 

 

 

 

 

Opt

Specify 1

(Select)Optin columnthe

beside the database file to sel

File

Shows

the

names

of

the database

files

that

reside

in the

 

specified.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Text

Shows

the

description

text

of

the

database

files.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Specify 1 inOptthecolumn beside the database file to select, and pre key.

When you specify the database file (and the record format, if n display goes to “Design Record Layout” on page 158.

Chapter 10. Work with PFD Definitions155

Page 175
Image 175
IBM AS/400 manual Select Database File, Opt File Text

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.