Very Computer

by **Dafel** » Thu, 10 Jun 2004 21:59:28

*** Everything seems to work from here to where my spool file is
created in the *** sql.

# Check for old file - remove if found
if [ -f /var/voice/voicecleanup.txt ]
then
rm /var/voice/voicecleanup.txt

fi

# Logon tp SQLplus, Run Sql file
sqlplus -s username/password<<END

quit
END

**** This is where the code fails. All code after the above line
never executes. What am I doing wrong

# Clean up spool file
sed -e 's/^[ \t]*//;s/[ \t]*$//' -e '/^$/d' -e '$d' voicecleanup.lst

Quote:>> voicecleanup.txt

echo '.EOF' >> voicecleanup.txt

by **Ed Morto** » Thu, 10 Jun 2004 22:42:41

> *** Everything seems to work from here to where my spool file is
> created in the *** sql.

> # Check for old file - remove if found
> if [ -f /var/voice/voicecleanup.txt ]
> then
> rm /var/voice/voicecleanup.txt

You could just do "rm -f /var/voice/voicecleanup.txt" instead of the
separate test.

> fi

> # Logon tp SQLplus, Run Sql file
> sqlplus -s username/password<<END

> quit
> END

> **** This is where the code fails. All code after the above line
> never executes. What am I doing wrong

You need to put the "END" for the end of the here document at the start
of the line, or prefix it with a "-" at the start of the here document.

Ed.

by **Stephane CHAZELA** » Thu, 10 Jun 2004 23:55:03

2004-06-09, 08:42(-05), Ed Morton:

[...]
>> # Check for old file - remove if found
>> if [ -f /var/voice/voicecleanup.txt ]
>> then
>> rm /var/voice/voicecleanup.txt

> You could just do "rm -f /var/voice/voicecleanup.txt" instead of the
> separate test.

You might end up removing a voicecleanup.txt file that is not a
regular one (or a symlink to a regular file).

--
Stephane

by **Goran Larss** » Thu, 10 Jun 2004 22:46:00

> sqlplus -s username/password<<END

> quit
> END

Read the shell manpage about '<<'. The terminating 'END' must
match the 'END' after '<<' exactly. The indentation prevents
the match and the rest of the file is consumed by '<<' instead
of being executed.

| sqlplus -s username/password<<END

| quit
|END

--
G?ran Larsson http://www.mitt-eget.com/

by **Bill Marcu** » Thu, 10 Jun 2004 23:13:18

On 9 Jun 2004 05:59:28 -0700, Dafella

> *** Everything seems to work from here to where my spool file is
> created in the *** sql.

> # Logon tp SQLplus, Run Sql file
> sqlplus -s username/password<<END

> quit
> END

> **** This is where the code fails. All code after the above line
> never executes. What am I doing wrong

Don't indent the END. Or, if you do indent it, change <<END to <<-END
and use tabs, not spaces.

--
Simulations are like miniskirts, they show a lot and hide the essentials.
-- Hubert Kirrman

by **Villy Krus** » Fri, 11 Jun 2004 00:02:04

On Wed, 9 Jun 2004 14:55:03 +0000,

> 2004-06-09, 08:42(-05), Ed Morton:

> [...]
>>> # Check for old file - remove if found
>>> if [ -f /var/voice/voicecleanup.txt ]
>>> then
>>> rm /var/voice/voicecleanup.txt

>> You could just do "rm -f /var/voice/voicecleanup.txt" instead of the
>> separate test.

> You might end up removing a voicecleanup.txt file that is not a
> regular one (or a symlink to a regular file).

test -f symlink will return true if the symlink refers to a regular file.
You need test -h to explicit test for symlink.

Villy

by **Stephane CHAZELA** » Fri, 11 Jun 2004 01:08:12

2004-06-09, 15:02(+00), Villy Kruse:
[...]

Quote:>> You might end up removing a voicecleanup.txt file that is not a
>> regular one (or a symlink to a regular file).

> test -f symlink will return true if the symlink refers to a regular file.
> You need test -h to explicit test for symlink.

That's what I meant.

rm -f voicecleanup.txt
will remove the voicecleanup.txt if it is neither a regular file
nor a symlink to a regular file.

--
Stephane

by **Kevin Colli** » Fri, 11 Jun 2004 06:48:54

>> *** Everything seems to work from here to where my spool file is
>> created in the *** sql.

>> # Check for old file - remove if found
>> if [ -f /var/voice/voicecleanup.txt ]
>> then
>> rm /var/voice/voicecleanup.txt

> You could just do "rm -f /var/voice/voicecleanup.txt" instead of the
> separate test.

>> fi

>> # Logon tp SQLplus, Run Sql file
>> sqlplus -s username/password<<END

>> quit
>> END

>> **** This is where the code fails. All code after the above line
>> never executes. What am I doing wrong

> You need to put the "END" for the end of the here document at the start
> of the line, or prefix it with a "-" at the start of the here document.

The "-" only works when you use ONLY tabs as whitespace before the EOF. That is
based on both ksh and bash man pages (and my experience)...

Kevin

Very Computer

I don't understand why this code isn't working

I don't understand why this code isn't working

I don't understand why this code isn't working

I don't understand why this code isn't working

I don't understand why this code isn't working

I don't understand why this code isn't working

I don't understand why this code isn't working

I don't understand why this code isn't working

I don't understand why this code isn't working