01-22-2009
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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
clmmate
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)