Specify Record Selection

This is an optional step. If no conditions are specified for record display, all records in the database file member are printed.

 

 

 

 

à

ð

 

 

Specify Record Selection

Type choices, press the Enter key.

Tests: EQ, NE, LE, GE, LT, GT, RANGE

AND/OR

Field

Test

 

Value (Field, number, or 'character')

 

 

 

F4 for list

 

 

F4 for list

 

AND

PRODCT

NE

 

'Wrong one'

 

PRODCT

 

NE

 

'Bad'

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

F3=Exit

F4=Prompt

F5=Refresh

F12=Cancel

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

á

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ñ

 

 

 

 

 

 

 

 

 

 

You can specifyup to

five

logical

conditions to select records. The Print For

Utility compares the content of

the specified field of each reco

value, and prints

only

those records

whose

test

results

are

true.

The following table

describes

the

columns

in

the

Specify

Record

Sele

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Column

Description

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AND/OR

AND and

OR are

the only values that you canAND/ORspecify

in the

 

 

column. If

this

column

is

 

left

blank

and

the

other

 

three

column

 

 

Test

 

and

Value)

in

the

same

line

are

specified,

 

AND

is

assum

 

 

If

AND

and

OR

are

specified

together,

AND

is

evaluated

bef

 

 

For example,

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

YEAR

EQ

 

199ð

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AND

 

MONTH

RANGE

11 12

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

OR

 

 

YEAR

EQ

 

1991

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AND

 

MONTH

RANGE

1 2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

means the period from November

1990

through

February

1991.

Field

Any

fields

of

the

 

input

record

format

in

the

input

database

 

 

specified.

You

can

list

 

all

fields

in

the database

file

by

 

 

key

after

positioning

the

cursor

in

this

column.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Chapter 10. Work with PFD Definitions179

Page 198 Page 200
Page 199
Image 199
IBM AS/400 manual Specify Record Selection, You can specifyup to, Five
Page 198 Page 200

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