Master Mainframe Technologies - COBOL, JCL, DB2, VSAM, CICS & More
ABEND Codes SQLCODEs File Status Interview Prep Contact
← Back to SQLCODE Reference
Error

SQLCODE -206

Column not in any FROM table

Explanation

The column referenced is not in any table in the FROM clause.

Solution

Verify column name, add the correct table to FROM clause, or use table alias correctly.

Example

SELECT E.NAME, D.DEPTNAME FROM EMP E -- Missing DEPT table