Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

:-) 1213: Character to numeric conversion error. Plz help

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting :-) 1213: Character to numeric conversion error. Plz help
# 1  
Old 07-07-2008
:-) 1213: Character to numeric conversion error. Plz help
Dear friends,
I am new to Unix/Linux. I am trying to run following query but getting an error msg... Please can u people help me in this?

Query:
echo "select status_ac from db_acct where acct_num=AAA000337" | dbaccess elstest

Error:
217: Column (amd000337) not found in any table in the query (or SLV is undefined).



And if i provide acct_num a complete numeric value then getting following error
Error:
1213: Character to numeric conversion error

Cheched everything, i mean checked name of table, colomn and acct_num. Its perfect.

Please help me guys

Thanx in advance
Anushree.
# 2  
Old 07-07-2008
Try out putting the value into single quotation marks like this:
Code:
echo "select status_ac from db_acct where acct_num='AAA000337'" | ...

# 3  
Old 07-08-2008
Ohhh Buddy, thanx a lot.. finally it worked, i was trying putting it in double quotes instead of single. ... Thank god u saved me.. God bless u dear...
Cheerzzz
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract all first numeric character from a string

Hello, I have a file of strings a below:- 4358RYFHD9845 28/COC/UYF984 9834URD 98HJDU I need to extract all the first numeric character of every sting as follows:- 4358 28 9834 thanks to suggest ASAP Regards, Jasi Use code tags, thanks. (7 Replies)
Discussion started by: jassi10781
7 Replies

2. Shell Programming and Scripting

String variable to numeric conversion in perl

Hi guys I am having this strange issue.Well my requirement is like below Compare two values between flat file and oracle DB Via perl script I am easily getting the rowcount Now I connect sql plus via perl and the column value that returns is string my $sqlplus_settings = ''; my... (7 Replies)
Discussion started by: Pratik4891
7 Replies

3. Shell Programming and Scripting

script for month conversion in numeric format

Hi Experts, How to convert months into numeric format with the help of some script: Suppose I want: " Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec " to be converted as : " 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 " Thanks in... (2 Replies)
Discussion started by: rveri
2 Replies

4. Shell Programming and Scripting

validating a input file for numeric and character

i have a input file like this 001|rahim|bajaj|20090102 while reading the file i need to check whether the first column is a number second column is a name is there any methodology to check for the same thanks in advance (2 Replies)
Discussion started by: trichyselva
2 Replies

5. Shell Programming and Scripting

check whether it is a non-numeric character

Below is the abstract of the script which is working fine. if ] then error_process "Invalid month format." return 1 fi I am doing validation for month and it errors if the value is > 12 or < 0. In addition, I want to add another condition to error if it... (2 Replies)
Discussion started by: sony_dada
2 Replies

6. Shell Programming and Scripting

Conversion of Exponential to numeric in awk- not correct output

Hi All, I have 1 million records file. Using awk, I am counting the number of records. But as the number is huge, after crossing a number, awk is displaying it in exponential format. At the end, I need to verify this count given by awk with expected count. But as it is in exponential format,... (3 Replies)
Discussion started by: ssunda6
3 Replies

7. Programming

character set conversion in unix C

Hi, Could anybody explain how to change the character set of a particular string in C in unix. we are using HP-UX as OS. We require to change the input string which is in cp1250 format to utf-8. A sample code would help. Thnx in advance (1 Reply)
Discussion started by: gucho
1 Replies

8. Shell Programming and Scripting

Bourne: search for a non-numeric character in $VAR

if $1 = "123x456", how can I test for the non-numeric character 'x' in that string. I've tried expr with "" but it did not find the x. Any ideas? Can this perhaps be done with sed? Thanks. (2 Replies)
Discussion started by: lumix
2 Replies

9. UNIX for Dummies Questions & Answers

character conversion

how do i convert lower case characters entered via user through screen into upper case and vice-versa in Cshell. is there a function available for this (3 Replies)
Discussion started by: sunil bajaj
3 Replies
Login or Register to Ask a Question