10 More Discussions You Might Find Interesting
1. UNIX and Linux Applications
Hello All,
I'm trying to spool an oracle table data into a csv file on unix server but the complete record is not being extracted. The record is almost 1000 characters but only 100 characters are being extracted and rest of the data getting truncated.
I'm setting below options :
SET... (4 Replies)
Discussion started by: venkat_reddy
4 Replies
2. Shell Programming and Scripting
I am using a unix shell script to create and then FTP the file to a mainframe application.
The unix script uses spool to extract data from a Oracle database. The data is extracted into a text file.
The text file is having all the data I need but not in the correct format. The rows of... (1 Reply)
Discussion started by: rameez
1 Replies
3. Shell Programming and Scripting
Hi Friends,
I am trying to spool the data from Teradata. The rpoblem which i am facing is , the coulmn data is appended with ".(dot)" for some coulmns. Please find the below data :
data i want in file :
1|BANG|KINR|3456
2|KIBNJ|UIE|6347
3|JEEM|Y34E|3874
data which is spooling... (6 Replies)
Discussion started by: i150371485
6 Replies
4. Shell Programming and Scripting
I want to spool files from unix using a sql script that would
take values from another sql query within the KSH script..
unix loop
select order_date from date_tbl
for each order_Date i need to call this spool script with the value
sqlplus scott/tiger@order_db @/ordspool/order_date.sql... (2 Replies)
Discussion started by: vr23
2 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
Please help me regarding this.
we have our SAP system with unix environment.
Spool setting in unix ,we are not able to cancel any unix spool from SIDADM because the spool user is nor SIDADM. for example :-
Any idea how to make the spool from OS level as SIDADM, Please suggest.... (3 Replies)
Discussion started by: dravi_laxmi
3 Replies
6. UNIX for Dummies Questions & Answers
Hi,
Is there any command in unix similar to spool command in oracle. (6 Replies)
Discussion started by: manosubsulo
6 Replies
7. Shell Programming and Scripting
hi,
can anyone help me by saying how can i spool a unix file.. do we need to specify the pathname as such to spool the file ..
right now, i tried giving like spool filename in the sql prompt.. but its not giving me the required output even if i can see that the command is being executed..
... (2 Replies)
Discussion started by: kripssmart
2 Replies
8. Shell Programming and Scripting
I have a sqlplus report and inside that report I have the following piece of code to mail the report output to the email id.
My requirement is, instead of emailing the output I want to FTP that script to a different unix server (say ip as 10.10.1.1). How to modify this code to FTP the spool file... (0 Replies)
Discussion started by: vprevin
0 Replies
9. Shell Programming and Scripting
Hi everyone
I'm new in this forum, I have a question:
I have a script with many sql staments and I have the spool command at the beginning and the 'spool off' at the end of the script. But, I want to write after each sql stament to a log file not at the end. How can I do it?
Thanks (0 Replies)
Discussion started by: edzela
0 Replies
10. UNIX for Dummies Questions & Answers
hi every body,
is there any possibles to spool the commads with output(like oracle spool file) (1 Reply)
Discussion started by: kskumar
1 Replies