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

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

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



-----Original Message-----
From: Simon Coulter [mailto:shc@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, January 19, 2005 1:51 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Act! Phht! How to find EXPORTER of a symbol?



On 20/01/2005, at 4:55 AM, Chris Wolcott wrote:

> Is there a program or something that will scan multiple objects in
> multiple libraries and list their exports, or better yet search all
> objects for one that exports a specified symbol(s)?

No system function will do exactly what you want but you can roll your 
own:

DSPMOD will show the exports on screen or print them.

QBNLMODI API will dump exports to a user space. You can then copy them 
to a file and query that.

Regards,
Simon Coulter.
--------------------------------------------------------------------
    FlyByNight Software         AS/400 Technical Specialists

    http://www.flybynight.com.au/
    Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
    Fax:   +61 3 9419 0175                                   \ /
                                                              X
                  ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------


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


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