is there a way to insert into the as400 via sql server linked server without turning on journaling? everything i see says it has to be turned on, but i would like a solution in which i do not need it on (if possible). i'm using sql server 2005
INSERT INTO LINKSERVER.as400server.libraryname.tablename
(tagno, timestmp, location, result)
('750-JB-000','2011/04/19 16:01', 'PR', 1)
i get this message
"SQL7008: tablename in libraryname not valid for operation.