golfok
Member
I need to update via an sql statement, the f4301 from the f4311 file. The fields I need to update in the f4301, is phexp1 and phtxa1, from f4311 fileds pdexp1 and pdtxa1.
I can run a select sql, with an inner join and all works fine. I guess you cannot use a join for an update. Noone in my AS/400 shop has written a SQL to update from one file to another.
If anyone can help, give me the update statement, we would really appreciate it.
Thanks
I can run a select sql, with an inner join and all works fine. I guess you cannot use a join for an update. Noone in my AS/400 shop has written a SQL to update from one file to another.
If anyone can help, give me the update statement, we would really appreciate it.
Thanks