Convert to DB (QtmhCvtDB) API

Parameters

Required Parameter Group:

1

Qualified database file name

Input

Char(20)

2

Input string

Input

Char(*)

3

Length of input string

Input

Binary(4)

4

Response variable

Output

Char(*)

5

Length of response variable

Input

Binary(4)

6

Length of response available

Output

Binary(4)

7

Response code

Output

Binary(4)

8

Error Code

I/O

Char(*)

The QtmhCvtDB API provides an interface for CGI programs to parse CGI input, defined as a series of keywords and their values, into a buffer which is formatted according to a DDS file specification. CGI input data, which comes to the CGI program as character data, will be converted by the QtmhCvtDB API to the data type defined for the keyword by the corresponding field name in the input DDS file. AS/400 language statements, such as the ILE C #pragma mapinc statement, provide the ability to map the returned structure with field names defined in the DDS file. See the appropriate language user’s guide for details.

Note that the QtmhCvtDB API is not allowed in CGI mode %%BINARY%%.

The following DDS field types are handled:

AAlphanumeric (see note 1)

PPacked Decimal (see note 2)

SZoned Decimal

FFloating Point

TTime

LDate

ZTimestamp

BBinary (see note 3)

ODBCS

These DDS field types are not handled:

HHexadecimal (see note 4)

GGraphic (see note 5)

JDBCS (see note 5)

EDBCS (see note 5)

Notes:

1.The VARLEN keyword is not supported.

2.When using a packed decimal field, the #pragma mapinc() must use _P the option, to create a packed structure.

30Web Programming Guide V4R5

Page 40
Image 40
IBM AS/400E manual Convert to DB QtmhCvtDB API, Dbcs

AS/400E specifications

The IBM AS/400E, now more commonly known as IBM i, is a robust and versatile midrange server that has been designed to provide a comprehensive computing solution for businesses of all sizes. First introduced in the late 1980s, the AS/400 series has undergone multiple enhancements and rebranding, with the AS/400E being one of the notable iterations. This powerful platform is closely associated with IBM's commitment to reliability, scalability, and integrated business solutions.

One of the main features of the AS/400E is its highly integrated architecture that combines hardware and software into a cohesive system. This integration allows for seamless operations, reducing the complexity typically associated with managing disparate systems. The system is powered by IBM's proprietary OS/400 operating system, which has evolved into IBM i, featuring advanced capabilities like object-oriented programming, integrated database management, and security features that are essential for enterprise environments.

A key characteristic of the AS/400E is its robust database support, primarily through the use of DB2 for i. This integrated database management system enables efficient data handling and retrieval, facilitating real-time business analytics and reporting. Furthermore, the platform supports a variety of programming languages, including RPG, COBOL, and Java, making it flexible for developers who require diverse tools for application development.

The AS/400E is also known for its exceptional reliability and uptime, making it a preferred choice for critical business applications in industries such as finance, healthcare, and manufacturing. This reliability is backed by advanced error detection and correction mechanisms, as well as redundancy features that help prevent data loss and minimize downtime.

In terms of scalability, the AS/400E can effortlessly expand to accommodate growing business demands. Organizations can increase processing power by adding more resources without significant disruption. This scalability, combined with the system’s built-in virtualization capabilities, allows businesses to optimize resource usage and streamline operations.

Security is another defining feature of the AS/400E. The platform incorporates various layers of security measures, including user authentication, encryption, and comprehensive auditing capabilities, ensuring that sensitive business data is protected against unauthorized access.

Overall, the IBM AS/400E remains a powerful tool in the enterprise computing landscape, providing businesses with an integrated, reliable, and secure solution for their technological needs. Its enduring popularity is a testament to its capability to evolve with changing business requirements while maintaining its core attributes of high performance and stability.