Re: DDS inquiry

[rob@xxxxxxxxx]

DDS is kind of old.  And while still useful if you find you cannot do what
you want in DDS then you might wish to consider creating the logical file
using either the SQL statement CREATE VIEW or CREATE INDEX.  For example;
if you have the following file:

TABLEA
COLA1          COLA2          COLA3
A         2.3       5.4
B         1.1       1.2
C         2.6       3.2

And then you run the SQL statement
CREATE VIEW QTEMP/VIEWA (COLA1, COLA2, COLA3, SUM)
     AS SELECT COLA1, COLA2, COLA3, COLA2+COLA3
     FROM QTEMP/TABLEA

Run the statement:

SELECT * FROM VIEWA

You'll get:

COLA1        COLA2    COLA3        SUM
A             2.30     5.40       7.70
B             1.10     1.20       2.30
C             2.60     3.20       5.80

Rob Berendt

==================
Remember the Cole!


                                                                                
                                       
                    "LJVM"                                                      
                                       
                    <jvy@skyinet.net>        To:     <RPG400-L@midrange.com>    
                                       
                    Sent by:                 cc:                                
                                       
                    owner-rpg400-l@mi        Subject:     DDS inquiry           
                                       
                    drange.com                                                  
                                       
                                                                                
                                       
                                                                                
                                       
                    12/06/00 04:41 PM                                           
                                       
                    Please respond to                                           
                                       
                    RPG400-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       





i have been using a DDS and wanted to know if there is a  possibility to
create a totals with in a logical file? example totdata =  data1 + data2

jvy



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