Re: OPNQRYF question

[MWalter@xxxxxxxxxxxxxxx]

You need to create another format (file) with all of the fields you wish to
use. Then specify that in your format parameter.

ovrdbf file(combFile) tofile(file1) share(*yes)
opnqryf file(file1 file2) +
                 format(combFile) +
                 jfld((1/fld1 2/fld4)) +
                 keyfld(fld1 fld5)
call (pgm opening combFile)
clof opnid(combFile)
dltovr file(combFile)



Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040
/"\
\ /
 X
/ \



                                                                                
                                                                    
                    "Amitava Banerjee"                                          
                                                                    
                    <Amitava.Banerjee@t        To:     <rpg400-l@midrange.com>  
                                                                    
                    rin.net>                   cc:                              
                                                                    
                    Sent by:                   Subject:     OPNQRYF question    
                                                                    
                    rpg400-l-bounces@mi                                         
                                                                    
                    drange.com                                                  
                                                                    
                                                                                
                                                                    
                                                                                
                                                                    
                    02/14/2003 12:27 PM                                         
                                                                    
                    Please respond to                                           
                                                                    
                    RPG programming on                                          
                                                                    
                    the AS400 / iSeries                                         
                                                                    
                                                                                
                                                                    
                                                                                
                                                                    




Hi Group
FILE1 has FLD1, FLD2 and FLD3 fields. Another file FILE2 has FLD4, FLD5 and
FLD6 fields. Now can I do an OPNQRY on both od FILE1 and FILE2, format
FILE1 and key by FLD1 and FLD5? When I tried that I got an error "Key field
FLD5 not valid for record format". I understand that since FLD5 is not in
FILE1 and I am using FILE1's format in OPNQRYF, it is giving that error.
Is there any other way I can do that by OPNQRYF?

Thanks in advance
Amitava

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.