I have a requirement where i have to spool some data to a file. i have achived the desired target but m facing one issue. i have attached the script and the output.
i checked the data length in the table but it is only 45 for column 1.
can you tell me how to remove these extra spaces after the first column.
hi,
I'm in Solaris 2.8 env. When i'm trying to add a ftp user account ,
encountered "no space in disk" .. couldn't create any user. Then check the fs disk space with "df - k " and /var/adm/syslog .. got the below message.
Jun 9 03:10:53 mail sendmail: NOQUEUE: low on space
(have 0,... (10 Replies)
Hello,
I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?
Thanks (2 Replies)
Hi all,
I would want to spool file for a database query, however by using crontab, the file is not spooled. Below shows my script:
ORACLE_HOME="/u01/oraprod/perpdb/10.1.0/db_1"
OUTFILE="/tmp/invalid.out"
FILE="$HOME/admin/scripts"
$ORACLE_HOME/bin/sqlplus -s "/as sysdba"... (0 Replies)
Is there anyway to spool my select statement into spool files of max 10000 records each?
eg I have a select statement that will return 45000 records.
A normal spool command will output the 45000 into just one spool file.
How can I make sqlplus do this?
00001 - 10000 records --- spool... (3 Replies)
for diskname in $(lspv |awk '{print $1}')
do
lquerypv -h /dev/|awk '/'$diskname'/ { print ; exit }'
done
No output is returning from the loop.
I think awk put an extra space to the command - lquerypv -h /dev/
so that the command is executed as i.e. lquerypv -h /dev/ hdisk230 with a space... (7 Replies)
I have used m4 in the past to generate source code where aesthetics and space were of no consequence . Now I am using it to generate script and program templates .
So here is an excerpt from my m4 file for producing a generic bash script:
dnl `$Id$'
define(`START_SCRIPT',`#!/bin/bash... (8 Replies)
Hi,
Since today, with csh or tcsh, if I do 'ls files* > list',
every lines end with an extra space!
What happenned?
What can I do to go back when there was no extra space?
If I change to bash, there's no extra space.
Thanks,
Patrick
---------- Post updated at 03:19 PM... (1 Reply)
Hi Gurus,
I have a file which contains some special char or space.
when using cat -evt I can see the file as following:
0,"0000","abc/def aaa ... (6 Replies)
Hi All,
Im trying to find the count of process running on remote server using SSH.
Below command dosen't work.
ssh -q user@host "ps -ef | grep "pattern" | grep -v 'grep' | awk '{print $2}'|wc -l"
But below command works.
ssh -q user@host "ps -ef | grep "pattern" | grep -v... (1 Reply)
Hi All
I am trying to perform the below operation -count=`cat abc.txt | wc -l`
echo$count
5
Head=Start"$DATE"00000"$count"File
echo $HEAD
START15020300000 5File
There is a space coming before 5 which is not needed . How to ignore that . (4 Replies)
Discussion started by: honey26
4 Replies
LEARN ABOUT OSF1
recvstats
RECVSTATS(8) System Manager's Manual RECVSTATS(8)NAME
recvstats - summarize HylaFAX receive accounting information
SYNOPSIS
/usr/sbin/recvstats [ options ] [ files ]
DESCRIPTION
recvstats is a command script that prints a summary of the HylaFAX accounting statistics for received facsimile. The statistics can be
sorted using one of several keys: the caller's CSI (default), CIDName (CallID2), CIDNumber (CallID1), the communication speed, or the com-
munication data format. Statistics are read from the file /var/spool/hylafax/log/xferfaxlog unless filenames are specified on the command
line.
The following table is an example of the output from recvstats (using the default sort key):
Sender CIDName CIDNumber Pages Time Pg/min Errs TypRate TypData
61 30:47 2.0 16 9600 1-DMR
+13037904674 5 1:34 3.2 2 9600 1-DMH
+14159657824 1 1:00 1.0 0 9600 1-DMH
+15086636852 2 0:00 2.0 0 9600 1-DMH
+15105268781 740 5:47:51 2.1 59 9600 1-DMH
+15105287164 20 7:00 2.9 0 9600 1-DMH
+15123713545 3 1:19 2.3 0 9600 1-DMH
+15123713641 5 1:04 4.6 0 9600 1-DMH
+16099211926 3 2:00 1.5 0 9600 1-DMH
+17088987617 1 0:18 3.3 0 9600 1-DMH
415 390 6175 22 6:01 3.6 0 9600 1-DMH
415 965 7651 56 34:52 1.6 14 9600 1-DMH
415 973 6723 1 2:09 0.5 0 9600 2-DMR
49 211 161514 1 0:00 1.0 0 9600 2-DMR
8185970503 1 0:28 2.1 0 9600 2-DMR
ALDUS CORPORATION ALDUS CO 5551212 3 2:34 1.2 0 9600 1-DMH
--------------------------------------------------------------------------------------------------
Total 925 7:19:03 2.1 91
The Sender column shows the caller's TSI (notice that some callers have not setup a TSI). The CIDName column is the received CIDName value
for the sender. The CIDNumber column is the received CIDNumber value for the sender. The Pages column is the total number of good pages
received. The time column shows the total amount of time spent receiving facsimile from a sender. The Pg/min column displays the average
transfer rate. The Errs column indicates how many protocol errors were encountered while receiving facsimile. The TypRate column displays
the most common communication speed with which facsimile were received. The TypData column shows the most common data format in which fac-
simile data were received.
OPTIONS -age days Show information only for the facsimile received in the last specified number of days.
-csi* Sort output by caller's CSI.
-cidname Sort output by CIDName
-cidnumber Sort output by CIDNumber
-format Sort output by data format.
-send* Sort output by sender (i.e. caller's CSI).
-speed Sort output by signalling rate.
-since time Show information only for the facsimile received since the specified time; where time is of the form ``MM/DD/YY HH:MM'' (the
date(1) format string %D %H:%M).
-end time Show information only for the facsimile received before the specified time; where time is of the same form as since.
FILES
/var/spool/hylafax spooling area
/var/spool/hylafax/log/xferfaxlog default file from which to read statistics
SEE ALSO faxq(8), xferfaxstats(8), hylafax-log(5)
March 3, 1995 RECVSTATS(8)