06-28-2005
yes the select statements come out great, but not the connections
you see I have 25 DB's and I want to compare them each to each other, and I figure the best way is like this
1-2
2-1
2-3
3-2
3-4
4-3
etc...
but I also want to just compare 1 table at a time in each of the 25 DB, what gets created now contains all tables.
I guess I could just grep this output intto a seperate sql file for each table_name?
Thanks so much for all the help so far,
Zelp
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Can somebody give me a cleaner way of writing the following script. I was thinking that I could use a loop in the awk statement. It works fine the way it is but I just want the script to be cleaner.
#!/usr/bin/sh
for r in 0 1 2 3 4 5 6
do
DAY=`gdate --date="${r} days ago" +%m\/%d\/%y`... (3 Replies)
Discussion started by: keelba
3 Replies
2. Shell Programming and Scripting
I am having a problem with awk when I run it with a loop. It works perfectly when I echo a single line from the commandline. For example:
echo 'MFG009 9153852832' | awk '$2 ~ /^0-9]$/{print $2}'
The Awk command above will print field 2 if field 2 matches 10 digits, but when I run the loop... (5 Replies)
Discussion started by: cstovall
5 Replies
3. Shell Programming and Scripting
Hi guys
I having som problem trying to use sed to get a file and insert inside another one. I'll try to explain better.
I have a base.txt and using sed(having a array variables) I'm chaging some strings inside this file and saving as base1.txt. until here okay.
Then, I have to get this... (4 Replies)
Discussion started by: digobh
4 Replies
4. UNIX for Dummies Questions & Answers
I'm trying to parse a configuration text file using awk. The following is a sample from the file I'm searching. I can retrieve the formula and recipe names easily but now I want to take it one step farther. In addition to the formula name, I would like to also get the value of the attribute... (6 Replies)
Discussion started by: new2awk
6 Replies
5. Shell Programming and Scripting
Although my sed skills are gradually developing, thanks in large part to this forum, I'm having a hard time dealing with pattern space and looping, which I suspect is what I'll need a better handle on to figure out my current issue, which is converting a multi line file like this:
... (4 Replies)
Discussion started by: tiggyboo
4 Replies
6. Shell Programming and Scripting
How do I remove last comma?
echo "xx yy zz" | awk 'BEGIN{FS=" "}{for (i=1; i<=NF; i++) printf "%s,", $i}'output:
xx,yy,zz,
required output:
xx,yy,zz
or (ideally!):
xx, yy & zz
many thanks in advance! (4 Replies)
Discussion started by: euval
4 Replies
7. Shell Programming and Scripting
I would like to loop over variables i and j consecutively,
{ a = -6.7
b = 7.0
c =0.1
{ for (i = 0; i<=(b-a)/c; i++)
for (j = 1; j<=(b-a)/c; j++)
'$1<=(a+j*c)&&$1>=(a+i*c)' FILENAME > output_j
'{print $2}' output_j > output_j_f
}
I essentially want to print the range of $1... (9 Replies)
Discussion started by: chrisjorg
9 Replies
8. Shell Programming and Scripting
I have the data like this:
PONUMBER,SUPPLIER,LINEITEM,SPLITLINE,LINEAMOUNT,CURRENCY
IR5555,Supplier1,1,1,83.1,USD
IR5555,Supplier1,1,3,40.4,USD
IR5555,Supplier1,1,6,54.1,USD
IR5555,Supplier1,1,8,75.1,USD
IR5556,Supplier2,1,1,41.1,USD
IR5556,Supplier2,1,3,43.1,USD
... (3 Replies)
Discussion started by: jeffreybsu
3 Replies
9. UNIX for Beginners Questions & Answers
Hi,
I've got text files (say file1 and file2) in a directory (say directory1) with several columns like this:
a b c d
a b c de f g h
e f g hI need to add a header to the files in directory1 and the names of the columns must contain an identifier from another text file (say file3) like this:... (4 Replies)
Discussion started by: zajtat
4 Replies
10. Shell Programming and Scripting
I am trying to parse a text file and send its output to another file but I am having trouble conceptualizing how I am supposed to do this in awk.
The text file has a organization like so:
Name
Date
Status
Location (city, state, zip fields)
Where each of these is on a separate line in... (1 Reply)
Discussion started by: kellyanneghj
1 Replies
LEARN ABOUT REDHAT
chdist
CHDIST(1) CHDIST(1)
NAME
chdist - script to easily play with several distributions
SYNOPSIS
chdist [options] [command] [command parameters]
DESCRIPTION
chdist is a rewrite of what used to be known as 'MultiDistroTools' (or mdt). Its use is to create 'APT trees' for several distributions,
making it easy to query the status of packages in other distribution without using chroots, for instance.
OPTIONS
-h, --help
Provide a usage message.
-d, --data-dir DIR
Choose data directory (default: $HOME/.chdist/).
-a, --arch ARCH
Choose architecture (default: `dpkg --print-architecture`).
--version
Display version information.
COMMANDS
create DIST [URL RELEASE SECTIONS]
Prepare a new tree named DIST
apt-get DIST <update|source|...>
Run apt-get inside DIST
apt-cache DIST <show|showsrc|...>
Run apt-cache inside DIST
apt-rdepends DIST [...]
Run apt-rdepends inside DIST
src2bin DIST SRCPKG
List binary packages for SRCPKG in DIST
bin2src DIST BINPKG
List source package for BINPKG in DIST
compare-packages DIST1 DIST2 [DIST3, ...]
compare-bin-packages DIST1 DIST2 [DIST3, ...]
List versions of packages in several DISTributions
compare-versions DIST1 DIST2
compare-bin-versions DIST1 DIST2
Same as compare-packages/compare-bin-packages, but also runs dpkg --compare-versions and display where the package is newer.
compare-src-bin-packages DIST
Compare sources and binaries for DIST
compare-src-bin-versions DIST
Same as compare-src-bin-packages, but also run dpkg --compare-versions and display where the package is newer
grep-dctrl-packages DIST [...]
Run grep-dctrl on *_Packages inside DIST
grep-dctrl-sources DIST [...]
Run grep-dctrl on *_Sources inside DIST
list
List available DISTs
COPYRIGHT
This program is copyright 2007 by Lucas Nussbaum and Luk Claes. This program comes with ABSOLUTELY NO WARRANTY.
It is licensed under the terms of the GPL, either version 2 of the License, or (at your option) any later version.
Debian Utilities 2013-12-23 CHDIST(1)