I have 2 databases which has same table names and I need to list entries of a particular table in database1 not existing in the same tablename of database2.
eg : I have db1 having table name orders
I only want to list those entries from table name orders in database 1 not present in same table name (orders) in database 2 .
The only condition is I only want to list those entries whose amount_class ='boeing'
Therefore I am interested in those entries having amount_class = "boeing" in table amount_class of DB1 not present in same table name in DB2
I tried
Am I missing something?
Moderator's Comments:
Please use CODE tags for sample input and output as well as for sample code.
Last edited by Don Cragun; 06-23-2014 at 01:39 AM..
Reason: Add CODE tags.
Hi there,
I am new here and looking for a bit of help... I don't don't know much about Unix but I've tried to include as much info as possible.
We currently operate our system as a bespoke on SCO 5.05 with Informix databases. This includes a financials package called "Multisoft".
Both... (0 Replies)
Hello UNIX gurus, I need to install the mysql odbc connector with unixODBC on my AIX 5.3 machine. I have a mySQL database running on another server (Ubuntu 7.04). The SQL database works fine. The problem I am having is when trying to run ./configure for mysql-connector-odbc it seems to be looking... (1 Reply)
I've installed unixODBC and I would like to connect to a MS SQL (2005) database from a bash script. Can you post a code example?
Thank you! :D
J. (0 Replies)
Hi Friends,
I am using AIX version and sqlplus to connect to database while writing a shell script.
I have implemented three ways to connect to database :
1)
sqlplus -s <USERNAME>/<PASSWORD> <<!
@<SQL FILE TO EXECUTE>
exit
!
2)
sqlplus -s <USERNAME>/<PASSWORD> <<!
-----sql statemenets... (6 Replies)
I have a B+ tree flat file database which is used by the application we use.
I would like to implement a SQL kind of access for that DB.
I have implemented my data structures to parse and store the user written query for execution.
But i would like to know, do we have any standard data... (2 Replies)
I have two queries
query1
select IDW_SITE_NAME REGION,a.location_sid,a.CALENDAR_SID,count(*) from idw.vod_stream a, IDW_REF_DATA b
where a.location_sid = b.location_sid and a.calendar_sid between 20110901 and 20110915 --this is start date parameter and end date
parameter
and... (5 Replies)
Dear Friends :-),
Need your help once again.
I have following SQL in a shell script to pick values from database
select date_stamp, time_stamp from logs
where date=31012012
However, at times we need to take these value(s) from a variable. To do this we have following query.
select... (2 Replies)
On the Linux systems, we have scripts which monitor disk usage. I want to take that data and feed that into SQL database. Can you give some advise.
For example here is one of the file. I have many files like this but the format is same...
2012-09-24 04:36:14 2012-09-24 04:36:16 48414984... (3 Replies)
I want to check for rows in a table where all values (except the key) is empty. I am using MySQL 5.5.
I plan to do this mechanically, so the approach should work for any table in my database schema.
Suppose for illustration purposes I start with the following table:
CREATE TABLE `sources` (
... (4 Replies)
I have a requirement and below is the detail.
Create a shell script and needs to run in server "a".
Connect to teradata database server "b".
execute the .sql file from server "a"
Save the output of the query to a file in server "a"
Schedule this shell script to run every day for every 4... (1 Reply)