RE: Insert of null-values with RPG, SQL or DFU

Hi Alex,
I think, Allow null values (ALWNULL) option should be set to *USRCTL before 
compile.

-----Original Message-----
From: Alexander Brand [mailto:Brand@ireks.com]
Sent: Wednesday, September 13, 2000 6:05 PM
To: <
Subject: Insert of null-values with RPG, SQL or DFU


We found a different behavior between SQL/400 and RPG. 
When you insert a row into a table without specifying values for 
nulls-allowed columns with RPG it inserts default values. This value
is not null, in contrast to the SQL (ISO) defined behavior. 

How can you "teach" RPG to behave like standard SQL in general,
avoiding to set the null-indicator for each single column?

alex



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