06-25-2008
compare two tables using shell script
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 are some fields like say "Description" which have content with spaces for ex. "[X] or more external movement" is the value in that field. Thus i cannot use space as a seperator.
Can any one help me in seperating each field and then compare that two files i.e two tables..
Thanks,
Durwas
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am coding shell script.
I need to connect to different databases like DB2, Oracle and Sybase.
I would then need to query tables where it has all the groups, users for that database.
I would also need who has what kind of permissions.
EG: I know for DB2 some TABAUTH table needs to be... (0 Replies)
Discussion started by: pinnacle
0 Replies
2. Shell Programming and Scripting
Hi,
I have two databases with same tables on different servers.I need to check the data content in each table and if something is missing, should print that.
I have a tool which takes the snapshot the table structure,index so on and compares with the other server tables snapshot.
Now i need... (1 Reply)
Discussion started by: nessj
1 Replies
3. Shell Programming and Scripting
All,
I have to create a shell script to comapre the rowcount of 120 tables from two oracle databases. In fact, using informatica the data is loading from 120 source tables to 120 staging tables. After that, they want to have a shell script to comapre the rowcount of all these tables.
1) I... (3 Replies)
Discussion started by: Maya_Pillai
3 Replies
4. Shell Programming and Scripting
I have an input file with contents like :
1LMXTJJD0W28TX2
1LS1XJGDEVWAC5T
1LK81JVDE2HRNDG
1LMXTJJD0W28TX2
1LS1XJGDEVWAC5T
1LK81JVDE2HRNDG
1LMXTJJD0W28TX2
I need to read each field from the file
pass it to a query:
select count(*) from usage_error where usage_id='$field... (17 Replies)
Discussion started by: Rajesh Putnala
17 Replies
5. 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
6. Shell Programming and Scripting
Hi All,
In my script I have used the below code to retrieve the instance name
V_INSTANCE_NAME=`sqlplus -s ${APPS_USR_PSWD} <<+
set pagesize 0 linesize 256 feedback off verify off head off echo off
set serveroutput off
select... (2 Replies)
Discussion started by: kalidoss
2 Replies
7. Shell Programming and Scripting
Hi guys.
I am new to this forum so cheers :)
I have a question.
I have created a shell script that puts all the output into 1 file.
The out put is like this:
-----IP------
Data
Data
Data
-----IP------
Data
Data
Data
How can i arrange this to be like this:
IP | Data |... (3 Replies)
Discussion started by: Pandera
3 Replies
8. 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
9. HP-UX
Heyy,
any help would be grateful....
LOOKING FOR THE WAYS TO SEND AN EMAIL WITH ATTACHMENT & HTML TABLES IN BODY THROUGH SHELL SCRIPT (LINUX)..NOT SURE, IF WE HAVE ANY INBUILT HTML TAG OR UNIX COMMAND TO SEND THE ATTACHMENTS. KINDLY HELP
below is small script posted for our understanding..... (2 Replies)
Discussion started by: Harsha Vardhan
2 Replies
10. Shell Programming and Scripting
What I have:
I have a input.sh (script which basically connect to mysql-db and query's multiple tables to write back the output to output1.out file in a directory)
note: I need to pass an integer (unique_id = anything b/w 1- 1000) next to the script everytime I run the script which generates... (3 Replies)
Discussion started by: kkpand
3 Replies
LEARN ABOUT DEBIAN
plan9-sort
SORT(1) General Commands Manual SORT(1)
NAME
sort - sort and/or merge files
SYNOPSIS
sort [ -cmuMbdfinrwtx ] [ +pos1 [ -pos2 ] ... ] ... [ -k pos1 [ ,pos2 ] ] ...
' [ -o output ] [ -T dir ... ] [ option ... ] [ file ... ]
DESCRIPTION
Sort sorts lines of all the files together and writes the result on the standard output. If no input files are named, the standard input
is sorted.
The default sort key is an entire line. Default ordering is lexicographic by runes. The ordering is affected globally by the following
options, one or more of which may appear.
-M Compare as months. The first three non-white space characters of the field are folded to upper case and compared so that precedes
etc. Invalid fields compare low to
-b Ignore leading white space (spaces and tabs) in field comparisons.
-d `Phone directory' order: only letters, accented letters, digits and white space are significant in comparisons.
-f Fold lower case letters onto upper case. Accented characters are folded to their non-accented upper case form.
-i Ignore characters outside the ASCII range 040-0176 in non-numeric comparisons.
-w Like -i, but ignore only tabs and spaces.
-n An initial numeric string, consisting of optional white space, optional plus or minus sign, and zero or more digits with optional
decimal point, is sorted by arithmetic value.
-g Numbers, like -n but with optional e-style exponents, are sorted by value.
-r Reverse the sense of comparisons.
-tx `Tab character' separating fields is x.
The notation +pos1 -pos2 restricts a sort key to a field beginning at pos1 and ending just before pos2. Pos1 and pos2 each have the form
m.n, optionally followed by one or more of the flags Mbdfginr, where m tells a number of fields to skip from the beginning of the line and
n tells a number of characters to skip further. If any flags are present they override all the global ordering options for this key. A
missing .n means .0; a missing -pos2 means the end of the line. Under the -tx option, fields are strings separated by x; otherwise fields
are non-empty strings separated by white space. White space before a field is part of the field, except under option -b. A b flag may be
attached independently to pos1 and pos2.
The notation -k pos1[,pos2] is how POSIX sort defines fields: pos1 and pos2 have the same format but different meanings. The value of m is
origin 1 instead of origin 0 and a missing .n in pos2 is the end of the field.
When there are multiple sort keys, later keys are compared only after all earlier keys compare equal. Lines that otherwise compare equal
are ordered with all bytes significant.
These option arguments are also understood:
-c Check that the single input file is sorted according to the ordering rules; give no output unless the file is out of sort.
-m Merge; assume the input files are already sorted.
-u Suppress all but one in each set of equal lines. Ignored bytes and bytes outside keys do not participate in this comparison.
-o The next argument is the name of an output file to use instead of the standard output. This file may be the same as one of the
inputs.
-Tdir Put temporary files in dir rather than in /var/tmp.
EXAMPLES
Print in alphabetical order all the unique spellings
in a list of words where capitalized words differ from uncapitalized.
Print the users file
sorted by user name (the second colon-separated field).
Print the first instance of each month in an already sorted file.
Options -um with just one input file make the choice of a unique representative from a set of equal lines predictable.
grep -n '^' input | sort -t: +1f +0n | sed 's/[0-9]*://'
A stable sort: input lines that compare equal will come out in their original order.
FILES
/var/tmp/sort.<pid>.<ordinal>
SOURCE
/src/cmd/sort.c
SEE ALSO
uniq(1), look(1)
DIAGNOSTICS
Sort comments and exits with non-null status for various trouble conditions and for disorder discovered under option -c.
BUGS
An external null character can be confused with an internally generated end-of-field character. The result can make a sub-field not sort
less than a longer field.
Some of the options, e.g. -i and -M, are hopelessly provincial.
SORT(1)