AW: SQL Help with update of tables in two different libraries

["BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx>]

Hi,

I assume you are working with *SYS-Naming and not with *SQL-Naming what you
used in your Statement.
Just try to change the syntax as follows:
UPDATE library1/table 
   SET library1/table.field  = library2/table.field
 WHERE library1/table.number = library2/table.number;

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok) 



-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von John Candidi
Gesendet: Tuesday, January 16, 2007 18:53
An: 'Midrange Systems Technical Discussion'
Betreff: 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