Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: shell/sql to get difference between two database
Top Forums UNIX for Dummies Questions & Answers shell/sql to get difference between two database Post 302558497 by qutesanju on Friday 23rd of September 2011 05:17:10 PM
Old 09-23-2011
I have two queries

query1
Code:
 
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 a.location_sid = 190 --this is location id parameter
and HAS_ERROR = 'N'
group by IDW_SITE_NAME,a.location_sid,a.CALENDAR_SID
order by a.location_sid,a.CALENDAR_SID

output

REGION LOCATION_SID CALENDAR_SID IDW COUNT
AUSTIN 190 20110901 110557
AUSTIN 190 20110902 132851
AUSTIN 190 20110903 168656

query2
Code:
 
select REGION,a.location_sid,a.CALENDAR_SID,count(*) from sda_vod_stream a, SDA_DIVISIONS b
where a.location_sid = b.location_sid and a.calendar_sid between 20110901 and 20110915
and a.location_sid = 190
group by REGION,a.location_sid,a.CALENDAR_SID
order by a.location_sid,a.CALENDAR_SID

output

REGION LOCATION_SID CALENDAR_SID SDA COUNT
AUSTIN 190 20110901 110559
AUSTIN 190 20110902 132851
AUSTIN 190 20110903 168659

both queries will be getting executed on separate database
e.g
query1-->executes on database1
query2-->executes on database2


now my requirement is that

here is final output

REGION LOCATION_SID CALENDAR_SID IDW COUNT SDA COUNT DIFF
AUSTIN 190 20110901 110557 110559 -2
AUSTIN 190 20110902 132851 132851 0
AUSTIN 190 20110903 168656 168659 -3

here difference = query1.count - query2.count

how can I produce a final output CSV /XLS file

I can generate above report file using oracle,but here both databases are different

I'm thinkning to copy above SQL in a shell script and can generate a report as oracle is based on UNIX

parameters

in above both query the changing parameter is
1. 20110901 this is start date parameter
2. 20110915 end date parameter
3. 190 this is location id

Please let me know if anybody has different solution for this ?
Last edited by qutesanju; 09-23-2011 at 06:27 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Read SQL database from Unix...

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)
Discussion started by: uptheposh
0 Replies

2. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies

3. Shell Programming and Scripting

Connecting to MS SQL database from bash (using unixODBC)

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)
Discussion started by: ph0enix
0 Replies

4. Programming

SQL for flat file database

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)
Discussion started by: kumaran_5555
2 Replies

5. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies

6. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this? Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies

7. Shell Programming and Scripting

SQL in LINUX. Variable or Database

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)
Discussion started by: anushree.a
2 Replies

8. Programming

pls. help with SQL database...

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)
Discussion started by: samnyc
3 Replies

9. Shell Programming and Scripting

SQL compare database

Hi , 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 ad_d | code | start | end | amountscore | id | amount_class |... (1 Reply)
Discussion started by: siya@
1 Replies

10. AIX

Connect to database server and execute sql

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)
Discussion started by: MadhuSeven
1 Replies

LEARN ABOUT REDHAT

pvmfbarrier

BARRIER(3PVM)							  PVM Version 3.4						     BARRIER(3PVM)

NAME

       pvm_barrier - Blocks the calling process until all processes in a group have called it.

SYNOPSIS

       C    int info = pvm_barrier( char *group, int count )

       Fortran	 call pvmfbarrier( group, count, info )

PARAMETERS

       group   Character string group name. The group must exist and the calling process must be a member of the group.

       count   Integer	specifying the number of group members that must call pvm_barrier before they are all released. Though not required, count
	       is expected to be the total number of members of the specified group.

       info    Integer status code returned by the routine.  Values less than zero indicate an error.

DESCRIPTION

       The routine pvm_barrier blocks the calling process until count members of the  group  have  called  pvm_barrier.   The  count  argument	is
       required  because  processes could be joining the given group after other processes have called pvm_barrier. Thus PVM doesn't know how many
       group members to wait for at any given instant. Although count can be set less, it is typically the total number of members of  the  group.
       So  the	logical  function  of the pvm_barrier call is to provide a group synchronization.  During any given barrier call all participating
       group members must call barrier with the same count value.  Once a given barrier has been successfully passed, pvm_barrier  can	be  called
       again by the same group using the same group name.

       If pvm_barrier is successful, info will be 0. If some error occurs then info will be < 0.

EXAMPLES

       C:
	    inum = pvm_joingroup( "worker" );
		    .
		    .
	    info = pvm_barrier( "worker", 5 );

       Fortran:
	    CALL PVMFJOINGROUP( "shakers", INUM )
	    COUNT = 10
	    CALL PVMFBARRIER( "shakers", COUNT, INFO )

ERRORS

       These error conditions can be returned by pvm_barrier

       PvmSysErr
	      pvmd was not started or has crashed.

       PvmBadParam
	      giving a count < 1.

       PvmNoGroup
	      giving a non-existent group name.

       PvmNotInGroup
	      calling process is not in specified group.

SEE ALSO

       pvm_joingroup(3PVM)

								  30 August, 1993						     BARRIER(3PVM)
All times are GMT -4. The time now is 01:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy