unload errors

Hello all, I am unloading some tables on a nightly basis (via cron) from Informix running on an HP-UX box. The script is static. Occasionally there will be an error during the unload. Example: Error in line 7 Near character position 5 Error in line 101 Near character position 21 or Error in line 78 Near character position 24 It is not consistantly dying in the same spot, and if I run it manually afterward it runs fine. Most evenings these errors do not occur, weird. Anyway, I suspect that another process may have a record locked. Is there a way to report on this from the unload script? Thanks, Marc

Why locking a row; maybe you can set isolation to dirty read; before executing the unload, or maybe set lock mode to wait???? or.... lock the table ?? catch stuff from dbaccess: (dbaccess <yourdb> yoursqlfile 2>&1 ) > somelogfile may give you more info. Superboer. Marc Baker schreef: > Hello all, > > I am unloading some tables on a nightly basis (via cron) from Informix > running on an HP-UX box. The script is static. Occasionally there will be > an error during the unload. > > Example: > > Error in line 7 > Near character position 5 > Error in line 101 > Near character position 21> > or > > Error in line 78 > Near character position 24> > It is not consistantly dying in the same spot, and if I run it manually > afterward it runs fine. Most evenings these errors do not occur, weird. > > Anyway, I suspect that another process may have a record locked. Is there a > way to report on this from the unload script? > > > Thanks, > > Marc