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 ULTRIX

diffmk

diffmk(1)						      General Commands Manual							 diffmk(1)

Name
       diffmk - mark differences between files

Syntax
       diffmk name1 name2 name3

Description
       The  command compares two versions of a file and creates a third file that includes ``change mark'' commands for or The name1 and name2 are
       the old and new versions of the file.  The command generates name3, which contains the lines of	name2  plus  inserted  formatter  ``change
       mark''  (.mc) requests.	When name3 is formatted, changed or inserted text is shown by | at the right margin of each line.  The position of
       deleted text is shown by a single *.

       The command can be used to produce listings of C (or other) programs with changes marked.  A typical command line for such use is the  fol-
       lowing:
       diffmk old.c new.c tmp; nroff macs tmp | pr
       In this example the file macs contains:

	      .pl 1
	      .ll 77
	      .nf
	      .eo
	      .nc `

       The  .ll request might specify a different line length, depending on the nature of the program being printed.  The .eo and .nc requests are
       probably needed only for C programs.

       If the characters | and * are inappropriate, a copy of can be edited to change them.  The command is a shell procedure.

Restrictions
       Aesthetic considerations may dictate manual adjustment of some output.  File differences involving only	formatting  requests  may  produce
       undesirable output, that is, replacing .sp by .sp 2 will produce a ``change mark'' on the preceding or following line of output.

See Also
       cmp(1), comm(1), diff(1), nroff(1), join(1), sccsdiff(1), troff(1), uniq(1)

																	 diffmk(1)

Programming