Re: Informix Export
When you perform dbexport, you will see the data with pipe ("|")
delimiter. For example:
Table with col1, col2, and col3 columns.
dbexport of table will be looks like:
THIS IS FIRST|120.11|1000|
THIS IS SECOND|10293.032|2439|
THIS IS THIRD|29.00|9049|
If you are loading into different database, you need to check with
your database delimiter. If your database's delimiter is comma (",")
you need to replace pipe with it. When you replace delimiter, check
if your database needs Also, check if string needs to be in quote or
not.
I hope this helps
Susik
______________________________ Reply Separator _________________________________
>Subject: Informix Export
>Author: INTERNET:rwakelin@rcgroup.com at CSERVE
>Date: 7/8/96 10:58 AM
>
>
>Sender: informix-list-owner@rmy.emory.edu
>Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4]) by
>hil-img-4.compuserve.com (8.6.10/5.950515)
>id LAA15502; Mon, 8 Jul 1996 11:45:04 -0400
>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id
>LAA01139 for susik_lee@united#u#group.ccmail.compuserve.com; Mon, 8 Jul 1996
>11:45:26 -0400 (EDT)
>From: "W. Russell Wakelin" <rwakelin@rcgroup.com>
>Message-Id: <31E11C83.714A@rcgroup.com>
>Subject: Informix Export
>Date: Mon, 08 Jul 1996 10:34:43 -0400
>Reply-To: "W. Russell Wakelin" <rwakelin@rcgroup.com>
>Organization: Reed Consulting Group
>Sender: informix-list-owner@rmy.emory.edu
>To: informix-list@rmy.emory.edu
>X-Informix-List-To: susik_lee@united#u#group.ccmail.compuserve.com
>X-Informix-List-Id: <news.25862>
Hello,
We're not using Informix, but we're dealing with a company that is.
They can send us a copy of their Informix database by doing a database
"export".
My question: What does/will this export look like? Is it an SQL script
that can be loaded into another SQL DBMS?
Thanks,
Russ Wakelin