Sponsored Content
Full Discussion: spool to file in ksh
Top Forums Shell Programming and Scripting spool to file in ksh Post 302343531 by BubbaJoe on Wednesday 12th of August 2009 06:15:37 PM
Old 08-12-2009
Are you sure it is not spooling the data out or you are not getting any data from your sql command? Did you take the -s out and run it?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to spool a unix file

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

2. Shell Programming and Scripting

grep spool file error

Hi, I am trying to do this For i in *.txt do sed 'some pattern checking' $i done >file These text files are spool files.And when i find error in these spool files I want to append the text file contents to error.log file. Or is there any option that I do this sed for only files that... (12 Replies)
Discussion started by: ran16
12 Replies

3. UNIX for Dummies Questions & Answers

SQLPlus spool file

HI Have some problem with spooling out some relatively large number of records (~2-3 mil) Small table - OK though. Getting error: SP2 0308: cannot close spool file. Any thoughts? sqlplus -s user/pwd << EOF set term off set head off set trims on set pages 0 set... (1 Reply)
Discussion started by: Leo_NN
1 Replies

4. AIX

Spool data file

Dear Gurus, Tried searching for some clues in this forum but dont seem to be able to find my answer. :confused: Anyway i have a quick question: Today I have produced a messages generated from a application and placed them on the print queue. Before this I had stopped the printer queue, so... (2 Replies)
Discussion started by: lweegp
2 Replies

5. Shell Programming and Scripting

Problem in spool file

Hi, Iam a newbie. When I give the below query at SQL prompt. SQL> select col1||'`ß`'||col2 from tablename where rownum<2; 1-J7WGX`ß`1-7OKC-23 Iam getting ß within appostropies...... If I remove appostropies and give the query it is throwing an error. If I give the same query in spool as... (1 Reply)
Discussion started by: kknayak
1 Replies

6. Shell Programming and Scripting

Spool file, only if data exists.

Hi All, I have one Question, that is it possible to check the spool output? What i mean to say is "spool the file only if data exists" I am trying to fetch data from a sql query, and want to generate a file, on a condition that the file should be generated, only if the output of the sql... (5 Replies)
Discussion started by: spiabhi
5 Replies

7. Shell Programming and Scripting

Spool Data in a file

Hello, I am trying to spool data from database into a file on solaris through ksh. Data is getting fetched but the problem is record is getting split in to multiple lines. excerpt from sql is whenever sqlerror exit 1; set define on set echo off set feed off set head off set... (1 Reply)
Discussion started by: abhi1988sri
1 Replies

8. UNIX for Dummies Questions & Answers

Column Header in the Spool file

Hi All, I have a problem with the column heading while spooling the data from the database. Since i want the column header, therefore i am not using SET HEADING OFF, and i am getting the header, but for the longer column name, some of the character from the column name is missing. for... (7 Replies)
Discussion started by: Pramod_009
7 Replies

9. Shell Programming and Scripting

Spool file requirement

Hi, I have a requirement of Connecting to sqlplus from unix Execute the package. The output of package is stored in a table Need to query the table and move to txt file. The problem iam facing is, when I try to spool the file. I get the sql query also along with the output.... (6 Replies)
Discussion started by: Shanmugapriya D
6 Replies

10. Shell Programming and Scripting

Order of data in Spool File

Hello, I have a shell script through which I am executing .sql file and spooling the result of Query from .sql . I want to spool the result in ascending order. Is there any parameter to be set to print result in ascending or descending order. Thanks in advance. (4 Replies)
Discussion started by: Aparna.N
4 Replies
Data(4) 						     Kernel Interfaces Manual							   Data(4)

NAME
Data - Contains data to be sent to remote systems SYNOPSIS
/usr/spool/uucp/LocalSystemName/D.SystemNamexxxx### DESCRIPTION
Data (D.*) files contain the data to be sent to remote systems by the uucp uucico daemon. The full pathname of a data file is a form of the following: /usr/spool/uucp/SystemName/D.SystemNamexxxx### where the SystemName directory and the SystemName portion of the file name indicate the name of the remote system. The xxxx### notation is the hexadecimal sequence number of the Command (C.*) file associated with that data file; for example, D.venus471afd8. After a set period of time (specified by the uusched daemon), the uucico daemon transfers the data file to the designated system. It places the original data file in a subdirectory of the uucp spooling directory named /usr/spool/uucp/SystemName, where the SystemName directory is named for the computer that is transmitting the file, and creates a Temporary (TM.*) file to hold the original data file. After receiving the entire file, the uucp program takes one of three actions: If the file was sent with the uucp command and there were no transfer problems, the program immediately renames the TM.* file with the appropriate data filename, such as D.venus471afd8, and sends it to the specified destination. If the file was sent with the uuto command, the uucp program also renames the temporary data file with the appropriate D.* filename. It then places the data file in the public directory /usr/spool/uucppublic, where the user receives the data file and handles it with one of the uupick command options. If there were transfer problems (such as a failed login or an unavailable device), the temporary data file remains in the spooling subdirectory. The uudemon.cleanu command, a shell script, removes these files automatically at specified intervals, or they can be removed manually. FILES
Describes accessible remote systems Contains uucp command, data, and execute files Contain instructions for file transfers Store data files temporarily after they have been transferred to a remote system Contain files that the uucp program has transferred RELATED INFORMATION
Daemons: uucico(8), uusched(8), uuxqt Commands: uucp(1), uupick(1), uuto(1), uux(1), uudemon(4) delim off Data(4)
All times are GMT -4. The time now is 08:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy