Remote Insert
Posted in 2000
Topics: General Discussion
Hello, Anyone kown about the possibility to use insert istruction from a remote unix machine into informix unix database (without using any driver) ? Thank You in advance Bruno
Geppo wrote: > Anyone kown about the possibility to use insert istruction from a remote unix > machine into informix unix database (without using any driver) ? Depends on what you mean by "without using any driver". If ESQL/C is OK, then: EXEC SQL CONNECT TO "dbase@remote"; EXEC SQL INSERT INTO Table VALUES(1, 2, 3); Or, if you already have a connection to a local database: EXEC SQL INSERT INTO dbase@remote:Table VALUES(1, 2, 3); This is subject to some constraints, of course (related to database logging modes, username and password). -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"