SQL Help with update of tables in two different libraries

I have the following update statement:

 

UPDATE library1.table 

SET library1.table.field = library2.table.field

WHERE library1.table.number = library2.table.number;

 

The problem is the following error: [SQL5001]

 


Column qualifier or table &2 undefined.


Cause Text:

Name &2 was used to qualify a column name or was specified as the operand of
the RRN, PARTITION, NODENAME, or NODENUMBER scalar function. The name is not
defined to be a table designator in this SQL statement or the table
designator cannot be referenced where it is specified in the SQL statement.
If a correlation name is specified following the table name in a FROM
clause, the correlation name is considered to be the table designator. If a
correlation name is not specified, the table name is considered to be the
table designator. If using SQL naming and the table is qualified with
authorization name, then the table designator is
authorization-name.table-name. If the authorization name is not specified,
the table designator is the implicit authorization name followed by the
table name.

 

It seems to be linked to the Where clause spanning two different libraries.
Does the query have to be handled differently?  Any other ideas?

 

John A Candidi

Rutgers Insurance Companies

IT Director - Iseries Manager

856-779-2274