Don,
Firstly, be sure not to confuse files with executable objects or
Net.data macros.
Net.data uses the EXEC_PATH in the INI file to resolve the location of
unqualified executable objects.
Net.data uses the MACRO_PATH in the INI file to resolve the location of
macros.
However, for files, Net.data performs no resolution.
I am assuming that you are using the system naming convention via the
INI file directive,
DTW_SQL_NAMING_MODE SYSTEM_NAMING
For a DTW_SQL function, Net.data simply passes the SQL statement to the
SQL environment which attempts to resolve an unqualified file name just
as it would when entering the statement via STRSQL.
In other words, the current library list for the job must have already
been set correctly in order for an unqualified to be resolved.
I would be interested to know why you cannot use the current library
list.
For some senarios it can be useful to hard code a library name as an INI
file variable and retrieve it when necessary in a macro via the
DTW_GETINIDATA function.
You should be able to find discussion on this topic at the Net.data
forum
http://dtwdude.com
Cheers, Peter
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Don Cavaiani
Sent: Thursday, 10 July 2008 12:04 a.m.
To: web400@xxxxxxxxxxxx
Subject: [WEB400] Net.data Macro Library List
Greetings,
How is the library list determined when you execute a Macro? I do not
want to hard code the library name in the DTW_SQL statement, but if I
leave if off, the file is "not found".
Thanks,
Don
Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063
"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
#####################################################################################
This correspondence is for the named person's use only. It may contain confidential or legally privileged information, or both. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this correspondence in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of Veda Advantage. If you need assistance, please contact Veda Advantage on either :- Australia 133124 or New Zealand +64 9 367 6200
midrange.com
