Re: Writing database schema to a file
This is a multi-part message in MIME format.
--------------CE5A6D7915D92F655820C99C
Content-Type: text/plain; charset=us-ascii
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit
Forget it!
Informix delivers 3 different backup systems: ontape, onarchive and
onbar. Use one of choise.
Further more you can use dbexport to get schema and data unloaded, but
then no users can be connected..
Well, anyway Informix has a special sql command called INFO, so you can
write INFO TABLES or INFO COLUMNS FOR tablename etc.
regards
grainnep@my-dejanews.com wrote:
> I am using ESQL/C to write a database backup program. Is there any
> easy way
> to retrieve and write the database schema (tables and definitions) to
> this
> file?
> I know I can get this information from systables and syscols but I was
> just
> wondering if there was an easy way to do this?
>
> -----== Posted via Deja News, The Leader in Internet Discussion
> ==-----
> http://www.dejanews.com/ Now offering spam-free web-based
> newsreading
--------------CE5A6D7915D92F655820C99C
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Claus Samuelsen
Content-Disposition: attachment; filename="vcard.vcf"
begin: vcard
fn: Claus Samuelsen
n: Samuelsen;Claus
org: Avenir Danmark A/S
adr: Gydevang 22 B;;;DK-3450 Aller'd;;;Denmark
email;internet: csa@sysdeco.dk
title: Systems Manager
tel;work: +45 4814 3000
tel;fax: +45 4814 3011
x-mozilla-cpt: ;0
x-mozilla-html: FALSE
end: vcard
--------------CE5A6D7915D92F655820C99C--