Hi. I am having a problem updating a file on our AS/400. I am connecting to our AS/400 via
JDBC (V3R2 400). My problem is, in my application, I have numerous fields that the user can enter information into. The user is not required to enter info into every field( ie.. not every vendor has a minimum order amount). Right now, I am taking the value of whatever is in the fields and updating the 400 with that info. However, if the user does not key something into a field (like minimum order amount) then I get an error message "SQL0407 - Null value is not allowed for field PCVMIN in table PCVEND".
I want the user to not have to key information into this field, and be able to update the 400 without getting this error message!
What do I need to do? (Min order is a numeric field).
Any help is greatly appreciated. (I am using VA for
Java 3.5.3 if that makes any difference).
Thanks in advance!