Why does SELECT ColumnName throws up SQLSTATE 42703 error?

[Vandhana]

I set up Aqua Data Studio (Trial) version and DB2 Express edition along with control center and command line tools. I created the database using the Command line tool. And then went on to create a new schema and tables in Aqua data. After importing all my data into the tables, I realized only "select * from ..." works but wen I try to mention a specific column name as in "select price_date from .." I get an error back SQLCODE = -206 SQLSTATE = 42703. I also tried using a qualifier for the coloums like table_name.colu mn_name and also alias, it still doesn't help. Then I tried dropped the tables and schema( lost all data) and created the same using the command centre. And I was able to access the columns using a simple select. But now I want to create a stored proc, I am not sure how to run it from the command center and Aqua data wouldn't let me do it...I land up on the same problem as before. It somehow recognizes my tables but not my columns. Any alternative to Aqua data or how I should run stored procs on DB2 using CLP ? It would be best if I could fix the SQLSTATE = 42703 problem asap as the evaluation perios will expire soon.
In short

select * from BSE500DTA.STK_P RICE_RAW_DTA fetch first 100 rows only (WORKS)

select co_code from BSE500DTA.STK_P RICE_RAW_DTA fetch first 100 rows only (DOES NOT WORK)

[pramodds]

Try this

select \"co_code\" from BSE500DTA.STK_P RICE_RAW_DTA fetch first 100 rows only

Try to give the cloumn name from this o/p

db2 describe table <tabschema>.<ta bname>
whatever is the o/p for "column co_code" use that exactly in the above statement.


Cheers
Pramod