07-30-2010
Thanks Jdash
1) what is the way of getting rowcount for 120 tables ?
Select count(*) from table1;
select count(*) from table 2;
like that if I list all 120 tables, the code won't be flexible.
2)Also, do we need to have one spool file for 120 tables ? or one spool file for one table? what would be the best method?
3)Can somebody pls paste some code here ? for spool and compare
Thanks
Maya
10 More Discussions You Might Find Interesting
1. Post Here to Contact Site Administrators and Moderators
Need to eventually sync the MY.UNIX userdata to the forums database (and others). Suggestions on the best approach welcome. (0 Replies)
Discussion started by: Neo
0 Replies
2. UNIX for Dummies Questions & Answers
I had a person ask me if a Sql database can be run with Unix? I don't know can this be done? They only have Sql dba's and no oracle dba but want to use a Unix box???? (1 Reply)
Discussion started by: tyranunn
1 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
I have a sequential file, with that I want to know row count within.
As know we can use, wc -l filename, to find out a row count.
But, I found this command works well , if a file is small. It fails to give me rowcount, if File is pretty big. It keeps on processing after we give the... (3 Replies)
Discussion started by: videsh77
3 Replies
4. Shell Programming and Scripting
Hi
I need to write a shell script that will access tables available on webpages and update a table on my webpage on a periodic basis. It will access, say for example a website that periodically update a table with certain quantities and update my table accordingly.it should have the flexibility... (0 Replies)
Discussion started by: wannabegeek
0 Replies
5. Shell Programming and Scripting
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies
6. Shell Programming and Scripting
Hi,
I want to compare two tables fieldwise using shell script. Can anyone help me regarding the same.
The approach which i tried is to first move the two tables in simple txt file where each field is now seperated by space. But i can't retrive each field with "space" as a seperator b'coz there... (1 Reply)
Discussion started by: dtidke
1 Replies
7. Shell Programming and Scripting
Hi guys!
I need to cut first row from a file (using awk) without the record separator character (in my case its MS-DOS 0D0A) and field separator character (in my case ; 3B) and put it in another file.
Can you help with that?
Regards,
PsmakR (18 Replies)
Discussion started by: PsmakR
18 Replies
8. Shell Programming and Scripting
Hello,
I have two databases one is student_Name and another is student_Name1...Two tabled contain 200 records each..I found that near 30 names are entered in both databases..I would like to remove the duplicates..and i have to keep the name which is newly added..Please hepl how to remove... (7 Replies)
Discussion started by: Anjali_vee
7 Replies
9. Shell Programming and Scripting
HI All,
I am new to Unix shell scripts..
Could you please post the unix shell script for for the below request.,
There are two different tables(sample1, sample2) in different schemas(s_schema1, s_schema2).
Unix shell script to compare the columns of two different tables of two... (2 Replies)
Discussion started by: Rajkumar Gopal
2 Replies
10. Shell Programming and Scripting
I have 3 file inputs,
file1
20160302|5485368299953|96|510101223440252|USA|5485368299953|6|800|2300|0
20160530|5481379883742|7|510101242850814|USA|5481379883742|5|540|2181|1500
20160513|5481279653404|24|510100412142433|INDIA|5481279653404|3|380|1900|0... (1 Reply)
Discussion started by: radius
1 Replies
LEARN ABOUT CENTOS
nrparms
NRPARMS(8) Linux System Managers Manual NRPARMS(8)
NAME
nrparms - Configure the NET/ROM interface.
SYNOPSIS
nrparms -nodes node +|- ident quality count port neighbour [digicall...]
nrparms -routes port nodecall [digicall...] +|- quality
nrparms -version
DESCRIPTION
This program is used to manipulate the routing tables of the NET/ROM network layer, or to get and set many of the network and transport
layer parameters for the NET/ROM protocol. The program has three basic modes of operation, node setting, neighbour setting and general
parameter setting. The syntax for the node and neighbour setting is taken from the original NET/ROM manual and is therefore not very UNIXy
but should be familiar to those familiar with NET/ROMs or TheNet.
To set up a new route to a NET/ROM node in the routing tables you must use the nodes option. All of the parameters are needed to add the
node. It is probably best to illustrate with an example:
nrparms -nodes GB7BPQ + NMCLUS 120 6 vhf G8ROU-3
This creates a new route to a distant node with the callsign GB7BPQ and the alias NMCLUS, it has a quality of 120 (out of 255) and has an
obsolescence count of six and packets for that node should be sent on the AX.25 port named vhf to my immediate neighbour G8ROU-3. The call-
signs of the node and the neighbour may be the same. For example to set up the node G8ROU-3 which is also my immediate neighbour, I would
use:
nrparms -nodes G8ROU-3 + MATLCK 200 6 vhf G8ROU-3
If the ident of the remote node is not known, it is possible to add a node with a blank ident. To do this an ident of '*' must be entered
on the command line. Because of the command line expansion that shells do, the * must be escaped by enclosing it in quotes.
It is also possible to remove a route to a distant node with the same command except that the + is replaced by a -. The other parameters
must also be present. If the node has not other routes then the node will be deleted, and the neighbour node that the connections go via
may also be deleted if no other node route uses it, and it is not a locked neighbour entry.
When setting up a new node, a new neighbour entry may also be created. This will have a default value. For that neighbour to be meaningful
in the automatic routing process, it must have a more reasonable entry in the neighbours list. To do this the routes option of the command
must be used. An example:
nrparms -routes ax0 G8ROU-3 + 120
This will create (or update) the neighbour entry for G8ROU-3 with a quality of 120 and it will be locked, it will not create a node entry
for the neighbour. This quality will be used by the netromd(8) program when calculating route qualities via this neighbour. Normally once a
neighbour has zero node routes going via it, it will be deleted. Locking a neighbour prevents the deletion from occurring. To unlock a
neighbour entry, the same command is used but with the + replaced by a -.
FILES
/etc/ax25/axports
/etc/ax25/nrports
SEE ALSO
call(1), netrom(4), nrports(5), axparms(8), netromd(8), nrparms(8).
AUTHOR
Jonathan Naylor G4KLX <g4klx@g4klx.demon.co.uk>
Linux 25 January 1997 NRPARMS(8)