Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL Update with File Join
Thank you very much fredericofonseca Your reply solved my issues and I learned something new. Much appreciated -
SQL Update with File Join
No sir, It didn't work I have tried that function a while back. I am still getting the same error message about NULL values. The 4th column contains the data in question Sample of my data STK 7564 STK7564 4.2280... -
SQL Update with File Join
Mikron I want to thank you for your help so far. I can say I've never had this much trouble updating a file using SQL on the iSeries. TOTAL2 from QQRYOUT file is Zoned Data 10,4. I have stripped out all null data. Some of the remaining questionable data is less than one i.e (.4659) but I have... -
SQL Update with File Join
I can't seem to figure this one out. I have gone back to my original file and cleaned up some of the data. I have attempted to run this SQL statement again and it is still giving me errors. Error Message Received***************************** [ 11/23/2021, 11:21:00 AM ] Run Selected... -
SQL Update with File Join
I have two files that I have been working with, IMSTKPF (Primary) and QQRYOUT. IMSTKPF file has a field called Price I am attempting to do a Join to theses to files to pull the value from the field TOTAL2 in the QQRYOUT file and update the PRICE field in THE IMSTKPF file. I can’t seem to make...
