Example of Source Conversion

Converting Source Members

with

 

Embedded

SQL

 

 

 

 

 

 

 

 

 

 

 

 

When converting code that contains embedded

SQL and the SQL code is

c

tinued

over

 

multiple

lines, the following will occur:

 

 

 

 

 

 

 

¹

If

there

are

continuation

lines

but

column

74

is

blank,

the line is

 

to

the

ILE

member.

 

 

 

 

 

 

 

 

 

 

 

 

 

Note:

This

could

be a problem if column 74

happens

to

be

a

blank

c

 

 

inside

a character

string.

 

 

 

 

 

 

 

 

 

 

¹

If

column

74

is

not

blank,

all of

the

SQL

code

from

that

line

to

th

 

will

be

concatenated

and

copied

to the ILE member

filling

up

all

80

this occurs:

– Any

comments in column 75

on,

will

be

ignored.

 

– Any embedded comment lines

(C*)

will

be

copied to the

ILE member

the

concatenated code

is

copied.

 

 

 

– Problems could arise if

DBCS literals

are split.

 

If you do not want this

concatenation

and

re-formatting

to occur, e

column

74 is blank.

 

 

 

 

 

 

Inserting Specification Templates

Because the source specifications for RPG IV are new, you may want specification templates inserted into the converted source. To have te inserted, specify INSRTPL(*YES) on the CVTRPGSRC command. The default is INSRTPL(*NO).

Converting Source from

a Data

File

 

 

 

 

 

 

 

The

Conversion

Aid

will

convert

source from a data file. Because data

ally

do

not

have

sequence

numbers, the

minimum record

length

of the fi

placing the converted output is 80 characters. (See Figure 193 on page

recommended record length

is

100 characters for a data file.

Note:

If

your data

file

has

sequence

numbers, you

should

remove them

 

running

the

Conversion

Aid.

 

 

 

 

Example of Source Conversion

The

example shows a sample RPG

III

source member

which is to be c

RPG

IV. Figure 194 on page 391

shows

the source of

the RPG III ve

390 ILE RPG for AS/400 Programmer's Guide

Page 414
Image 414
IBM AS/400 manual Inserting Specification Templates, Data, Example of Source Conversion, Converting Source from

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.