Re: SQL...

[Pete Hall <pbhall@xxxxxxxxxx>]

At 01:57 11/16/1999 , Victor Rodrigue wrote:
>I have a physical file field with specific values specified. when i try to
>write any other value using DFU or RPG it gives me a
>run time error. But when i try the same using native SQL. the database file
>is getting updated.
>Any ideas why DB2/400 is allowing this without giving an error.
>regards,


Values may be specified in DDS, and are imported by SEU when you use it to 
build a display file, as well as by DFU at design time. OS400 will check 
for valid values based on the display file DDS. It does not do this 
validation when data is added to or updated in a physical file.


Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---