SQL/400 error. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL/400 error.

Author

Topic

dsilvapt
Starting Member

4 Posts

Posted - 2008-07-16 : 07:07:16

I'm trying to use following command on SQL/400:

UPDATE FILE1 SET FILE1.FIELD2=FILE2.FIELD2 WHERE FILE1.FIELD2<>FILE2.FIELD2

And I got a error saying Column qualifier or table FIELD2 undefined.

Any ideas?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-16 : 07:13:22

UPDATE f1
SET f1.FIELD2=f2.FIELD2
FROM FILE1 f1
JOIN FILE2 f2
ON f1.FIELD2<>f2.FIELD2

dsilvapt
Starting Member

4 Posts

Posted - 2008-07-16 : 07:19:51

F1 means file1 or field1?

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-16 : 07:20:56

quote:
Originally posted by dsilvapt

I'm trying to use following command on SQL/400:

UPDATE FILE1 SET FILE1.FIELD2=FILE2.FIELD2 WHERE FILE1.FIELD2<>FILE2.FIELD2

And I got a error saying Column qualifier or table FIELD2 undefined.

Any ideas?

...that's not SQL Server is it?