AW: null values

["Simmerlein, Stefan" <S.Simmerlein@xxxxxxxxxxx>]

Title: AW: null values

Rolf,

first thx for your help. It only works with the coalesce-function.

The reason i use the sqlda, is that my sqlrpg program can
process all types of sql-statements.

in your example you fetch the result into the file-field or in a
helpfield of the same type and length.
My fetch looks like this:
                              
c/exec sql                    
c+ fetch c0 for 1 rows        
c+ using descriptor :sqlda    
c+ into :universal_ds              
c/end-exec                    
                             
it's completly universal.

thx for help, stefan

------------------------------

Not quite sure what you want to accomplish,

I use a similar construct when searching for the
highest key

c+    select coalesce(max(xyzKey), 0) into :xyzKey from xyzTable

which needs no sqlda and places the desired value directly
into the variable of the requesting program

---------------------------
Dipl.Inf.(FH) Rolf P Mittag
IBM Partner in Development
Leipziger Str. 50
D-69214 Eppelheim
Fon: +49 (6221) 76 78 60
Fax: +49 (6221) 76 80 26
eMl: rm@r-m-e-d-v.de

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