← All errors

SQLCODE -203

SQL0203 Name is ambiguous

IBM message text
Name &1 is ambiguous.
SQLCODE
-203
SQLSTATE
42702

Most common cause

In a join a column with the same name exists in several tables and is not qualified.

Other causes

  • DDS files with the same field names in different files.

How to fix it

Qualify the column with the table's correlation name (c.CODE).

Related errors

Text and codes from IBM documentation for 7.6. Checked on .