Extracting differences between two columns dataset (SQL command)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Selecting random columns from large dataset in UNIX

Dear folks I have a large data set which contains 400K columns. I decide to select 50K determined columns from the whole 400K columns. Is there any command in unix which could do this process for me? I need to also mention that I store all of the columns id in one file which may help to select...

2. Shell Programming and Scripting

Need UNIX command to create a empty dataset

Hi all, Is Der any unix command which will create a empty dataset ..?(in .ds ).I know we can use orchadmin dump command to view dataset data.. but how to create a dataset..? like sampledataset.ds thanks in advance hemanthsaikumar

3. Shell Programming and Scripting

Request: How to Parse dynamic SQL query to pad extra columns to match the fixed number of columns

Hello All, I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns. So my requirement is to generate a output query which will have 20 columns all the...

4. UNIX for Dummies Questions & Answers

Extracting combined differences based on a single column

Dear All, I have two sets of files. File 1 can be any number between 1 and 20 followed by a frequency of that number in a give documents... the lines in the file will be dependent to the analysed document. e.g. file1 1,5 4,1 then I have file two which is basicall same numbers but with...

5. Shell Programming and Scripting

Extracting data from SQL using a variable from a file

Though, its not new, I am a newbie to shell scripting. Please help me with the below. There are two steps. First one is to read a table and create a file with the distinct values. I am able to get this done. Second step is to read the file (which has the single value, like a number) and...

6. Solaris

flarecreate for zfs root dataset and ignore multiple dataset

Hi All, I want to write a script to create flar images on multiple servers. In non zfs filesystem I am using -X option to refer a file to exclude mounts on different servers. but on ZFS -X option is not working. I want multiple mounts to be ignore on ZFS base system during flarecreate. I...

7. Shell Programming and Scripting

Extracting only a few columns!!!?

Hi All, I have a text file which looks like below. ################################################ Name:xxxxxxx Version:1.0 Class: 2 City : Bangalore Component Part Action Nb New Part Naming Part Name 12345 default 12345.12345 Bad 23456 ...

8. UNIX for Dummies Questions & Answers

Using 'sed' to delete or ignore columns in a dataset

Hi, I want to know if its possible to delete or ignore columns in a large dataset using 'sed'. For example, I have the following dataset: - 20060714,X.XX,1,043004,Q,T,24.0000,1,25.5000,4, 20060714,X.XX,1,081209,Q,T,24.0000,1,25.5000,5, As you can see, there are 10 columns here and the...

9. Shell Programming and Scripting

Need help in extracting columns

Hi , I have a file having around 8 columns spereated by space . Now that I need to extract columns from this. The problem is this functionality is needed in a script and the required columns are dynamic and can range from 2 columns to 8 columns at a time . What I tried without luck is ...

10. UNIX for Dummies Questions & Answers

Using 'sed' to delete or ignore columns in a dataset

Hi, I've already posted elsewhere but am posting again here coz im a newbie. I hope you forgive me this time. I want to know if its possible to delete or ignore columns in a large dataset using 'sed'. For example, I have the following dataset: - ...

LEARN ABOUT DEBIAN

sqlt-diff

SQLT-DIFF(1p)						User Contributed Perl Documentation					     SQLT-DIFF(1p)

NAME

       sqlt-diff - find the differences b/w two schemas

SYNOPSIS

       For help:

	 sqlt-diff -h|--help

       For a list of all valid parsers:

	 sqlt -l|--list

       To diff two schemas:

	 sqlt-diff [options] file_name1=parser1 file_name2=parser2

       Options:

	 -d|--debug   Show debugging info
	 -t|--trace   Turn on tracing for Parse::RecDescent
	 -c|--case-insensitive	 Compare tables/columns case-insensitively
	 --ignore-index-names	 Ignore index name differences
	 --ignore-constraint-names   Ignore constraint name differences
	 --mysql_parser_version=<#####> Specify a target MySQL parser version
					for dealing with /*! comments
	 --output-db=<Producer>  This Producer will be used instead of one
				 corresponding to parser1 to format output
				 for new tables
	 --ignore-view-sql    Ignore view SQL differences
	 --ignore-proc-sql    Ignore procedure SQL differences
	 --no-batch-alters    Do not clump multile alters to the same table into a
			      single ALTER TABLE statement where possible.
	 --quote=<character>  Use <character> to quote all table and field
			      names in statements

DESCRIPTION

       sqlt-diff is a utility for creating a file of SQL commands necessary to transform the first schema provided to the second.  While not yet
       exhaustive in its ability to mutate the entire schema, it will report the following

       o   New tables

	   Using the Producer class of the target (second) schema, any tables missing in the first schema will be generated in their entirety
	   (fields, constraints, indices).

       o   Missing/altered fields

	   Any fields missing or altered between the two schemas will be reported as:

	     ALTER TABLE <table_name>
	       [DROP <field_name>]
	       [CHANGE <field_name> <datatype> (<size>)] ;

       o   Missing/altered indices

	   Any indices missing or of a different type or on different fields will be indicated.  Indices that should be dropped will be reported
	   as such:

	     DROP INDEX <index_name> ON <table_name> ;

	   An index of a different type or on different fields will be reported as a new index as such:

	     CREATE [<index_type>] INDEX [<index_name>] ON <table_name>
	       ( <field_name>[,<field_name>] ) ;

       ALTER, CREATE, DROP statements are created by SQL::Translator::Producer::*, see there for support/problems.

       Currently (v0.0900), only MySQL is supported by this code.

AUTHOR

       Ken Youens-Clark <kclark@cpan.org>.

SEE ALSO

       SQL::Translator, <http://sqlfairy.sourceforge.net>.

perl v5.14.2							    2012-01-18							     SQLT-DIFF(1p)

Programming