Re: Question about NULLS.

You didn't mention the program language...  you need to use the null
indicators and change the null indicator to off for the field

In RPG:  eval %nullind(field) = *off


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"Those who would give up essential Liberty,
  to purchase a little temporary Safety,
  deserve neither Liberty nor Safety."

     - The Papers of Ben Franklin

-----Original Message-----
From: Hatzenbeler, Tim <thatzenbeler@clinitech.net>
To: 'MIDRANGE-L@midrange.com' <MIDRANGE-L@midrange.com>
Date: Tuesday, July 11, 2000 7:43 PM
Subject: Question about NULLS.


>I have a simple question that has me puzzled....
>
>I ftp'd a Comma delimited file to a PF on the 400.
>
>and then I used the cpyfrmimpf command into another PF that has several 50
>byte (null capable) fields to snag this data.
>
>Then I run a program over the 2nd PF, so I can change one of the fields.
>
>Now here is the question... If there is data in the field, I can change it
>without a problem... But if the field is Blank, I can't place a new value
>into that field.  It just stays blank...
>
>Any ideas how to change the  value of a null capable field that starts out
>Null...
>
>TIA, tim
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
david@midrange.com
>+---
>

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