Re: Help: TRANSACTION log and update

} CASE: INFORMIX 5 database on SCO unix, database without transaction log } I login server-1, from dbaccess trying to update a table on server-2 } and get error "668: system command cannot be executed. 255: not in } transaction." } My SQL statement: } UPDATE test@star0:assign set as_fname="Terry" WHERE as_ssnum="009999999" } } Question: This works if I directly logon server-2. But update from another } server, it requires transaction log to be turned on. } } Is this what transaction log means to keep data integrity in a } network environment? } } Thanks for help! Do you have logging turned on at server-2? I don't remember the error message, but you must have the same logging level in all parts of a networked database. Just a possibility, __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|