Re: RPG and Null Capable Files

["David Morris" <dmorris@xxxxxxxxxxxxx>]

Bill,

The only solution I have found in this case is to use SQL.  You will have to 
code an SQLDA in this case because the compiler won't let you select into 
a single large field.  You also have to allocate space for the null indicator.

David Morris

>>> "Reger, Bill" <breger@levitz.com> 08/02/99 09:25AM >>>
I have an application that uses a "program described" file.  However,
whenever I OVRDBF to a file that has null data, I receive "data mapping
errors", specifically for "unexpected null value encountered".

According to both the IBM RPG and RPG IV manuals, accessing null-capable
files with "program-described" files will always result in data mapping
errors.  Does anyone know of any way around this restriction?  I can't use
an "externally-described" file for this application because of record name
problems, even if LVLCHK(*NO) is specified.

Is anyone at IBM listening?  I'd really like to see this changed in a
release or fixed via a PTF.  Thanks in advance for your comments and
suggestions,

William K. Reger
Senior Project Manager
Levitz Furniture Corporation
Phone:  (561) 994-5114
E-mail:  breger@levitz.com 


* The Sender's Mail Server is Running An Evaluation Copy of Guinevere.
* Guinevere provides antivirus protection for Groupwise.
* For more information and/or to download your own 30 day 
* evaluation copy, visit http://www.indecon.com/guinevere

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---END