Sponsored Content
Top Forums Shell Programming and Scripting executing mysql load statement from shell script Post 302279109 by DILEEP410 on Thursday 22nd of January 2009 02:18:57 AM
Old 01-22-2009
MySQL

I did it, haven't found anything.
Anyway let's keep on trying.if you got any idea or info about this,please update this thread

Thanks mate, you provided very useful information.

With Regards
Dileep Pattayath
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to write DB2 Load Utility in Shell script

Hi, I am a beginner. I need an example of using DB2 Load Utility in Shell script. I appreciate if anyone could help me about it. Thanks, Paris (0 Replies)
Discussion started by: parisbeginner
0 Replies

2. Shell Programming and Scripting

Need help in wrting Load Script for a Load-Resume type of load.

hi all need your help. I am wrting a script that will load data into the table. then on another load will append the data into the existing table. Regards Ankit (1 Reply)
Discussion started by: ankitgupta
1 Replies

3. Shell Programming and Scripting

Executing a Oracle SQL statement in a UNIX script

Hi All, I need to select one column from a table based upon the passed in parameter. I tried this: sqlplus -silent $MISP_USER << EOF set feedback off; set verify off; set sqlprompt "" SELECT mail_flag FROM dailyjobs WHERE job_name = '$1'; exit 0 EOF exit... (1 Reply)
Discussion started by: ganga.dharan
1 Replies

4. Shell Programming and Scripting

sh and MySQL LOAD DATA

I have a csv file in a folder that is roughly 500,000 rows long. Rather than using PHP, I would like to use SH to run a MYSQL LOAD DATA command to load the data in, as I think it would be much faster and would not cause any memory problems associated with PHP. But the problem is, I am not... (18 Replies)
Discussion started by: worchyld
18 Replies

5. Shell Programming and Scripting

shell script to create disk load

friends , need a shell script to create a disk load. can any one pls guide me with how this can be implemented. Pls provide the concept. from there i will try to design my script. (3 Replies)
Discussion started by: achak01
3 Replies

6. Homework & Coursework Questions

Problem with executing a possible if or case statement script

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: Create a phonebook program. It should use functions to perform the required tasks. It should be menu-based,... (1 Reply)
Discussion started by: Rgasin02
1 Replies

7. Programming

Sybase load statement issue

hi, I am trying to load a sybase table using a file ( unit separator is the delimiter) which is in IQ server. I Used load statment as below execute ('LOAD TABLE schemaname.tablename (' || ' name, age, date, Symbols) from ' || ' '' /filepath/file.txt '' ' || ' QUOTES off ' || ' DELIMITED... (0 Replies)
Discussion started by: irudayaraj
0 Replies

8. Shell Programming and Scripting

ERROR in executing mysql querys in shell scripting

Hi All, Please see the below script for mysql 3 commands. Its giving me the right output for all three commands but showing some errors in first two commands , i guess there might be an issue with date. Can anyone help me . #! /bin/bash TABLE_NAME=testingddatabase USER_NAME=root... (3 Replies)
Discussion started by: aish11
3 Replies

9. Shell Programming and Scripting

Balance the load of files across queues using shell script

Hi, I need to balance the load to be processed by the system using shell script. The scenario is like below: Suppose there are some files in a directory: -rw-rw-r-- 1 usr usrgrp 456432306 Oct 23 07:53 abc_queue_q1 -rw-rw-r-- 1 usr usrgrp 4123934 Oct 23 07:53... (1 Reply)
Discussion started by: vsachan
1 Replies

10. Shell Programming and Scripting

How to keep staying on remote server after executing a shell script with if then exit end statement?

i have a "if .. then exit end " in s shell script on remote servers. now the connection to the remote server got killed after i run this script on the remote servers. How do i run this script on remote hosts and still keep remote connections alive after executing the script. Thank you. (10 Replies)
Discussion started by: moonmonk
10 Replies
clm mate(1)							  USER COMMANDS 						       clm mate(1)

  NAME
      clm mate - compute best matches between two clusterings

      clmmate  is not in actual fact a program. This manual page documents the behaviour and options of the clm program when invoked in mode mate.
      The options -h, --apropos, --version, -set, --nop are accessible in all clm modes. They are described in the clm manual page.

  SYNOPSIS
      clm mate [-o fname (output file name)] [-b (omit headers)] [--one-to-many (require multiple hits in <clfile1>)] [-h (print synopsis,  exit)]
      [--apropos (print synopsis, exit)] [--version (print version, exit)] <clfile1> <clfile2>

  DESCRIPTION
      clm  mate computes for each cluster X in clfile1 all clusters Y in clfile2 that have non-empty intersection and outputs a line with the data
      points listed below.

	 overlap(X,Y)		    # 2 * size(meet(X,Y)) / (size(X)+size(Y))
	 index(X)		    # name of cluster
	 index(Y)		    # name of cluster
	 size(meet(X,Y))
	 size(X-Y)		    # size of left difference
	 size(Y-X)		    # size of right difference
	 size(X)
	 size(Y)
	 projection(X, clfile2)     # see below
	 projection(Y, clfile1)     # see below

      The projected size of a cluster X relative to a clustering K is simply the sum of all the nodes shared between any cluster Y  in	K  and	X,
      duplications allowed. For example, the projected size of (0,1) relative to {(0,2,4), (1,4,9), (1,3,5)} equals 3.

      The  overlap  between X and Y is exactly 1.0 if the two clusters are identical, and for nearly identical clusterings the score will be close
      to 1.0.

      All of this information can also be obtained from the contingency matrix defined for two clusterings.  The [i,j] row-column entry in a  con-
      tigency  matrix  between	to clusterings gives the number of entries in the intersection between cluster i and cluster j from the respective
      clusterings. The other information is implicitly present; the total number of nodes in clusters i and j for example can be obtained  as  the
      sum  of  entries	in row i and column j respectively, and the difference counts can then be obtained by substracting the intersection count.
      The contingency matrix can easily be computed using mcx; e.g.

      mcx /clfile2 lm /clfile1 lm tp mul /ting wm

      will create the contingency matrix in mcl matrix format in the file ting, where columns range over the clusters in clfile1.

      The output can be put to good use by sorting it numerically on that first score field. It is advisable to use a stable sort routine (use the
      -s option for UNIX sort) From this information one can quickly extract the closest clusters between two clusterings.

  OPTIONS
      -o fname (output file name)
	Specify the name of the output file.

      -b (omit headers)
	Batch mode, omit column names.

      --one-to-many (require multiple hits in <clfile1>)
	Do not output information for clusters in the first file that are subset of a cluster in the second file.

  AUTHOR
      Stijn van Dongen.

  SEE ALSO
      mclfamily(7) for an overview of all the documentation and the utilities in the mcl family.

  clm mate 12-068						      8 Mar 2012							 clm mate(1)
All times are GMT -4. The time now is 02:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy