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

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




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

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.