|
:-) 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.
|