Solaris

I think I misunderstood the OP - I thought of output redirecting and NOT about the here-doc itself.
My apologies.

Yes, I have a here-doc, but I do not redirect nothing to /tmp, it is done by operating system (os) automatically. So, if the filename assigned already exist on /tmp the os aborts my shell script. Your script would be great if I controlled the redirection, but it is driven by os. See below an extract from my shell script with a here-doc calling to sqlplus.


while [ 0 ] ; do

#-- check if cyclic process must be stopped

if [ -f $gp05000o_stop ] ; then
Flog "STOP RUNNING - $gp05000o_stop"
Fdelete_temp_files
Fexit
fi

#-- get the request from the users from the database

sqlplus -S $GMEP_USU/$GMEP_PWD << \
_eof_sqlplus > /dev/null

set termout off
set serveroutput off
set heading off
set linesize 400
whenever sqlerror exit 1 rollback

spool $gp05000o_process_to_run

select 'gp05000o','@', command, '@', rowid, '@', process_number, '@'
from oproc_call
where process_id = '$process_id'
and proc_status = '$process_wait'
and rownum = 1;

spool off

exit

_eof_sqlplus

. . .

done

=====================
error message reached
=====================
/disk1/gmeasp/code/sh/gp05000o.ksh[202]: /tmp/sh23628.13: cannot create

My god!! Before rewriting the code, I will try to convince my sysadmin one more time to develop a easy shell script to remove old sh* files from /tmp, I do not think that it takes more than one line.
Thanks to all for your valuable help
This is my first contact in this forum, and it has been excellent
jterra

....before you do this.....
Cannot you simply avoid using here-doc as previously suggested?
I see you're using ORACLE sqlplus. You can save your sql statements in a temp file [using your OWN derivation rules] and simply pass it sqlplaus on the command line. [and remove the temp file afterwards].

I don't Oracle at my hands now, but it should be pretty easy.

Yes, I could do it, but as you can see there are variables. And using here-doc the substitution is done by os automatically. However using my own file, first the sentences would be an additional component out of script, the substitution should be done manually using sed for instance, and ... I have a lot of code using here-doc. Any way, thanks for your suggestion.

something like this should get you started:

Code:

typeset -i u="${$}"

# keep incrementing "u" till you find a non-existant tmp file
while :
do
   tmpFile="/tmp/sh${u}"
   if [ ! -f "${tmpFile}" ] ; then break; fi
   ((u = u + 1 ))
done

cat "
set termout off
set serveroutput off
set heading off
set linesize 400
whenever sqlerror exit 1 rollback

spool $gp05000o_process_to_run

select 'gp05000o','@', command, '@', rowid, '@', process_number, '@'
from oproc_call
where process_id = '$process_id'
and proc_status = '$process_wait'
and rownum = 1;

spool off

exit
" > "${tmpFile}"

sqlplus -S $GMEP_USU/$GMEP_PWD < "${tmpFile}"
....
/bin/rm "${tmpFile}"

Just do something like...

Code:

filename=/tmp/jhjHkkkGRrqxbmXppoujuuyttrjfeJgfgg$$
echo "this
that
the other
last line" > $filename
program < $filename
rm $filename

*dang* vgersh99 beat me to it... I gotta type faster...