Path: utzoo!utgpu!watserv1!watmath!att!occrsh!uokmax!munnari.oz.au!samsung!zaphod.mps.ohio-state.edu!sdd.hp.com!elroy.jpl.nasa.gov!jato!mona!khioe
From: khioe@mona.Jpl.Nasa.Gov (Kent Hioe)
Newsgroups: comp.databases
Subject: Need INFO from INFORMIX users.
Keywords: INFORMIX
Message-ID: <4779@jato.Jpl.Nasa.Gov>
Date: 10 Sep 90 15:44:24 GMT
Sender: news@jato.Jpl.Nasa.Gov
Reply-To: khioe@mona.Jpl.Nasa.Gov (Kent Hioe)
Followup-To: khioe@mona.Jpl.Nasa.Gov (Kent Hioe)
Organization: Engineering Analysis Subsystem Environment Group, JPL
Lines: 26


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 ?


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).


Thank you very much for your help and information.


Kent Hioe
khioe@mona.Jpl.Nasa.Gov
elroy!mona.Jpl.Nasa.Gov!khioe