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

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