Re: Q. external database updates

In article <3547025B.1CF42F2@aethos.co.uk>, Pete Smith <pete.smith@aethos.co.uk> writes >hi all > >I am trying to set up the following scenario: > >db 1 on instance a >db 2 on instance b ( may be on the same or a different host ) > >I would like table x on db 2 to have a foreign key constraint >referencing table y on db 1, >is this possible? > I am not sure but your message appears to indicate it is not. Why not look into triggers and stored procedures?. Stored procedures CAN reference remote databases.. >I would also like a query which runs on db 1 to also update a table on >db 2. >again, is this possible? > If you mean an update then yes, again using a trigger and a stored procedure. >I have managed to create a synonym on db 2 pointing to table y on db 1, >but I get this error when trying to create the constraint: > >-556 Cannot create, drop, or modify an object on an another database >server. > >is there a way round this ? > >informix version is 7.20.UC3 >OS is HPUX 10.20 > >any suggestions much appreciated > >TIA > >Pete > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care