RE: File field descriptions

Point accepted.  And the beauty of SYSCOLUMNS is that it is broken down by
library, if instead of doing CRTLIB you use the SQL command CREATE
COLLECTION.  And probably the Client people use SYSCOLUMNS instead of
accessing QADBIFLD directly.

Rob Berendt

==================
A smart person learns from their mistakes,
but a wise person learns from OTHER peoples mistakes.


                                                                                
                                         
                    Buck Calabro                                                
                                         
                    <Buck.Calabro@comms        To:     MIDRANGE-L@midrange.com  
                                         
                    oft.net>                   cc:                              
                                         
                    Sent by:                   Subject:     RE: File field 
descriptions                                  
                    owner-midrange-l@mi                                         
                                         
                    drange.com                                                  
                                         
                                                                                
                                         
                                                                                
                                         
                    06/06/01 08:47 AM                                           
                                         
                    Please respond to                                           
                                         
                    MIDRANGE-L                                                  
                                         
                                                                                
                                         
                                                                                
                                         




>You could always query the file QADBIFLD.  IBM built this on V3R2 to store
>every field in every file.  You create a file and this automatically gets
>updated.  The reason for this is that Client developers didn't want to
mess
>with outfiles or API's.

I generally refer people to SYSCOLUMNS instead of the underlying physical.
It's an SQL thing.  WRKF SYS* and check out
http://publib.boulder.ibm.com/pubs/html/as400/v5r1/ic2924/index.htm?info/db2

/rbafzmstcatalog.htm (or search the InfoCentre for SYSTABLES.  The second
hit was Appendix G of the DB2 manual.)

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




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