I just got a new laptop with Windows 10 which can't use the "Data Transfer to iSeries" function in excel. I've tried to re-install the add-on again but still does not work.
I'd like to transfer file which has a list of objects, libraries, and saved date for restoration on AS/400 (using BRMS function) For example :
OBJ LIB1 LIB2 DATE OBJ0001 FROMLIB01 TOLIB01 20/12/2018 OBJ0002 FROMLIB02 TOLIB02 20/12/2018 OBJ0003 FROMLIB03 TOLIB03 20/12/2018
So, I need to find the way to edit record in the physical file instead of transferring the file from the PC. I know that STRSQL can edit records but I'm not familiar with the SQL commands. Can anyone guide me on how to edit many records using SQL?