×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
David,
Be careful using the SQL method mentioned in the link, reading the manuals
about the CURRENT_SERVER special register.
Depending on your particular setup you might not get back what you expect.
I ran a test and got returned:
....+....1....+...
CURRENT SERVER
ANYNAMEYOUWANT
******** End of data ********
<info center>
CURRENT SERVER cannot be specified unless the local relational database is
named by adding the entry to the relational database directory using the
ADDRDBDIRE or WRKRDBDIRE command.
Example
Set the host variable APPL_SERVE (VARCHAR(18)) to the name of the current
server.
SELECT CURRENT SERVER
INTO :APPL_SERVE
FROM SYSIBM.SYSDUMMY1
</info center>
On Jan 19, 2010 3:37am, David FOXWELL <David.FOXWELL@xxxxxxxxx> wrote:
<snip>
> This link is to the the400-guru site:
> http://www.itjungle.com/fhg/fhg012804-story04.html
Thanks for that. At the bottom of the page is a little gem in SQL. I
think I'll use that instead of the other possibilities.
</snip>
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
