embedded

 

SQL

statements.

Contains

examples

of tions

 

(DDS)

 

keywords, system-supplied

formats,

 

 

 

SQL

statements

and

a

 

description

of

the intereturnactive codes,

file

transfer

support,

 

and

program

 

SQL function. Describes common concepts and

 

 

examples.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

rules

for

 

using

SQL

 

statements

 

in

 

COBOL/400,

¹

 

IDDU

Use, SC41-5704-00,

describes

how

 

to

use

 

 

 

ILE

COBOL,

 

PL/I,

ILE

 

C,

FORTRAN/400,

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

the

AS/400

interactive

data

definition

 

utility

(IDD

 

RPG/400,

ILE

RPG,

and

REXX.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

to describe data dictionaries, files,

and

record

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

¹

DB2

UDB

for

 

AS/400

SQL

Reference,

 

 

 

 

 

 

the

system. Includes:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SC41-5612-02, provides information about

how

to

 

An

 

introduction

 

to

computer

 

file

 

and

 

data

 

defi-

 

use

Structured

 

Query

Language

DB2

UDB

for

 

 

 

nition

concepts

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AS/400

statements

and

gives

details

about the

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

– An introduction to the use of

 

IDDU

to

descri

 

proper use of the statements. Examples

of

 

 

 

 

 

state-

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ments include syntax diagrams, parameters, and

 

the

data

used

in

queries

and

 

documents

 

 

 

definitions.

A

 

list

 

of

SQL

limits

and a

description

of

 

 

 

 

 

tasks

related

to

creating,

main-

 

the

SQL

communication

area

(SQLCA)

and

SQL

 

 

 

 

Representative

 

 

 

 

 

 

taining,

 

and

using

data

dictionaries,

files, rec

 

descriptor

area

(SQLDA)

are

 

also

provided.

 

 

 

 

 

 

 

 

 

formats,

and

 

fields

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

¹ DDS Reference, SC41-5712-01, provides detailed

 

 

– Advanced information about using IDDU to work

 

descriptions

for

coding

the

 

data

description

specifi-

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

with files created on other systems and inform

 

cations (DDS) for file that can be described tion

about

error

recovery

 

and

 

problem

pre-

 

externally.

These

 

files

are

 

physical,

logical,

 

display,

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

print, and intersystem communication function (ICF)

vention.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

files.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

¹

 

ILE

 

C

for

 

AS/400

 

Programmer's

,Guide

 

 

 

 

 

 

 

 

¹ Distributed Data Management, SC41-5307-00, pro-

 

 

 

 

SC09-2712-01, provides information on how to

 

 

 

 

 

 

 

develop applications using the ILE

 

C

for

AS/400

 

vides

information

about

remote

file

processing.

It

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

describes

how

 

to

define

a

 

remote

file

to

language. It includes information about creating,

 

 

 

 

OS/400

dis-

debugging programs. It also includes

 

tributed

data

 

management

(DDM),

how

to

 

 

 

running

and

 

 

 

create

a

 

 

 

considerations

for

interlanguage

 

 

 

 

DDM

file,

 

what

 

file

 

utilities

 

are

 

 

 

 

 

programming

 

 

 

 

 

 

 

 

supported

through

and

procedure

 

calls,

locales,

handling

 

 

DDM,

and

 

the

requirements

of

 

OS/400

DDM

as

 

 

program

 

 

 

 

 

 

 

exceptions,

database,

 

externally

described

and

 

related

to

other

systems.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

device files. Some performance tips are also

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

¹

Experience

RPG

 

IV

 

Multimedia , Tutorial

 

 

 

 

described. An appendix includes information on

 

 

SK2T-2700,

is

an

 

interactive

self-study

program

 

migrating

source

 

code

from

EPMC/400or System

 

 

 

 

explaining

the

 

differences

between

RPG

 

 

 

C/400

to

ILE C.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

III

and

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

RPG

IV

and

how

to

 

work

within

the

new

ILE

 

envi-

COBOL

for

AS/400

Programmer's

Guide,

 

 

 

 

 

 

 

ronment.

An

 

accompanying

workbook

provides

 

¹

 

ILE

 

 

 

 

 

 

 

 

 

 

 

 

SC09-2540-01, provides information about how to

 

 

 

additional

 

exercises

and

doubles

as

a

 

 

 

 

 

 

 

reference

 

 

 

 

 

bind,

run,

debug,

and

 

maintain

ILE

 

upon

completion

 

of

the

tutorial.

ILE

RPG

 

 

 

write, compile,

 

 

 

code

 

 

 

programs

on

the

AS/400

system.

 

It

pro-

 

 

 

examples

are

shipped

with

the

tutorial

and

 

COBOL

 

 

 

 

 

 

run

 

programming

 

information

on

 

how

 

to

 

call

other

 

directly

on

the

AS/400.

 

 

 

 

 

 

 

 

 

 

 

 

vides

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ILE COBOL and non-ILE COBOL

programs,

 

share

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

¹ GDDM Programming Guide, SC41-0536-00, pro-

 

 

 

 

data with other programs, use pointers, and handle

 

vides

information

about

using

 

OS/400

graphical

 

exceptions. It also describes how to perform

 

data

display

manager

(GDDM)

to

write

 

 

 

 

input/output operations on externally attached

 

 

graphics

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

devices, database files, display files, and ICF

 

application programs. Includes many example pro-

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

grams

and

 

information

 

to

help

 

users

understand

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

how

the

 

product

fits

into

data

 

 

 

 

¹

 

ILE Concepts, SC41-5606-03, explains concepts

 

 

 

 

 

 

processing

 

systems.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

and terminology pertaining to the Integrated Lan-

¹

GDDM

Reference,

SC41-3718-00,

provides

informa-

 

 

guage Environment (ILE) architecture of the OS/400

 

tion

about

using

OS/400

graphical

data

 

 

 

 

licensed program. Topics covered include

creating

 

display

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

manager

(GDDM)

to

write

graphics

 

application

 

modules,

binding,

 

running

 

programs,

debugging

pro-

 

 

 

pro-

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

grams.

This manual

provides

detailed

 

 

 

 

 

grams,

and

 

handling

exceptions.

 

 

 

 

 

 

 

 

 

 

 

descriptions

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

of

all

graphics

routines

available

in

GDDM.

¹

Also

 

RPG

for

AS/400

Reference, SC09-2508-02,

 

 

 

 

 

 

 

 

 

provides

 

information

 

about

high-level

 

 

 

 

ILE

 

 

 

 

 

 

 

 

 

 

 

 

language

 

provides

information

about

the

ILE

 

RPG

for

AS/400

 

interfaces

to

 

GDDM.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

programming language. This manual describes,

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

¹

ICF

Programming ,

 

SC41-5442-00,

provides

informa-

 

position by position and keyword by

keyword,

the

 

tion

needed

to

write

application

programs

 

 

valid

 

entries

for

all

RPG

IV

 

specifications,

and

 

that

use

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AS/400 communications and the OS/400 inter-

 

 

 

vides a detailed description of

all

 

the

operatio

 

system

communications

function

(OS/400-ICF).

Also

 

codes and built-in functions. This

manual

also

 

con-

 

contains

information

on

data

description

 

 

 

tains information on the RPG logic

cycle,

arrays a

 

specifica-

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

tables,

editing

 

functions,

and

 

indicators.

 

 

 

440

ILE

RPG

 

for

AS/400

Programmer's

 

Guide

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Page 464
Image 464
IBM AS/400 manual Iddu

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.