Re: Sqlplus Sql Loader and Unix - No sql control file?

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 20 Aug 2001 22:45:10 -0500
Message-ID: <un14tsyj5.fsf@verizon.net>

On 20 Aug 2001, stemp1ar_at_yahoo.com wrote:

>#!/bin/ksh

> . switch ut1
> sqlplus id/password <<EOF
> whenever sqlerror exit FAILURE
> set serveroutput on
> rem execute marktest_bad_rc
> execute marktest_good_rc
> exit
> EOF
> print $?
>
> Is this same syntax possible using Sql Loader??? Not needing to
> create a separate sql/control file with sql in it ????

No. But, if you are trying to do it dynamically you can sort of use this syntax.

cat << EOF > sqlldr-control-file
blah
blah
EOF sqlldr sqlldr-control-file
rm sqlldr-control-file

-- 
Galen Boyer
It seems to me, I remember every single thing I know.

Received on Mon Aug 20 2001 - 22:45:10 CDT