Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!usc!ucsd!helios.ee.lbl.gov!nosc!crash!scotto
From: scotto@crash.cts.com (Scott O'Connell)
Newsgroups: comp.databases
Subject: Re: reading flat files in Informix
Message-ID: <802@crash.cts.com>
Date: 30 Nov 89 16:23:44 GMT
References: <792@crash.cts.com> <1989Nov29.233548.14714@aqdata.uucp>
Reply-To: scotto@crash.cts.com (Scott O'Connell)
Organization: Crash TimeSharing, El Cajon, CA
Lines: 14

Something I didn't mention (hey, *I* knew what I wanted :-) was that the
parsing of lines for keywords was to add DB information.

SELECT * FROM customers WHERE MONTH(last_sale) < MONTH(TODAY-1)

Dear <contact>, $ Add customers.contact1

Because you're a valued customer .... we are concered that...
you last purchase <last_purch_date>...

-- 
Scott O'Connell		UUCP: {nosc, ucsd, hplabs!hp-sdd}!crash!ipars!scotto
			ARPA: crash!ipars!scotto@nosc.mil
			INET: scotto@ipars.cts.com


Brought to you by Super Global Mega Corp .com