RE: Viewing the resultant SQL in an RPG program

Vernon,

From the RPG Reference manual:

*HIVAL
Character, graphic, or UCS-2 fields: The highest collating character for the system (hexadecimal FFs). Numeric fields: The maximum value allowed for the corresponding field (with a positive sign if applicable). Float fields: *HIVAL for 4-byte float = 3.402 823 5E38 |(/x'7F7FFFFF'/) *HIVAL for 8-byte float = 1.797 693 134 862 315 E308 |(/x'7FEFFFFFFFFFFFFF'/)
Date, time and timestamp fields: See Date Data Type, Time Data Type and Timestamp Data Type for *HIVAL values for date, time, and timestamp data.
*LOVAL
Character, graphic, or UCS-2 fields: The lowest collating character for the system (hexadecimal zeros). Numeric fields: The minimum value allowed (with a negative sign if applicable).
Float fields: *LOVAL for 4-byte float = -3.402 823 5E38 (/x'FF7FFFFF'/) *LOVAL for 8-byte float = -1.797 693 134 862 315 E308 (/x'FFEFFFFFFFFFFFFF'/)
Date, time and timestamp fields: See Date Data Type, Time Data Type and Timestamp Data Type for *LOVAL values for date, time, and timestamp data.
Michael

I thought *LOVAL for character fields was x'40404040...' for the
length of the field - it ought to be in the RPG Reference. It might be
x'00000000...' for hex fields.

But then I'm not fully awake, so don't know for sure.

-------------- Original message -------------- From: "Joe Pluta"
<joepluta@xxxxxxxxxxxxxxxxx>

From: Pete Helgren

I'll do some trial and error testing of the statement using
different variables and commenting portions of the statement and see
if I can figure out why the SQL is not returning records like I
expect. The *LOVAL/*HIVAL technique is a good one, I just need to
know what to submit in the SQL for *LOVAL and *HIVAL when the field
is a 10 character numeric.

Did you try x'00000000000000000000' and x' FFFFFFFFFFFFFFFFFFFF'?

Joe

-- This is the RPG programming on the AS400 / iSeries (RPG400-L)
mailing list To post a message email:
RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options, visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l or email:
RPG400-L-request@xxxxxxxxxxxx Before
posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.