Perhaps a read trigger?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve Richter
Sent: Saturday, April 26, 2014 5:45 AM
To: Midrange Systems Technical Discussion
Subject: how to increase field size without increasing the field size

We have an order header file that contains a PONUM field. Char(15).
But as the business expands to take on new customers sending in orders with
a PO number the 15 char limit might not be enough. The EDI 850 specs I look
at say po number can be 1 - 22 characters.

The programmer who handles the RPG code with traditional F spec files does
not want to increase the field size and recompile all of the programs.

I am thinking of a scheme where I put a special key in the char(15) ponum
field when the po number is longer than 15 characters. That value being the
key to another file that contains the actual value.

Are there any system level, DB2 features that can be used to solve this

Ideal would be something where code written using RPG SQL would function
without any code changes.

d vPonum s 30a

exec sql
select a.ponum, a.shipname
into :vPonum, :vShipName
from dwhpf30c a
where a.ordnum = :inOrdnum ;

In the above code snippet, dwhpf30c is the order header. DWHPF30C is a CRTPF
created file and PONUM is a CHAR(15) field. When the value of the PONUM
field is actually more than 15 characters I need some logic somewhere that
will return the full value from where it is stored into the char(30) program
variable vPonum.

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page