There are two physical files named aa and bb. Both have the same fields: TOY# & PART#. Besides these, to file aa,...
there is a field COMM. And to file bb, there is a field CATE. Now I'd like to update aa.COMM when aa.TOY#=bb.TOY# and aa.PART#=bb.PART# and bb.CATE='60'. Would you please tell how to write the SQL statement?
Assuming you want set AA.COMM equal to bb.CATE, the SQL Update statment would look something like this:
UPDATE aa SET aa.COMM = (SELECT bb.CATE FROM bb WHERE aa.TOY#=bb.TOY# and aa.PART#=bb.PART# and bb.CATE='60')
MORE INFORMATION ON THIS TOPIC
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.
Dig Deeper on DB2 UDB (universal databases)
Related Q&A from Kent Milligan
To monitor members stuck within a physical file on AS/400, you can periodically use the display file description (DSPFD) command to create an output ...continue reading
Create a host variable of the where in statement on the fly with dynamic SQL.continue reading
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.