Using Externally Described WORKSTN Files

 

 

 

 

 

 

 

 

 

Customer Name Search

 

 

 

 

 

Search Code _______

 

 

 

 

 

Number Name

Address

City

State

XXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

XXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX XX

ˆXXXX

XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX

XXXXXXXXXXXXXXXXXXXX

XX

 

˜

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Figure

166.

Subfile Display

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

To use

a

 

subfile

for

a display device file in an

RPG

 

program,

you m

SFILE

keyword

on

a

file

description

specification

for

the

 

 

WORKSTN

file.

of

the SFILE

keyword

isrecordSFILE( format :RECNOname

field

name).

The

 

 

 

 

 

WORKSTN

file

must

be

an

externally-described file (E

in

position 22).

You

must

specify

for

the

SFILE

keyword

the

name

of

the

subfile

reco

the control-record format) and the

name

of

the

field

that

contains

the

number

to

be

used

in

processing

the

subfile.

 

 

 

 

 

 

 

 

 

In

an

RPG

 

program,

relative

record

number

processing

is

defined

as

pa

SFILE

definition.

The

SFILE definition

implies

a

full-procedural

update

fil

for the subfile. Therefore, the file operations that are valid for

dependent

on

the definition

of the

main WORKSTN file. That is,

the WORK

file can

be

defined as a

primary

file or a full-procedural

file.

Use the CHAIN, READC, UPDATE, or WRITE operation codes with the subfile record format to transfer data between the program and the subfile. WRITE, or EXFMT operation codes with the subfile control-record format t data between the program and the display device or to process subf ations.

Subfile processing

follows

the

rules for relative-record-number processing.

RPG

program places the relative-record number of any record retrieved

READC

operation into

the field

named

in

the second position of the SFIL

keyword. This field is also

used

to

specify the record number that

uses

for

WRITE operation

to

the subfile or for output operations tha

RECNO

field name specified for the

SFILE keyword

must be

defined

as

with

zero

decimal

positions.

The

field

must have

enough

positions

to co

largest record number for the file. (See the DDSSFLSIZ keyword in the Reference.) The WRITE operation code and the ADD specification on the

336 ILE RPG for AS/400 Programmer's Guide

Page 360
Image 360
IBM AS/400 manual Field, Sfile

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.