Re: FW: data mapping error

["George Amaya" <George.Amaya@xxxxxxxxxxxxx>]

If a field is null and you are selecting that field into an RPG defined
field, you must specify the NullInd.

SELECT field 
INTO :hostField :nullind
FROM table.

The nullind field must defined as 10I 0.  If the value in the nullind
field is -1, then the field is null.

When you go into the file and blank out the fields, you are setting the
values from null to blank.

George

>>> awawrzaszek@xxxxxxxxxxxxxxx 01/23/04 1:28 PM >>>
 
 
 
    I have an ILE program that is reading files that were created with a
SQL script.  Some of the fields in the file are null-capable.  I have
compiled the program with *USRCTL on the allow null value field.   This
USUALLY takes care of getting any errors for null fields.   However once
in a while I will get a data mapping error within an ILE program while
reading a particular file.   All I do is go into that file & record it
is bombing on and blank through any of the blank fields.   Then
everything is fine.   Why does it bomb out if I have used *USRCTL?
What can I do to prevent this?
 
Thankyou!!
 
Angela Wawrzaszek 
Programmer/Analyst 
Nucor Steel Auburn 
wawrzaszek@xxxxxxxxxxxxxxx 
(315) 258-4205 
 
_______________________________________________
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.