IBM Mainframe Forum

Thank you in advance for your help.

And opening a manual, or typing "sqlcode -206" in Google didn't give you any clues?

what happened when You googled for
sqlcode 206 sqlstate 42703

or looked at the manual Yourself ???

-206 Column does not exist in any table of the SELECT.

''In the case of a SELECT or DELETE statement, the specified column is not a column of any of the tables or views identified in a FROM clause in the statement''. I googled it and i found this but it is indentified.

What is "indentified"? Are you magically expecting Google or soemone to say which column specified in the SELECT is not in any of the tables specified in the SELECT? If that is the case then you are in the wrong job. YOU have to do the hard work of checking the spelling etc. (It would have taken less time than it took to write and post your problem.)

Also, as it appears to not be a COBOL problem I have moved it to a more appropriate place. Please think about where to post in future.

I checked all columns many times, it also said that the token is the ''numbers'' variable whitch i checked even more times.

IIRC
the variable name CAN NOT be equal to the column name

u right it is

number_thing
table-number-thing