×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I messed up a column of my test data. I have another table that has the
correct data I would like to fix the original table with. Since the column
was a key field I messed up, I have to match the records by RRN. (Other
values in the matching records are different, and this is why I can't just
do a straight CPYF.) I've tried several variations of the following:
update Lib1/Customer a
Set a.cmcust = (select z.cmcust from Lib2/Customer z
where RRN(a) = RRN(z) )
In all cases, I'm getting SQL5001 (Column qualifier or table A undefined.)
I know I can write an RPG program to do this in probably 5 minutes, but am
asking here to try to expand my working knowledge of SQL.
TIA,
- Dan
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
