RE: How to copy files with CPYF for SQL created long named files

[Bruce Vining <bvining@xxxxxxxxxx>]

The Retrieve Short Name (QDBRTVSN) API will return the 10 character name
associated with a long SQL table name.  The API can be found in the
Information Center under the Database category of system APIs.

Bruce Vining



                                                                           
             "Ali Ekinci"                                                  
             <Ali.Ekinci@mapic                                             
             s.com>                                                     To 
             Sent by:                  "RPG programming on the AS400 /     
             rpg400-l-bounces@         iSeries" <rpg400-l@xxxxxxxxxxxx>    
             midrange.com                                               cc 
                                                                           
                                                                   Subject 
             01/21/2005 04:02          RE: How to copy files with CPYF for 
             PM                        SQL created long named files        
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
                                                                           
                                                                           




SQL allows creating tables with names up to 128 long.
Anybody knows way to copy a long named file (longer than 10) with CPYF
command?
I understand ISeries comes up with a 10 digit name (First five characters +
00001), but I wasn't able to figure out, how to reference that name to the
actual long SQL table name.
thanks in advance for any help.

Ali