Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!mips!decwrl!ucbvax!unisoft!fai!sequent!lugnut
From: lugnut@sequent.UUCP (Don Bolton)
Newsgroups: comp.databases
Subject: Re: Need INFO from INFORMIX users.
Keywords: INFORMIX
Message-ID: <42135@sequent.UUCP>
Date: 10 Sep 90 22:05:28 GMT
References: <4779@jato.Jpl.Nasa.Gov>
Reply-To: lugnut@sequent.UUCP (Don Bolton)
Organization: Sequent Computer Systems, Inc
Lines: 34

In article <4779@jato.Jpl.Nasa.Gov> khioe@mona.Jpl.Nasa.Gov (Kent Hioe) writes:
>
>Hi, I need some help/information from INFORMIX users.
>
>1. Is there any way in INFORMIX-SQL to load an ascii data file to a table with
>   some logical expression ? 
>   e.g: I have a table : customer consists of cust_no, invoice_bal, credit_bal.
>		I would like to load data from an ascii file consists of
>		cust_no and amount_figure.
>		I would like to insert the data to invoice_bal if the amount_figure is
>		positive amount, otherwise to credit_bal if negative amount ?
>
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.
>
>2. Is there any way to clear the field screen in INFORMIX-SQL run form menu
>   (before or after query mode, after update, remove or add mode)  if
>   the form uses more than one table (i.e, involved in join table) ?
>
>   Informix seems to clear the fields screen if and only if the table which
>   the fields belongs to is active. (have to use master and detail mode).
>
DUNNO here, been into 4gl stuff, and clears must be specified there ain't
no automatics.
>
>Thank you very much for your help and information.
>
Hope it helps
>
>Kent Hioe
>khioe@mona.Jpl.Nasa.Gov
>elroy!mona.Jpl.Nasa.Gov!khioe