View previous topic :: View next topic
|
Author |
Message |
rajandhla
Active User
Joined: 18 Oct 2005 Posts: 182 Location: Luton UK
|
|
|
|
It looks quite simple but...?
A new column is added to the table using ALTER. When I query using select * I can see all the columns but when I specifically select the newly added column it's giving the error -206.
Any advice?
Cheers, |
|
Back to top |
|
|
nuthan
Active User
Joined: 26 Sep 2005 Posts: 146 Location: Bangalore
|
|
|
|
Check the column name which you have mentioned in select.
SQLCODE -206 is Column does not exist in any table in the SELECT. |
|
Back to top |
|
|
rajandhla
Active User
Joined: 18 Oct 2005 Posts: 182 Location: Luton UK
|
|
|
|
Thanks nuthan for prompt reply....
I did check the column name couple of times..it's the same name iam giving in the select
cheers |
|
Back to top |
|
|
ksk
Active User
Joined: 08 Jun 2006 Posts: 355 Location: New York
|
|
|
|
Are you mentioning the table name which has the specified colomn name? |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi There,
Can u please give us both the query as well as output. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Where are you running this query (program, spufi, etc)? |
|
Back to top |
|
|
rajandhla
Active User
Joined: 18 Oct 2005 Posts: 182 Location: Luton UK
|
|
|
|
Thanks guys for all of you...
The real problem is during altering the table new column name given/added as "ind_flag" and this became case sensitive .
It's works if i give in select as "ind_flag".... |
|
Back to top |
|
|
|