I have accidentally deleted the syscolumns table & want to recreate.
Tried to load transactions in one of informix tables but unable to load it as it gives me this error.
"Cannot read system catalog (syscolumns)"
The other issue I have is if I try to run ISQL with the username "informix", it put the database temporarily in offline mode without shutting it down. If you login with user "root" then it is all ok. How can I overcome this problem? Somehow the informix user has got issues with loading ISQL. How do I overcome that?