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 PLAN9
receive
RECEIVE(1) General Commands Manual RECEIVE(1)NAME
receive - receive files from the sendfile spool
SYNOPSIS
receive [ -d ] [ -r ] [ -k ] [ -P ] [ -S ] [ -Z spool ] [ -q ] [ -ffrom ] file [...]
receive -n [ -d ] [ -r ] [ -k ] [ -P ] [ -S ] [ -Z spool ] [ -q ] file-number [...]
receive [ -s ] [ -l ] [ -L ] [ -R ] [ -ffrom ]
receive -b user[@host] [ -k ] [ -f"from" ] file [...]
receive -b user[@host] [ -k ] [ -f"from" ] -n file-number [...]
receive -b user[@host] [ -k ] -a
DESCRIPTION
receive files from the sendfile spool which has been sent to you.
If there is already a file with the same name you will be prompted for overwriting or renaming.
Allowed wildcards in file names are: * ? [abc] [^abc]
CAUTION: you have to put wildcards and other special characters in '' quotes to hide them for interpretation by your shell.
OPTIONS -n receive file number(s)
-d delete instead of receive
-a receive (or delete or bounce) all files
-r rename before receiving
-k keep files in spool after receiving
-P pipe files to stdout
-S receive only pgp-signed files
-s list files in short format
-l list files
-L list files and look inside archives, too
-R renumber files in spool
-b bounce (forward) files to another recipient
-q quiet mode: no questions asked
-fuser all actions refer only to files from this user
-Z spool
specify an alternate spool directory
EXAMPLES
receive -L
list all files in long format.
receive 'blubb*'
receive all files starting with string "blubb".
receive -daf microsoft.com
delete all files from microsoft.com sites.
receive -b framstag@bofh '*.jpg'
bounce all *.jpg-files to framstag@bofh.
FILES
/var/spool/sendfile The sendfile spool directory.
/var/spool/sendfile/$USER/log
A log of the last transfers.
/etc/sendfile.deny Users which are not allowed to receive files or messages (set by root).
SEE ALSO sendfile(1).
AUTHOR
Ulli Horlacher - framstag@rus.uni-stuttgart.de
3rd Berkeley DistributionRECEIVE(1)