Path: utzoo!attcan!utgpu!news-server.csri.toronto.edu!mailrus!usenet.ins.cwru.edu!math-cs.kent.edu!hawkwind
From: hawkwind@math-cs.kent.edu (Len Jaffe)
Newsgroups: comp.databases,connect.audit
Subject: Re: Is Unify perfect?
Message-ID: <1990Jun30.191834.28333@math-cs.kent.edu>
Date: 30 Jun 90 19:18:34 GMT
References: <1990Jun29.170422.3296@ibmpcug.co.uk> <209@twg.UUCP>
Organization: Kent State University
Lines: 37

In article <209@twg.UUCP> bill@twg.UUCP (Bill Irwin) writes:
[Big time text deletion]
>
>Teaser:  Do you know how to get an SQL to run from cron that can make use
>of the system date for determining valid records for processing by RPT?

Set up the query in a shell script using there here document form
and use the date command to fill in part of the here document. Then set
up a cron entry to run that shell script.

example script:
---------------------------------------------------
:
$DATE=`date| parsing command like awk, sed or perl`

SQL << EOF
select a_foo, a_bar
from foo_table
where
	a_foo = 8
	a_bar = $DATE
into 'foo.output'
/
EOF

-------------------------------------------

>Bill Irwin - TWG The Westrheim Group - Vancouver, BC, Canada 
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>uunet!van-bc!twg!bill     (604) 431-9600 (voice) |     UNIX Systems
>bill@twg.UUCP             (604) 431-4629 (fax)   |     Integration

Len Jaffe
-- 
 Leonard A.  Jaffe, Work: 216/591-0240
 CS Dept.        :  hawkwind@math-cs.kent.edu 
 It isn't easy being cheesey - Chester Cheatah