RE: Compile SQLRPGLE with ALWNULL

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

Sudha, 
I believe that you can only set the null value for a database field.  Making
a copy in a data structure will not work.  The field must directly come from
a database file.  If I remember properly, it must be an update capable
database file.  This is a huge limitation, and if I knew who to write at
IBM, I would complain bitterly.  I got extremely frustrated the last time I
tried to use null capable fields with embedded SQL.

As for another way, I have not personally tried, but perhaps SQL CLI will
allow you to set the null value.

Buck 

> -----Original Message-----
> From: Sudha Ramanujan 
> Sent: Friday, April 27, 2001 4:43 PM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      RE: Compile SQLRPGLE with ALWNULL
> 
> I have all the result set fields defined in a dds with ALWNULL to make
> them null capable.  I  use extname to get the field formats into the
> SQLRPGLE.  I use this structure for my result set to return to Java
> program.  I create my stored procedure with 'Create procedure' in embedded
> sql. (since the input parms/output parms other than result set)  This
> works very well but for this new 'Null' value problem.  Is there any other
> way to do this?  
> 
> Thanks again, 
> Sudha
+---
| 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
+---