Re: Another DDS question

[Scott Lindstrom <SLindstrom@xxxxxxxxxx>]

Don -

The two fields together make up a composite key (I think I have the correct
terminology there).  You can reference the file by this key (or by just the
first field in the key if you'd like, using START, etc).  That would be the
non-SQL way of accessing the file.

But you also want to access the file using SQL?  If so, let me know
privately and I can send you an example.

Scott


                                                                           
             "Don Stafford"                                                
             <don.stafford@uav                                             
             co.com>                                                    To 
             Sent by:                  "COBOL Programming on the           
             cobol400-l-bounce         iSeries/AS400"                      
             s@xxxxxxxxxxxx            <cobol400-l@xxxxxxxxxxxx>           
                                                                        cc 
                                                                           
             01/26/2006 09:27                                      Subject 
             AM                        [COBOL400-L] Another DDS question   
                                                                           
                                                                           
             Please respond to                                             
             COBOL Programming                                             
                  on the                                                   
               iSeries/AS400                                               
             <cobol400-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




The groups' help a week or so ago was a tremendous help.
Now I have another question.

My RPG DDS is coded as follows:

 Text:  AT : Account Criteria File - ORG/SHAC
 Key  Field      Description                           Size    Reffl
 ---  -----      -----------                           ----    -----
  1A  ATORG      Origin                                 3A     ORIG
  2A  ATSHAC     Ship Account                          12A     ACCT
      ATCAD1     Customer Address 1                    35A     ADDR
      ATCAD2     Customer Address 2                    35A     ADDR
      ATCAD3     Customer Address 3                    35A     ADDR
      ATCAD4     Customer Address 4                    35A     ADDR
      ATCAD5     Customer Address 5                    35A     ADDR
      ATCAD6     Customer Address 6                    35A     ADDR
      ATCATT     Customer Attention To                 35A     ADDR
      ATSRCH     Search Name                              35A     ADDR

Does this, in theory, treat ATORG as a key, and ATSHAC as a separate key?
Or does it also create a 3rd key that is a combination of the two?

How do I code the select statement?

Thanks!