Path: utzoo!utgpu!watserv1!watmath!att!mcdchg!tellab5!balr!segel
From: segel@balr.com (Michael Segel)
Newsgroups: comp.databases
Subject: Re: Need INFO from INFORMIX users.
Keywords: INFORMIX
Message-ID: <1990Sep12.143033.6353@balr.com>
Date: 12 Sep 90 14:30:33 GMT
References: <4779@jato.Jpl.Nasa.Gov> <42135@sequent.UUCP>
Reply-To: segel@balr.UUCP (Michael Segel)
Organization: Balr Corporation, Oak Brook, Il.
Lines: 33

In article <42135@sequent.UUCP> lugnut@sequent.UUCP (Don Bolton) writes:

>NONE I know of, I'd load it all into a "temp" table and then apply the
>logic to insert what you need to the real table. I have little respect
>for the Informix load utility. Usually use Oracle loader and then extract
>out in Informix acceptable format flat file and load from there.
>>
	Well ISQL is fairly primitive. I think the best solution would
be to load it into a temp file, then write a program in the querry language
to make your final table. (Which is what is being recommended.) Now,
IF you had 4gl, I would suggest using a C routine to load the data into
a set of variables and pass this data on to a 4gl program to build
your table of data.
	I agree that the Informix load utilities are primitive, I belive
their primary function was to allow for a simple method of
transfering data in and out of tables. However, I don't think that
your solution "Usually use Oracle loader and then extract out in 
Informix acceptable ...." is too viable. Not many people have both
Oracle and Informix and use both. I think it is , shall we say , 
cost prohibitive?

Not that I am trying to bash Don for replying, but I think it
interesting that his approach to solving the problem is to use 
Oracle to solve a deficiency in Informix. I mean, that if Don does
a lot of 4gl work, why not make an Informix solution to solve
the problem?

Please take this comment with a grain of salt. 
I don't want anyone to flame me for something they thought I said.
or that they have read into my posting.

Cheers
-Mike