Get data from 3 differrnt oracle DB & then compare data


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Get data from 3 differrnt oracle DB & then compare data
Prev   Next
# 1  
Old 10-14-2008
Get data from 3 differrnt oracle DB & then compare data

Hi All,
I have a requirement to write a shell script for the following...
we have 3 different database.... lets say A, B, C
From these 3 DBs, i need to get data.. all have 3 different table...a,b, c
A.a => Emp_code, count(*)
B.b => emp_code, count(*)
C.c => emp_code, copunt(*)
Once get this information, i need to compare these 3 tables using common emp_code
For example, for emp_code=100....
A.a.count(*) = B.b.count(*) & B.b.count(*) > C.c.count(*) If it is true then no action else write to log_file.
Can you please help me how to do it... all are Oracle DB
 
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Compare data - Match first column and compare second

Hi guys, looking for some help with a way to compare data in two files but with some conditions. example, File 1 consists of site1,10.1.1.1 site2,20.2.2.2 site3,30.3.3.3 File 2 contains site1,l0.1.1.1 site2,50.1.1.1 site3,30.3.3.3 site4,40.1.1.1 I want to be able to match the... (1 Reply)
Discussion started by: mutley2202
1 Replies

2. Shell Programming and Scripting

Compare 2 files and match column data and align data from 3 column

Hello experts, Please help me in achieving this in an easier way possible. I have 2 csv files with following data: File1 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:36:09,JOB_5340 08/23/2012 12:36:14,JOB_5340 08/23/2012 12:36:22,JOB_5350 08/23/2012... (5 Replies)
Discussion started by: asnandhakumar
5 Replies

3. Shell Programming and Scripting

Sort a the file & refine data column & row format

cat file1.txt field1 "user1": field2:"data-cde" field3:"data-pqr" field4:"data-mno" field1 "user1": field2:"data-dcb" field3:"data-mxz" field4:"data-zul" field1 "user2": field2:"data-cqz" field3:"data-xoq" field4:"data-pos" Now i need to have the date like below. i have just... (7 Replies)
Discussion started by: ckaramsetty
7 Replies

4. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies

5. UNIX for Dummies Questions & Answers

Search for & edit rows & columns in data file and pipe

Dear unix gurus, I have a data file with header information about a subject and also 3 columns of n rows of data on various items he owns. The data file looks something like this: adam peter blah blah blah blah blah blah car 01 30 200 02 31 400 03 57 121 .. .. .. .. .. .. n y... (8 Replies)
Discussion started by: tintin72
8 Replies

6. Shell Programming and Scripting

How to incrementally backup data & use most recent data

Hey, dunno if the title really explains this well; basically my problem is (and this is on a router which is why the flash issue)... I have some data I want to store (it's really irelevant, i'm just counting the lines per file, basically a simple counter). I could store this data in flash but... (0 Replies)
Discussion started by: pepsi_max2k
0 Replies

7. UNIX for Dummies Questions & Answers

Howto capture data from rs232port andpull data into oracle database-9i automatically

Hi, i willbe very much grateful to u if u help me out.. if i simply connect pbx machine to printer by serial port RS232 then we find this view: But i want to capture this data into database automatically when the pbx is running.The table in database will contain similar to this view inthe... (1 Reply)
Discussion started by: boss
1 Replies
Login or Register to Ask a Question
SLAPD-SHELL(5)							File Formats Manual						    SLAPD-SHELL(5)

