Oninit cdi / Archive
Talk to an expert →

Re: dbimport failed - IDS 9.30 UC3

Posted in 2003

Topics: Storage & Space Management, Stored Procedures & SPL, Server Administration, Migration, Import/Export & Data Conversion, Versions, Editions & End-of-Life

Fred Prose — — source: Usenet: comp.databases.informix

We have run into similar problems, and not just with this release. In our case we had Stored Procedures that would not export our and import back in due to special characters. We learned a trick that can save you hours of watching a dbimport work only to see it fail like you did. We run a 'test fire'. Before you do the real import you do a simple create database (in the dbspace you planned on putting it) and then run the .SQL file as a script through dbaccess. This process takes seconds or a few minutes and will check everything for syntax.

↪ replying to Fred Prose
Hari Gupta — — source: Usenet: comp.databases.informix

Sound an excellent trick. I will certainly try this. Hari "Fred Prose" <fprose@hotmail.com> wrote in message news:195a4770.0310081229.153fe1e8@posting.google.com... > We have run into similar problems, and not just with this release. In > our case we had Stored Procedures that would not export our and import > back in due to special characters. > > We learned a trick that can save you hours of watching a dbimport work > only to see it fail like you did. > > We run a 'test fire'. Before you do the real import you do a simple > create database (in the dbspace you planned on putting it) and then > run the .SQL file as a script through dbaccess. This process takes > seconds or a few minutes and will check everything for syntax.

Glossary