SEO

Informix Dynamic Server 7.31UD2R1
on HP-UX 11.0

Configuration:
Host: unix01 Instance:inf001 DBs: db04

Host: unix02 Instance:inf002 DBs: db01,db02 Stored
proc: db02:tp1234

Host: unix03 Instances:inf003 DBs: db02_syn

We have three instances inf001, inf002 and inf003 on
two Unix Boxes unix01, unix02.

We have a stored procedure in instance inf002 in
database db02 by name tp1234.

Here is the body of the stored procedure

CREATE PROCEDURE "informix".tp1234()
RETURNING int, int, int, int;

DEFINE sql_err, isam_err int;
DEFINE lv_msg_code, lv_severity_code int;
DEFINE var_logfile char(30);
DEFINE code int;

ON EXCEPTION SET sql_err, isam_err
IF (code <> 100) THEN
LET lv_severity_code = 2;
END IF;
ROLLBACK WORK;

RETURN sql_err, isam_err, lv_msg_code,
lv_severity_code;
END EXCEPTION;

LET sql_err, isam_err, lv_msg_code, lv_severity_code
=0,0,0,0;
LET code = 0;
LET var_logfile="/tmp/afiiimage_debug.txt";
BEGIN WORK;

SET LOCK MODE TO WAIT 60;

INSERT INTO db01@inf002:kol (age) values (1);


COMMIT WORK;
LET lv_msg_code=0;

RETURN sql_err, isam_err, lv_msg_code,
lv_severity_code;
END PROCEDURE;

The table definition for kol in db01@inf002 is

Create synonym kol for db02_syn@inf003:kol;

and the actual definition for kol in db02_syn in
inf003 is

Create table kol (age int);

Now when we are doing this on unix01,inf001

dbacess db04;
execute procedure db02@inf002:tp1234;

we are getting error 556.

but when we run the stored procedure locally it works
just fine.

Does anyone has any idea about this?

Thanks in advance.

- Vineet





__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
sending to informix-list