Stored procedure problem
Posted in 2003
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