Hi:
At every month end I would like to collect the information of a spool.
Every Spool has more then one job, below is the individual job information, I really want to collect into a text file.
Sp-id Proc User Printer Id Pty Form Copy Total
SP7494 MONTHEND SYED R123 P2 1 WIDE ... (3 Replies)
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)
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)
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)
Hi,
Can you please help me how to spool the unix commands executed in my client and its output to a file in local machine.
Basically, I want to save all OS commands executed in my session and its output into a file from my client something like we do oracle with "SPOOL".
Thanks in advance.... (2 Replies)
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)
Hi,
I use SunOS and i connect to database via isql. When tried using SPOOL command to extract the report from database, system thrown me saying "Spoool command not found".
Please advise. (3 Replies)
Hi guys .
I have a solaris machine serving as a DNS server for my environment. Everytime I go into /var/spool/mqueue , there are an aweful lot of emails with names likes:
qfqB6ChrpL006644.
When I cat the file , I get the following output:
H??Received: from machine.domain.com... (3 Replies)
Hello all
Currently I am working in a live production environment with 100+ Solaris servers . The environment has one DNS server and one SMTP server.
The problem that I am facing since the past 2 months is that the /var/spool/mqueue on my DNS server keeps getting full i.e. mails with name... (1 Reply)
Discussion started by: Junaid Subhani
1 Replies
LEARN ABOUT BSD
nfload
NFDUMP(8) System Manager's Manual NFDUMP(8)NAME
nfdump, nfload - notesfile dump/load programs
SYNOPSIS
nfdump notesfile
nfload [ -Ddirectory ] notesfile
DESCRIPTION
Nfdump and nfload are used to convert notesfile data base formats.
Nfdump converts the specified notesfile to a portable ASCII format and writes it to standard output. Some diagnostics are produced on
stderr. Nfdump can be run by any user; access to a particular notesfile is governed by that notesfile's access list.
Nfload is used on the output from nfdump to create a new notesfile. The -D option specifies an alternate base directory for the notesfile.
If unspecified, this defaults to ``/usr/spool/notes''. Nfload reads standard input for the ASCII representation of the notesfile.
Typical use of these two programs occurs when converting an existing notesfile data base to a new format. The nfdump program should be
compiled with the older structure definitions while nfload is compiled with the newer structures. The data base can then be converted with
a shell script of the following nature:
mkdir .OLD
mv * .OLD
for i in `ls .OLD`
do
echo $i start
nfdump $i | nfload -D/usr/spool/newnotes $i
done
echo $i done
echo ALL DONE
rm -rf .OLD
This assumes that the old data base is in ``/usr/spool/notes'' and the new data base is to be placed in ``/usr/spool/newnotes''. After the
conversion is complete, one can move the old data base from ``/usr/spool/notes'' to ``/usr/spool/oldformat'' and the new data base from
``/usr/spool/newnotes'' to ``/usr/spool/notes''.
FILES SEE ALSO notes(1),
The Notesfile Reference Manual
AUTHORS
Ray Essick (uiucdcs!essick, essick%uiuc@csnet-relay.arpa)
Department of Computer Science
University of Illinois at Urbana-Champaign
Urbana, IL
Rob Kolstad (kolstad@convex.UUCP)
CONVEX Computer Corporation
Richardson, TX
University of Illinois NFDUMP(8)