The UNIX and Linux Forums  


Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #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.