Sponsored Content
Top Forums Shell Programming and Scripting Get data from 3 differrnt oracle DB & then compare data Post 302246693 by Amit.Sagpariya on Tuesday 14th of October 2008 06:37:33 AM
Old 10-14-2008
In addition,

all these 3 table contains more than 100 emp_code...

emp_code Table A.a count Table B.b Count Table C.C count
100 5748 5748 5040
201 2771 2771 1274
202 34 20 13

In this case emp_code 100 & 201 is tru but for 202 it is not tru so that i should be in log file. I also wanted to know how to retrive all information from differenbt table & store it into variable. For one value (emp_code) we can do.. but how about more than 100 emp_code to store in variable & then need to compare?
 

7 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

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. 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

6. 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

7. 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
niscat(1)							   User Commands							 niscat(1)

NAME
niscat - display NIS+ tables and objects SYNOPSIS
niscat [-AhLMv] [-s sep] tablename... niscat [-ALMP] -o name... DESCRIPTION
In the first synopsis, niscat displays the contents of the NIS+ tables named by tablename. In the second synopsis, it displays the inter- nal representation of the NIS+ objects named by name. Columns without values in the table are displayed by two adjacent separator characters. OPTIONS
The following options are supported: -A Displays the data within the table and all of the data in tables in the initial table's concatenation path. -h Displays the header line prior to displaying the table. The header consists of the `#' (hash) character followed by the name of each column. The column names are separated by the table separator character. -L Follows links. When this option is specified, if tablename or name names a LINK type object, the link is followed and the object or table named by the link is displayed. -M Master server only. This option specifies that the request should be sent to the master server of the named data. This guaran- tees that the most up-to-date information is seen at the possible expense of increasing the load on the master server and increasing the possibility of the NIS+ server being unavailable or busy for updates. -o name Displays the internal representation of the named NIS+ object(s). If name is an indexed name (see nismatch(1)), then each of the matching entry objects is displayed. This option is used to display access rights and other attributes of individual columns. -P Follows concatenation path. This option specifies that the request should follow the concatenation path of a table if the ini- tial search is unsuccessful. This option is only useful when using an indexed name for name and the -o option. -s sep This option specifies the character to use to separate the table columns. If no character is specified, the default separator for the table is used. -v Displays binary data directly. This option displays columns containing binary data on the standard output. Without this option binary data is displayed as the string *BINARY*. EXAMPLES
Example 1 Displaying the Contents of the Hosts Table The following example displays the contents of the hosts table: example% niscat -h hosts.org_dir # cname name addr comment client1 client1 192.168.201.100 Joe Smith crunchy crunchy 192.168.201.44 Jane Smith crunchy softy 192.168.201.44 The string *NP* is returned in those fields where the user has insufficient access rights. Example 2 Displaying on the Standard Output The following displays the passwd.org_dir on the standard output. example% niscat passwd.org_dir Example 3 Displaying Table Contents Display the contents of table frodo and the contents of all tables in its concatenation path. example% niscat -A frodo Example 4 Displaying Table Entries The following example diisplays the entries in the table groups.org_dir as NIS+ objects. Notice that the brackets are protected from the shell by single quotes. example% niscat -o '[ ]groups.org_dir' Example 5 Displaying the Table Object The following example displays the table object of the passwd.org_dir table. example% niscat -o passwd.org_dir The previous example displays the passwd table object and not the passwd table. The table object includes information such as the number of columns, column type, searchable or not searchable separator, access rights, and other defaults. Example 6 Displaying the Directory Object The following example displays the directory object for org_dir, which includes information such as the access rights and replica informa- tion. example% niscat -o org_dir ENVIRONMENT VARIABLES
NIS_PATH If this variable is set, and the NIS+ table name is not fully qualified, each directory specified will be searched until the table is found (see nisdefaults(1)). EXIT STATUS
niscat returns the following values: 0 Successful completion 1 An error occurred. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWnisu | +-----------------------------+-----------------------------+ SEE ALSO
NIS+(1), nisdefaults(1), nismatch(1), nistbladm(1), nis_objects(3NSL), nis_tables(3NSL), attributes(5) NOTES
NIS+ might not be supported in future releases of the Solaris operating system. Tools to aid the migration from NIS+ to LDAP are available in the current Solaris release. For more information, visit http://www.sun.com/directory/nisplus/transition.html. SunOS 5.11 2 Dec 2005 niscat(1)
All times are GMT -4. The time now is 10:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy