Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Ian Briscoe — — source: Usenet: comp.databases.informix
Running IDS 9.21UC4 on Unixware 7.11
We have a number of identically structured databases in our group - an
accounts system. We want to be able to link common accounts together
for reporting purposes.
Each site will have 2 stored procedures:
get_account - to which will be passed a company identifier, an
account number,and the name of the remote server (site_name). This
will be run locally.
get_account_details - to which will be passed the same company
identifier and the account number. This will be run remotely.
get_account has the line:
LET execute_string =
"mach4@"||trim(site_name)||":get_account_details";
CALL execute_string(company_id,customer_acc) returning........
this in effect builds and executes the remote call (database always
called mach4).
Problem is:
in dbaccess....
If I run 'get_account' for a given accont number and site_name I get
back the results from the remote site as I expected.
But if I then run it for the same acount at a different site I'm
getting the SAME results as from the first site.
If I exit dbaccess and run the procedure for the second site it works
fine.
If I run "mach4@site_name:get_account_details" directly from a local
site to a remote site it works fine time after time.
The problem only seems to be when one SPL is calling another?
This is driving me bonkers!!!!
Any tips?
TIA
Ian
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.