I want to update a Client Category Code in the Client_Table where the Client has a specific Country Code AND and the Clients VAT No is Blank, Which is in The Client_Account Table in another Library.
The Matched Records are [LIBRARY1]FILE1.CLLDRS and [LIBRARY2]FILE2.ADLDRS
So Update [LIBRARY1]FILE1 SET CATCDE='EXM' where FILE1.CTRY = 'US' and [LIBRARY2]File2.VATNO =NULL.
I know the above syntax isn't correct. but can anyone tell me how to do this I have 80,000 records to update. I also could do it over multiple Country Codes at once is this a list test?
July 30, 2010 10:25 PM
August 2, 2010 1:09 PM