This does not sound like a standard Informix file. What version of Informix,
what operating system. What directory is the file in ?
> as I can erase the file database.log?
You're using IDS? In this case, the file is probably your online log
file. Yes, you can erase it without doing any damage. It would be
sensible to check that there is nothing untoward (unexpected) in it
before doing so, but once you've done that, you should be OK to erase it.
If neither of the above scenarios applies, you'd better tell us what
your situation is (database server, platform, versions, etc) - without
any extra information, this is about as much as anybody can do for you.
Jonathan Leffler #include <disclaimer.h>
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
How can I Removes all rows from a table which match certain condition
without logging the any records in Transaction Log file.
I know truncate table which will reomve all rows. I need to remove only
rows which match certain condion.
Appreciate any of your tips and ideas.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!