AW: Retrieve table's library with embedded SQL?

Hi,

If you define a file in the F-Specs, the first file with this name in the
library list is used.
If you use a file in a SQL statement, without specifying a library,
the first file in the library list with this name is used.

Birgitta

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Dan
Gesendet: Mittwoch, 13. Juli 2005 21:56
An: RPG400-L@xxxxxxxxxxxx
Betreff: Retrieve table's library with embedded SQL?


Related to my prior thread, I am wondering whether there is a way to
determine the library of the table opened/used in embedded SQL.  I do
not want to qualify the filename, and I am not otherwise defining the
file to the program (no F-spec).

I thought there might be something in the SQLDA, but I don't see
anything that looks like it might be a library name.

TIA,
Dan

--
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.