Sponsored Content
Full Discussion: Spool data file
Operating Systems AIX Spool data file Post 302287578 by frank_rizzo on Saturday 14th of February 2009 10:56:37 AM
Old 02-14-2009
If I understand what your trying to do, this is not possible. Well, at least with standard tools.
 

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. 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

5. Shell Programming and Scripting

spool to file in ksh

hi all, am trying to write a ksh script which will take a username, password, db instance as input arguments and login to the database using sqlplus and select some data via sql and spool to a file. problem is that i am using "sqlplus -s" in order to hide the username/password and it doesnt... (8 Replies)
Discussion started by: cesarNZ
8 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
MAILHELP(1)                                                   General Commands Manual                                                  MAILHELP(1)

NAME
maildist, mailhelp, maillist, mailpatch - mailagent's commands SYNOPSIS
maildist address system [ version ] mailhelp [ address ] maillist [ address ] mailpatch address system version patchlist DESCRIPTION
These commands are not intended to be run directly by a user. They may appear in any mail whose subject is set to Command. Such a mail will be processed by the mailagent(1), which will extract all lines beginning with @SH, followed by one of the above commands. The mailagent first sets environment variables that will be used by every commands. Maildist is used to mail a whole distribution to the given address. The version number may be ommitted if the system has no version speci- fied !! Maildist looks for the Spool/distribs file to find where the distribution is located. If it has been archived, the file name extension is used to guess how the archive will be restored: .cpio archive is a cpio archive .tar archive is in tar format .cpio.Z compressed cpio archive .tar.Z compressed tar archive Note that on file systems with short file names, the final .Z extension could be dropped. Therefore, compressed archives must be explicitely stated in the Spool/distribs file. Once the directory is found (or extracted), maildist looks for a .package file. If one is found, then it is assumed this distribution is under control of the dist 3.0 package, and the makedist commmand is called to actually mirror the source tree (makedist being part of dist 3.0). Otherwise, it looks for a MANIFEST file. If it finds one, only the files listed therein will be sent. Otherwise, all the files will be sent, excepted the binary executables and object files, the RCS sub-directories or RCS files, the private U subdirectory and the .package file, any core file or files in a bugs subdirectory. Then, the following algorithm is used: if no RCS file is found, the file is sent as-is. Otherwise, we look for a defined 'lastpat' symbol. If it is found, the corresponding revision is checked-out and sent. Otherwise, the last-revision on the default branch is exctracted, pro- vided that the corresponding working file is not found. The maildist command will not work if the system is tagged as an old one (with an o in the patches column of the distribs file). A message will be sent back to the user, explaining that only patches are available. Mailhelp sends help to the address (if ommitted, the return path of the mail is used). The help text is found in Spool/agenthelp. It should have been correctly set in the installation procedure, as explained in the mailagent(1) manual page. Maillist sends the list of available distributions, with current patchlevels if necessary. The Spool/distribs and Spool/proglist files are both used to build the list. Mailpatch sends one or more patches for a maintained distribution. The directory or the archive is found by scanning Spool/distribs. The bugs sub-directory must then hold the available patches. The patches may be stored in compressed form (with the ending .Z), as mailpatch knows about them and will uncompress the patch before sending. Patches for old systems are kept in a separate directory, either in normal or in compressed form. If the version number of the old system is x.y, then the directory must be named bugs-x.y and placed in the root directory of the system, just like bugs is. Whenever the user asks for an old system, mailpatch inserts a little note giving the latest version number for that system. NOTE
For a more accurate description of these commands (user's point of vue), you may want to have a look at the help file or send help to your- self using the mailhelp command. FORWARDING
When the author of a package wishes to relinquish all maintenance duty, he is most often stuck by the weight of the past: Configure scripts have his e-mail address hardwired (see unit MailAuthor.U) and Command messages for package registration and/or patch requests will continue to reach him. The answer to that is to leave a .forward file at the top of the package tree and commands will automatically forge new requests and for- ward them to the address listed in the .forward file. Now the recipient surely needs a mailagent at the other end to deal with forwarded requests! Only plain e-mail address(es) are allowed in the .forward. The "|command" processing hook is not supported, since it's not sendmail which interprets that file but the command itself. Forwarding applies to maildist, mailpatch and package commands only. FILES
~/.mailagent configuration file for mailagent. /usr/share/mailagent directory holding templates and samples. Spool/agenthelp help file Spool/distribs distribution list Spool/proglist comments for available distributions Spool/plsave records patchlevel of archived distributions Log/agentlog mailagent's log file BUGS
The proglist file ought to make a distinction between different versions of a same system. AUTHOR
Raphael Manfredi <Raphael_Manfredi@pobox.com> SEE ALSO
mailagent(1), package(1). ram MAILHELP(1)
All times are GMT -4. The time now is 01:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy