ColumnDescription

Value

One of the following can be specified:

ŸNumeric constant

This

is

possible when

the

field

is

numeric

type data. A n

constant

can be from 1 to 31 digits long, and can contain

following

characters:

 

 

 

 

 

–

Digits

(0

through

9)

 

 

 

 

–

A

plus

sign

(+) or

minus

sign

(-)

at the

beginning

 

–

A period.

 

 

 

 

 

 

Floating point expressions are not allowed, although floating data is allowed.

Examples:

 

 

Correct

Incorrect

Reason

+12.5

+12.5.ð

2 periods are contained.

-2ð

2ð-

- does not come first

.ðððð5

.ððððA5

“A” is not numeric

123456

1.23456E+5

Floating point expression

ŸCharacter constant like 'ABC'

This is possible

when

the field is character type

data.

maximum

for a

character length is the same as the length

Value

column. A

character constant is simply characters enclos

in

apostrophes

(for example, 'xxx'). If

a

character

consta

an

apostrophe,

it

must

be entered as

two

apostrophes. For

example, if you want to print records that list the stree as Granger's Circle, type the constant as 'Granger''s Circle'.

Examples:

 

 

 

 

 

 

 

 

Correct

Incorrect

Reason

 

 

 

 

'ABCDEF'

ABCDEF

 

No apostrophe, recog-

 

 

 

 

 

 

 

nized as a field name.

 

 

'abc def'

'abc def

 

Last apostrophe is

 

 

 

 

 

 

 

 

missing.

 

 

 

 

'Tom''s bed' 'Tom's bed'

Double apostrophe is

 

 

 

 

 

 

 

 

required.

 

 

 

 

'123456'

123456

 

No apostrophe, recog-

 

 

 

 

 

 

 

nized as a numeric

 

 

 

 

 

 

 

 

constant.

 

 

 

 

Ÿ A

field name

in the

database

file member

 

 

Any

fields

in

the

input database file

member can

be

spec

its data type must match with

the data Fieldtype specified

column. For

example,

if

the data

type

is numeric,

you

must

it as numeric data. If it is character data, you must s character data. Comparison of SBCS type and DBCS type is allowed.

You can select a field name from the list of field names database file by pressing F4.

If a field and a value are not of the same length, the Pr handles the shorter one as if it has the same length as th as follows:

Ÿ 0's are added at the left of numeric values.

ŸSBCS blanks are added at the right of character values.

Chapter 10. Work with PFD Definitions181

Page 200 Page 202
Page 201
Image 201
IBM AS/400 manual ColumnDescription, Correct Incorrect Reason, Value
Page 200 Page 202

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