RE: Need help for loggin
Logging has to be the same on both databases for remote access to work. cheers j. > -----Original Message----- > From: Csom Gyula [mailto:Csom@interface.hu] > Sent: Thursday, December 14, 2000 10:02 AM > To: 'informix-list@iiug.org' > Subject: RE: Need help for loggin > > > Hi, > I don't really see the point here, do I miss something? > Anyway use global names to acces data from "anywhere": > > db_name:table_name or db_name@server_name:table_name > > Does that make sense?:) > > Csomi > > > -----Original Message----- > From: Jinyao Lin [mailto:jinyao@mail.com] > Sent: Thursday, December 14, 2000 2:39 AM > To: informix-list@iiug.org > Subject: Need help for loggin > > > Dear all, > Currently I have some problem with database logging. I > have two database. > One of them is create with buffer log and another is no > logging. All these > two database logging status are not able to changed. But I > need to access > data from one to another. Is any good solution to do that > way? I heard that > it's possible to do with SPL. Any resource or example I can find? > > thanks for your help. > > best regards, > Jinyao Lin >
"Parker, Jack" wrote: > Logging has to be the same on both databases for remote access to work. Jack's right. If you are working outside the database (eg in ESQL/C or ODBC or JDBC), then you can create two independent connections to the two different databases, and pull data from one database on one connection and push it into the other down the other connection. However, you cannot use two different databases with different logging modes inside a single SELECT statement, whether you use synonyms or not, explicit dbase@server:owner.table notation or not, or SPL or not. > > -----Original Message----- > > From: Csom Gyula [mailto:Csom@interface.hu] > > Sent: Thursday, December 14, 2000 10:02 AM > > > > I don't really see the point here, do I miss something? > > Anyway use global names to acces data from "anywhere": > > > > db_name:table_name or db_name@server_name:table_name > > > > Does that make sense?:) > > > > -----Original Message----- > > From: Jinyao Lin [mailto:jinyao@mail.com] > > Sent: Thursday, December 14, 2000 2:39 AM > > > > Currently I have some problem with database logging. I > > have two database. > > One of them is create with buffer log and another is no > > logging. All these > > two database logging status are not able to changed. But I > > need to access > > data from one to another. Is any good solution to do that > > way? I heard that > > it's possible to do with SPL. Any resource or example I can find? -- 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!"