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

["Haas, Matt" <Matt.Haas@xxxxxxxxxxx>]

File QADBXREF in QSYS can be used to do this. Specifically, you want to use 
logical QADBXLFI which is keyed by library name and long file name.

Matt

-----Original Message-----
From: Ali Ekinci [mailto:Ali.Ekinci@xxxxxxxxxx]
Sent: Friday, January 21, 2005 5:31 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: How to copy files with CPYF for SQL created long named
files


I wasn't able to see the short table name, but even I can,what I need is 
something (api) I can use within a CL or RPG.
Thanks anyway.

-----Original Message-----
From: Haas, Matt [mailto:Matt.Haas@xxxxxxxxxxx]
Sent: Friday, January 21, 2005 5:12 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: How to copy files with CPYF for SQL created long named
files


If you do a STRSQL and do a SELECT * FROM long_table_name and hit F4, prompting 
for the field names will show the short table name.

Matt

-----Original Message-----
From: Ali Ekinci [mailto:Ali.Ekinci@xxxxxxxxxx]
Sent: Friday, January 21, 2005 5:02 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: How to copy files with CPYF for SQL created long named
files


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