Sponsored Content
Full Discussion: Report Totals
Top Forums Shell Programming and Scripting Report Totals Post 302440532 by senormarquez on Tuesday 27th of July 2010 12:14:50 PM
Old 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

Calculating totals in AWK

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

summarising totals in awk

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

[Solved] Find Specific records from file and add totals into variables

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

loop through files splitting up and totals

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

Trying to combine upload and download totals from txt file by ip address

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

Totals in a file - incorrectly displaying

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

awk to sum a column based on duplicate strings in another column and show split totals

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

Grand totals in awk

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

Create bins with totals and percentage

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
bubbros-server(6)						   Games Manual 						 bubbros-server(6)

NAME
bubbros-server - the bub-n-bros server. SYNOPSIS
bubbros-server [ level-file.bin ] [options] DESCRIPTION
bubbros-server starts an http server that acts as a control panel for the server. The server listens on port 8000 by default. The url for the control panel is http://server:port/0xN where 0xN is a random hex number (acts as minimal protection). This url is printed when the server starts. You can start and view games and kill the server from this panel. The control panel also allows you to type in the address of a server to connect to, the script will then open a client to that server. The http server also servers java applet clients for those players who wish to use one. When a game is started the script opens a port for the game server. This port can then be connected to by a client. Clients autodetect servers running on the local network with UDP ping on port 8056. Connection forming The client forms a tcp connection to the server. Or, when using the metaserver, the server forms a connection to the client. If this fails, the client and server try a simultaneous SYN connect. This sometimes works if the server and client are behind firewalls. The server then tries to transmit the data over udp. If it gets no response from the client it will fall back to the existing tcp connection. OPTIONS
-b N, --begin N, --start N Start at board (level) number N. The default is 1. See also the -s option. -h, --help Display help. -i, --infinite Restart the server at the end of the game. Normally the server quits after a certain period of inactivity. This is useful when used with the -m option to make a public server that is available for a long time. -l N, --lives N Limit number of lives to N. If this option is not specified the number of lives will be infinite. -m, --metaserver Register server with the Metaserver (currently) at codespeak.net:8050. This makes your server visible to everybody, and also facil- itates joining through a fascistic firewall. --port TYPE=N Sets default listening ports. If type is LISTEN , sets the game server port to N. The game server port is chosen randomly by default. If the type is HTTP , sets the http server port to N. The http server port defaults to 8000. Another port will be chosen if none was specified and 8000 is already in use. The server also listens to UDP ping on port 8056. -s N, --step N Increase board number with N when a board is completed. Defaults to 1. see also the -b option. OUTPUT
The server outputs helpful debug information concerning the http and game servers. SEE ALSO
bubbros(6) bubbros-client(6) December 7, 2007 bubbros-server(6)
All times are GMT -4. The time now is 08:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy