The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
:-) 1213: Character to numeric conversion error. Plz help :-) 1213: Character to numeric conversion error. Plz help
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Conversion of Exponential to numeric in awk- not correct output ssunda6 Shell Programming and Scripting 3 09-19-2008 01:36 AM
character set conversion in unix C gucho High Level Programming 1 03-01-2008 08:27 AM
error during run: St9bad_alloc - Getting this error while using some conversion progr sathu_pec Shell Programming and Scripting 1 01-21-2008 02:38 AM
Bourne: search for a non-numeric character in $VAR lumix Shell Programming and Scripting 2 12-14-2007 02:13 PM
character conversion sunil bajaj UNIX for Dummies Questions & Answers 3 04-15-2002 11:48 PM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 07-07-2008
anushree.a anushree.a is offline
Registered User
  
 

Join Date: May 2008
Posts: 87
:-) 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 (permalink)  
Old 07-07-2008
zaxxon's Avatar
zaxxon zaxxon is offline Forum Staff  
Moderator
  
 

Join Date: Sep 2007
Location: Germany
Posts: 2,257
Try out putting the value into single quotation marks like this:
Code:
echo "select status_ac from db_acct where acct_num='AAA000337'" | ...
  #3 (permalink)  
Old 07-07-2008
anushree.a anushree.a is offline
Registered User
  
 

Join Date: May 2008
Posts: 87
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
Sponsored Links
Closed Thread

Bookmarks

« Toggle Hidden Files Mac OS X | Pls Pls do help me »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Linear Mode Linear Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 04:35 PM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language translation by Google.
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0