NAME
slapd-shell - Shell backend to slapd SYNOPSIS
/etc/ldap/slapd.conf DESCRIPTION
The Shell backend to slapd(8) executes external programs to implement operations, and is designed to make it easy to tie an existing data- base to the slapd front-end. This backend is primarily intended to be used in prototypes. WARNING
The abandon shell command has been removed since OpenLDAP 2.1. CONFIGURATION
These slapd.conf options apply to the SHELL backend database. That is, they must follow a "database shell" line and come before any subse- quent "backend" or "database" lines. Other database options are described in the slapd.conf(5) manual page. These options specify the pathname and arguments of the program to execute in response to the given LDAP operation. Each option is fol- lowed by the input lines that the program receives: add <pathname> <argument>... ADD msgid: <message id> <repeat { "suffix:" <database suffix DN> }> <entry in LDIF format> bind <pathname> <argument>... BIND msgid: <message id> <repeat { "suffix:" <database suffix DN> }> dn: <DN> method: <method number> credlen: <length of <credentials>> cred: <credentials> compare <pathname> <argument>... COMPARE msgid: <message id> <repeat { "suffix:" <database suffix DN> }> dn: <DN> <attribute>: <value> delete <pathname> <argument>... DELETE msgid: <message id> <repeat { "suffix:" <database suffix DN> }> dn: <DN> modify <pathname> <argument>... MODIFY msgid: <message id> <repeat { "suffix:" <database suffix DN> }> dn: <DN> <repeat { <"add"/"delete"/"replace">: <attribute> <repeat { <attribute>: <value> }> - }> modrdn <pathname> <argument>... MODRDN msgid: <message id> <repeat { "suffix:" <database suffix DN> }> dn: <DN> newrdn: <new RDN> deleteoldrdn: <0 or 1> <if new superior is specified: "newSuperior: <DN>"> search <pathname> <argument>... SEARCH msgid: <message id> <repeat { "suffix:" <database suffix DN> }> base: <base DN> scope: <0-2, see ldap.h> deref: <0-3, see ldap.h> sizelimit: <size limit> timelimit: <time limit> filter: <filter> attrsonly: <0 or 1> attrs: <"all" or space-separated attribute list> unbind <pathname> <argument>... UNBIND msgid: <message id> <repeat { "suffix:" <database suffix DN> }> dn: <bound DN> Note that you need only supply configuration lines for those commands you want the backend to handle. Operations for which a command is not supplied will be refused with an "unwilling to perform" error. The search command should output the entries in LDIF format, each entry followed by a blank line, and after these the RESULT below. All commands except unbind should then output: RESULT code: <integer> matched: <matched DN> info: <text> where only the RESULT line is mandatory. Lines starting with `#' or `DEBUG:' are ignored. ACCESS CONTROL
The shell backend does not honor all ACL semantics as described in slapd.access(5). In general, access to objects is checked by using a dummy object that contains only the DN, so access rules that rely on the contents of the object are not honored. In detail: The add operation does not require write (=w) access to the children pseudo-attribute of the parent entry. The bind operation requires auth (=x) access to the entry pseudo-attribute of the entry whose identity is being assessed; auth (=x) access to the credentials is not checked, but rather delegated to the underlying shell script. The compare operation requires read (=r) access (FIXME: wouldn't compare (=c) be a more appropriate choice?) to the entry pseudo-attribute of the object whose value is being asserted; compare (=c) access to the attribute whose value is being asserted is not checked. The delete operation does not require write (=w) access to the children pseudo-attribute of the parent entry. The modify operation requires write (=w) access to the entry pseudo-attribute; write (=w) access to the specific attributes that are modi- fied is not checked. The modrdn operation does not require write (=w) access to the children pseudo-attribute of the parent entry, nor to that of the new par- ent, if different; write (=w) access to the distinguished values of the naming attributes is not checked. The search operation does not require search (=s) access to the entry pseudo_attribute of the searchBase; search (=s) access to the attributes and values used in the filter is not checked. EXAMPLE
There is an example search script in the slapd/back-shell/ directory in the OpenLDAP source tree. LIMITATIONS
The shell backend does not support threaded environments. When using the shell backend, slapd(8) should be built --without-threads. FILES
/etc/ldap/slapd.conf default slapd configuration file SEE ALSO
slapd.conf(5), slapd(8), sh(1). OpenLDAP 2012/04/23 SLAPD-SHELL(5)