Thanks a lot Nick for sharing your knowledge to the world. It is indeed very insightful. I was wondering if you would share some knowledge/tool on how to automate file transfer from windows to ibm i IFS. Wanted to know how to avoid user intervention and automate the whole process. Thanks!
To clarify: when at 1:50 you say that converting from physical file to SQL table the performance for accessing it from a RPG program, for example, are improved you mean that the program is left unmodified, right? That is, the SQL table is accessed with usual RPG logic, one record at the time, isn't it? What if the RPG logic also is convert into SQL (I mean pure set-based), for example into a view or a stored procedure? Is there another performance improvement? I guess so, but direct experience is better than guessing.
Thanks a lot Nick for sharing your knowledge to the world. It is indeed very insightful. I was wondering if you would share some knowledge/tool on how to automate file transfer from windows to ibm i IFS. Wanted to know how to avoid user intervention and automate the whole process. Thanks!
simply use the CPYTOIMPF command - this will copy any TABLE or PF to an IFS file location (and even allow you to convert to spreadsheet format)
To clarify: when at 1:50 you say that converting from physical file to SQL table the performance for accessing it from a RPG program, for example, are improved you mean that the program is left unmodified, right? That is, the SQL table is accessed with usual RPG logic, one record at the time, isn't it?
What if the RPG logic also is convert into SQL (I mean pure set-based), for example into a view or a stored procedure? Is there another performance improvement? I guess so, but direct experience is better than guessing.
Your video is very interesting but
How could you keep the same level identifier in the new table?
Thank you so much
Converting and compiling a DDS PF as a SQL TABLE has the exact same record format ID. No level checks and works with all existing RPG programs... :)