Re: [Q] SQL calls from UNIX scripts?

In article <Cr1n8x.1Ips_at_ief.itg.ti.com>, Raymond Scott <rlscott_at_lobby.ti.com> wrote:
>We have both Sybase and Oracle installed on an
>HP 9000 running HP-UX. I would like to be able
>to execute SQL from a UNIX script. The goal is
>to be able to create 'quicky' transactions to
>perform frequently done SQL etc.

I don't know about Oracle, but Sybase's isql can be used in shell scripts to execute SQL commands.

Another option would be to take both Sybperl and Oraperl and merge them into a single program capable of talking to Sybase and Oracle simultaneously. This shouldn't be too hard to do...

Michael

-- 
Michael Peppler	            | mpeppler_at_itf.ch          | Sysadmin,
ITF Management SA           |                          |   DBA,
13 Rue de la Fontaine       | Phone: (+4122) 312 1311  | Programmer
CH-1204 Geneva, Switzerland | Fax:   (+4122) 312 1325  | & Trader...