Shell Programming and Scripting

Hi


I am logging into sql using script.

Code:

sqlplus ima/ima@test <<!
spool /opt/tt/spoolfile.txt
@sql.sql
spool off

.

now i am getting a spool file named spoolfile.txt.lst

i want it to be only spoolfile.txt

I am working on solaris

Please help

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums

---------- Post updated at 02:26 PM ---------- Previous update was at 02:22 PM ----------

Are you sure the character in the spool filename is really a dot?
Could you post the exact content of your scripts (shell and sql)?

Code:

 sqlplus mqad/mqad@testeb2 <<!
column dt new_val X
select to_char(sysdate,'YYYY-MM-DD-HH-MI-SS') dt from dual;
spool /export/home/scripts/eb2/aqad/prd2/data/PRD2_MQAD_&X.txt
@/export/home/scripts/eb2/comm/sqlq.sql
spool off

And sql script contains just one line desc emptable.

Change:

Code:

PRD2_MQAD_&X.txt

to:

Code:

PRD2_MQAD_&X..txt

Thanks it worked....


one more thing i am geting @/export/home/scripts/eb2/comm/sqlq.sql

as the first line in the spool file... any way to remove it.

Code:

sqlplus -s
(Silent)

Put the statement directly in the here document or move the spool inside the sql script.