AW: null values

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

Title: AW: null values

to Rolf:

Thats correct, but if you write the result of a sum(xyz)or max(xyz),....  function in a file
the file-field is defined with: nulls allowed

Try it with the interactive sql.

For example: (german version of dspffd)
.
.
.
Feldebeneninformationen                                                             
             Daten        Feld  Puffer    Puffer        Feld     Spalte             
  Feld       Art         Länge   Länge  Position        Verwend. Überschrift        
  SEL0001    PACKED      11  0       6         1        Beide    MAX                
    Nullwert zugelassen                                                             
.
.
.

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

you can replace null values in several ways with
SQL i.e. VALUES or COALESCE function or
with the case expression.

hth Rolf

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