Working with nulls in RPGLE

We are in the process of externalizing our I/O from our RPGLE Programs. We are also using more and more Forge in Keys that may contain nulls.

Is there a way to bring the row back and have a flag or indicator on an external data structure to handle the nulls? I am currently creating individual work fields for the null indicators.

Also, are there any plans to allow the RPG Programs to receive a Cursor that was created in a Stored Procedure?

With nulls, you can still fetch into a data structure. Simply specify the data structure followed by another data structure (array) that will hold the values of the null indicators. Define same number of elements in this array as there are fields in the data structure -- in the case of the example below, this is 12.

Example:

* CustomerRow -- an externally described data structure based on SQL view allCusts
d customerRow e ds extname(allCusts) qualified

* Null indicator arrays
d customerNIArr s 5i 0 dim(12)

EXEC SQL
FETCH custListCursor INTO :customerRow :customerNIArr;

Dig Deeper on DB2 UDB (universal databases)

Enhancing RPG with external SQL stored procedures Registering an external SQL stored procedure and leveraging RPG with your creation allows for increased flexibility in dealing with numerous types of data.

Introduction to SQLRPGLE on IBM i: Making a report Using RPG ILE with embedded SQL can be a fast way to make database reports on the IBM i. Joe Pluta shares the code of his first SQLRPGLE program.

When to use an Embedded ODBMS ODBMS is referred to as an "embedded" object database. An embedded object database system is one whose database code executes within the application. That is, the code for the database runs in the same address space as the application. An application that uses an embedded database is monolithic; it is not built along client/server architectural lines.

IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 2 Answer ten sample questions about tables from the IBM DB2 9 Fundamentals certification exam study guide to check your level of DB2 knowledge, in Part 2 of the DB2 quiz series.

Defining Your Object Model with JPA In the perfect world, your object model would map seamlessly to your database schema. Most organizations however, have database naming standards, requirements for how relationships are modeled and columns that all tables must have.

Create one text file that contains all the stored procedures and triggers in a database This script will send the contents of all the stored procedures, functions and triggers in a database to a text file, eliminating the need to go through every script to find what you're looking for.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our AS/400 experts

View all AS/400 questions and answers

Working with nulls in RPGLE

ISeries expert Kent Milligan offers help for working with nulls in RPGLE.

Dig Deeper on DB2 UDB (universal databases)

Related Q&A from Kent Milligan

SQL server error message -321

Choose which column names are returned via ODBC when working with DB2 files

Developing tables in a parent-child relationship in DB2

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Refresh your data center cooling lexicon

Comparing Linux distributions: Red Hat vs. Ubuntu

Get eco-friendly with LEED data center certification

Dig Deeper on DB2 UDB (universal databases)

Related Q&A from Kent Milligan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.