Sponsored Content
Full Discussion: SQL Issue please respond !!!
Top Forums Programming SQL Issue please respond !!! Post 302303581 by Haque123 on Friday 3rd of April 2009 03:19:18 AM
Old 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

SQL scripts not running, possible timeout issue?

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

KSH script SQL timeout issue

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

SQL IF-THEN-ELSE issue

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

SQL Developer JOINS / GROUP BY issue.

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

Issue in SQL Loader scripts

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

Sql issue in shell 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

Issue with SQL UNIX shell script -

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

Issue with quotes when running SQL command from within su -c

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

awk concatenation issue - SQL generation

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
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)
All times are GMT -4. The time now is 10:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy