Re: AW: Long file names for external data structures

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 12/30/2016 03:04:42
AM:

When using the QDBRTVSN, you can pass either the long or short name with
library or with special value *LIBL.
You'll get the long and short names as well as the library/schema in

which

the file is found.

When searching the SYSTABLES view, you need to know whether it is a long

or

short name and in which library the file is found.
If you don't pass the library you may get several files with the same

name

in different libraries but you won't know which is the right one.

I know the OP is not about programmatically determining long or
short table names. But, I wish I had known about that API back when I
needed to do this. What I did was basically the following followed by the
RTVOBJD API based on library list to determine the actual object and
library I needed.

SELECT DBXFIL FROM QADBXREF
WHERE (DBXLFI = ? OR DBXFIL = ?)
AND DBXATR NOT IN ('IX','CL')
FETCH FIRST ROW ONLY;

Sincerely,

Dave Clark