• Subject: Re: SQL...
  • From: Pete Hall <pbhall@xxxxxxxxxx>
  • Date: Tue, 16 Nov 1999 19:48:45 -0600

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.

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
| 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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.