07-27-2010
Report Totals
Hello,
I have written a script in a previous server and its being migrated to a new server. I'm trying to debug my script since i've had to make minor changes to it to get it to work.
I'm having a hard time getting my totals to populate
here is the syntax
DUMP_COUNT=`sqlplus -S $ORA_USER/$ORA_PASSWORD@$ORA_SID << END
635 SET HEADING OFF
636 SELECT COUNT(*) FROM TMP_GLEN_ALL
637 WHERE TAC_NAME = '${TAC_NAME}'
638 /
639 END`
640 DUMP_COUNT=DUMP_COUNT+0
It previously came showed
Mail on dump: 26094
now its coming out as
Mail on dump: DUMP_COUNT+0
can anyone figure this one out?
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
With the following small script I list the size of documents belonging to a certain user by each time selecting the bytes-field of that file ($7). Now it fills the array with every file it finds so in the end the output of some users contains up to 200.000 numbers. So how can I calculate... (7 Replies)
Discussion started by: Hille
7 Replies
2. Shell Programming and Scripting
awk '
FILENAME == "all" { balance += substr($0,17,13)
dt = substr($0,6,8) }
END { for ( name in balance )
printf("%013s %3s of %8s\n", balance/100,name,dt) | "sort "
} ' all > summation
using this code i wanted to take summary totals of... (3 Replies)
Discussion started by: paresh n doshi
3 Replies
3. Shell Programming and Scripting
Hi Eveyone,
I am working on one shell script to find the specific records from data file and add the totals into variables and print them. you can find the sample data file below for more clarification.
Sample Data File:
PXSTYL00__20090803USA
CHCART00__20090803IND... (7 Replies)
Discussion started by: veeru
7 Replies
4. Shell Programming and Scripting
I need to go through files in a folder and names that match write to a new file and have counts of the seperate names. fairly new to scripting and know what I want but do not know how to script it. example of what I need follows
PACKAGE='ls -A1 | tr -s '-' '^' | cut -f2 -d"^" | sort -n'
loop... (2 Replies)
Discussion started by: freddie999
2 Replies
5. Shell Programming and Scripting
I have two files, uploads.txt and downloads.txt. I would like to combine the columns of these files based on the ip address. How can I best do this?
Uploads.txt
192.168.0.147 1565369
192.168.0.13 1664855
192.168.0.6 1332868
Downloads.txt
192.168.0.147 9838820
192.168.0.18 12051718... (7 Replies)
Discussion started by: zanyspydude
7 Replies
6. Shell Programming and Scripting
Afternoon,
I have a script which creates/modifies data into a formatted csv.
The trailer record should display 2 columns, the first is a static entry of "T" to identify it as a trailer record. The 2nd is a total of amounts in a column throughout the entire file.
My total isn't displaying... (8 Replies)
Discussion started by: mcclunyboy
8 Replies
7. Shell Programming and Scripting
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
Discussion started by: prashob123
5 Replies
8. Shell Programming and Scripting
I have a one-liner script like this that gives a total of everything in various directories:
for i in *;
do (cd $i && cd statelist && echo $i && ls -la |awk 'NR>3 {SUM += $5}\
END { print "Total number of elements " SUM }');done
It works just great but at the end I want to print a grand... (3 Replies)
Discussion started by: newbie2010
3 Replies
9. UNIX for Beginners Questions & Answers
I would like to create bins to get histogram with totals and percentage, e.g. starting from 0.
If possible to set the minimum and maximum value in the bins ( in my case value min=0 and max=20 )
Input file
8 5
10 1
11 4
12 4
12 4
13 5
16 7
18 9
16 9
17 7
18 5
19 5
20 1
21 7 (10 Replies)
Discussion started by: jiam912
10 Replies
LEARN ABOUT SUSE
sieveshell
SIEVESHELL(1) User Contributed Perl Documentation SIEVESHELL(1)
NAME
sieveshell - remotely manipulate sieve scripts
SYNOPSIS
sieveshell [--user=user] [--authname=authname] [--realm=realm] [--exec=script] server[:port]
sieveshell --help
DESCRIPTION
sieveshell allows users to manipulate their scripts on a remote server. It works via MANAGESIEVE, a work in progress.
The following commands are recognized:
list list scripts on server.
put <filename> upload script to server.
get <name> [<filename>] get script. if no filename display to stdout
delete <name> delete script.
activate <name> activate script.
deactivate deactivate all scripts.
OPTIONS
-u user, --user=user
The authorization name to request; by default, derived from the authentication credentials.
-a authname, --authname=authname
The user to use for authentication (defaults to current user).
-r realm, --realm=realm
The realm to attempt authentication in.
-e script, --exec=script
Instead of working interactively, run commands from script, and exit when done.
REFERENCES
[MANAGESIEVE] Martin, T.; "A Protocol for Remotely Managing Sieve Scripts", draft-ietf-managesieve-03.txt, Mirapoint, Inc.; May 2001, work
in progress.
AUTHOR
Tim Martin <tmartin@mirapoint.com>, and the rest of the Cyrus team <cyrus-bugs@andrew.cmu.edu>.
perl v5.10.0 2008-04-04 SIEVESHELL(1)