04-03-2009
SQL Issue please respond !!!
Hi Folks,
I have a issue regards space in the records.
Example:
999207404 |sp818056|STEVEN |LAWRENCE |Mike.S.Lawrence@sprint.com |2003 S Data Sales Mgr 77 |SVC |1000000034|SVC-EN-SOL SUPPORT |2000120016|SVC-SOL ENG-WEST |2000113271|SVC-SOL SUP-VAN DEN |2000122863|0
Is the single row I need to remove the extrax spacese from entier records.
Expected o/p is:
999207404|sp818056|STEVEN|LAWRENCE|Mike.S.Lawrence@sprint.com |2003 S Data Sales Mgr 77|SVC|1000000034|SVC-EN-SOL SUPPORT |2000120016|SVC-SOL ENG-WEST|2000113271|SVC-SOL SUP-VAN DEN|2000122863|0
Please suggest your answers as soon as possible!!!
Rgds
Ann
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am a novice Unix scripter and need a little advice/help on a script I've written that's causing some problems. We are using Solaris 9 on a Sun box and the script is invoked with the korn shell. I have a two-part question: I wrote a shell script that calls and executes 3 separate sql scripts,... (3 Replies)
Discussion started by: E2004
3 Replies
2. Shell Programming and Scripting
Hi all,
I have a KSH script which is kicking off an sql scripts as follows:
/usr/local/installs/instantclient_10_2/sqlplus -s username/password @$sql_path/sql_query.sql > $tmp_path/sql_query_results
The problem I have is that sometimes the 10g Oracle Database spits out an error saying... (4 Replies)
Discussion started by: Donkey25
4 Replies
3. Programming
Hi All,
I have a table with the following columns:
sysName, date, time, cpuNum, cpuPercentageBsy
There are multiple system names and multiple CPU numbers.
I need to produce a report that shows the cpuPercentageBsy for cpuNum's 0 and 1 and then an average of cpuPercentageBsy for all the... (1 Reply)
Discussion started by: pondlife
1 Replies
4. Programming
Am having a nightmare with a certain piece of code.. have tried almost everything and just cannot see what the issue is..
CREATE OR REPLACE VIEW TOP_EARNER_PER_LOCATION
AS
SELECT E.FIRST_NAME || ' ' || E.LAST_NAME AS EMPLOYEE_NAME,
L.REGIONAL_GROUP AS REGIONAL_GROUP,
... (1 Reply)
Discussion started by: U_C_Dispatj
1 Replies
5. Shell Programming and Scripting
Hi,
I'm planning to load the data from FLAT files into tables.
Source file: more input.txt
LRNO|Bale|Horsepower|NumberOfBarges|BollardPull|NumberOfCars|GasCapacity|GrainCapacity|IndicatedHorsepower|LiquidCapacity|... (6 Replies)
Discussion started by: shyamu544
6 Replies
6. Shell Programming and Scripting
HI friends , i am also facing an issue in mysql
i ma trying to insert detail in a variable but not got success
#!/bin/sh
mysql -u<username> -p<password> <dbname> << EOF
DEV=`mysql --skip-column-names <dbname> -e "SELECT timestamp from process_record where id = 1"`
EOF
echo $DEV
ERROR... (3 Replies)
Discussion started by: sanjay833i
3 Replies
7. Shell Programming and Scripting
Hi all
I am writing a shell script which will run a select query from a table . If the ouput is not 500 - then send a email to the team saying there is a error . But i am not sure how to redirect this output of the select query to the log file -
#!/bin/ksh
sqlplus /nolog
conect... (1 Reply)
Discussion started by: honey26
1 Replies
8. Shell Programming and Scripting
RHEL 6.2/Bash shell
root user will be executing the below script. It switches to oracle user logs in using sqlplus and tries to
run the below UPDATE statement. All the commands after su -c are enclosed in a single quote delimited by semicolon.
The execution has failed because the quotes... (3 Replies)
Discussion started by: omega3
3 Replies
9. Shell Programming and Scripting
Greetings Experts,
I have an excel file and I am unable to read it directly into awk (contains , " etc); So, I cleansed and copied the data into notepad.
I need to generate a script that generates the SQL.
Requirement:
1. Filter and select only the data that has the "mapping" as "direct"... (4 Replies)
Discussion started by: chill3chee
4 Replies
LEARN ABOUT DEBIAN
svm-train
svm-train(1) User Manuals svm-train(1)
NAME
svm-train - train one or more SVM instance(s) on a given data set to produce a model file
SYNOPSIS
svm-train [-s svm_type ] [ -t kernel_type ] [ -d degree ] [ -g gamma ] [ -r coef0 ] [ -c cost ] [ -n nu ] [ -p epsilon ] [ -m cachesize ] [
-e epsilon ] [ -h shrinking ] [ -b probability_estimates ] ] [ -wi weight ] [ -v n ] [ -q ]
training_set_file [ model_file ]
DESCRIPTION
svm-train trains a Support Vector Machine to learn the data indicated in the training_set_file
and produce a model_file
to save the results of the learning optimization. This model can be used later with svm_predict(1) or other LIBSVM enabled software.
OPTIONS
-s svm_type
svm_type defaults to 0 and can be any value between 0 and 4 as follows:
0 -- C-SVC
1 -- nu-SVC
2 -- one-class SVM
3 -- epsilon-SVR
4 -- nu-SVR
-t kernel_type
kernel_type defaults to 2 (Radial Basis Function (RBF) kernel) and can be any value between 0 and 4 as follows:
0 -- linear: u.v
1 -- polynomial: (gamma*u.v + coef0)^degree
2 -- radial basis function: exp(-gamma*|u-v|^2)
3 -- sigmoid: tanh(gamma*u.v + coef0)
4 -- precomputed kernel (kernel values in training_set_file) --
-d degree
Sets the degree of the kernel function, defaulting to 3
-g gamma
Adjusts the gamma in the kernel function (default 1/k)
-r coef0
Sets the coef0 (constant offset) in the kernel function (default 0)
-c cost
Sets the parameter C ( cost ) of C-SVC, epsilon-SVR, and nu-SVR (default 1)
-n nu Sets the parameter nu of nu-SVC, one-class SVM, and nu-SVR (default 0.5)
-p epsilon
Set the epsilon in the loss function of epsilon-SVR (default 0.1)
-m cachesize
Set the cache memory size to cachesize in MB (default 100)
-e epsilon
Set the tolerance of termination criterion to epsilon (default 0.001)
-h shrinking
Whether to use the shrinking
heuristics, 0 or 1 (default 1)
-b probability-estimates
probability_estimates is a binary value indicating whether to calculate probability estimates when training the SVC or SVR model.
Values are 0 or 1 and defaults to 0 for speed.
-wi weight
Set the parameter C (cost) of class i to weight*C, for C-SVC (default 1)
-v n Set n for n -fold cross validation mode
-q quiet mode; suppress messages to stdout.
FILES
training_set_file must be prepared in the following simple sparse training vector format:
<label> <index1>:<value1> <index2>:<value2> . . .
.
.
.
There is one sample per line. Each sample consists of a target value (label or regression target) followed by a sparse representation of
the input vector. All unmentioned coordinates are assumed to be 0. For classification, <label> is an integer indicating the class label
(multi-class is supported). For regression, <label> is the target value which can be any real number. For one-class SVM, it's not used so
can be any number. Except using precomputed kernels (explained in another section), <index>:<value> gives a feature (attribute) value.
<index> is an integer starting from 1 and <value> is a real number. Indices must be in an ASCENDING order.
ENVIRONMENT
No environment variables.
DIAGNOSTICS
None documented; see Vapnik et al.
BUGS
Please report bugs to the Debian BTS.
AUTHOR
Chih-Chung Chang, Chih-Jen Lin <cjlin@csie.ntu.edu.tw>, Chen-Tse Tsai <ctse.tsai@gmail.com> (packaging)
SEE ALSO
svm-predict(1), svm-scale(1)
Linux MAY 2006 svm-train(1)