Re: Informix data extraction
On Fri, 17 Jan 1997, Peter Wiley wrote:
} In article <01bc02fa$24ac9160$9e53b5cf@steve-s> "Steven Hammond" <srh@netcom.ca> writes:
} >Anyone who can help,
} >
} >I have recently acquired a customer who has a very old (I believe) version
} >of Informix. They are not sure of what version but said something like
} >version 5 or version 5.5? The system is about 6-8 years old.
}
} [snip]
} >
} >My question. Is there an ODBC driver or some other means that I can read
} >this file and extract the data structures and data from it?
}
} The PC copy is useless to you.
}
} Go back to the xenix box and find out what version of Informix is on it.
} If you have the scripts that the users are connecting by, this should be
} pretty trivial.
}
} If the engine is 5.x, you *should* have dbaccess. Extracting the data is
} then child's play.
}
} If it's 4.x (or 2.x) *and* you don't have isql *and* you don't have a
} development system, you have a problem. But some of us do still have
} systems even as far back as 1989.
}
} Forgot - 4.x has dbexport. This will dump out both the database
} definitions and all table contents, so you're still OK.
}
} syntax is
}
} dbexport databasename
}
} HTH
}
} Peter Wiley
}