No need to use APIs I can read a file in the IFS just with #SQL.
?#IBMi #rpgpgm #IBMChampion
rpgpgm.com/2020/11/readin…
– Simon Hutchinson (@RPGPGM)09:33 – Mar 08, 2022
As cyber threats become more sophisticated, strong encryption is essential. Attend this free POWERcast to learn how to quickly encrypt sensitive data on IBM i—and avert a data breach disaster.
As cyber threats become more sophisticated, strong encryption is essential. Attend this free POWERcast to learn how to quickly encrypt sensitive data on IBM i—and avert a data breach disaster. ow.ly/ingW50I69Uv pic.twitter.com/UA9Jd6ysBh
– COMMON (@COMMONug)08:02 – Mar 08, 2022
Media library information with SQL
A recent upgrade to a new virtual tape library, VTL, product introduced me to the concepts of a tape library and to a new command Work with Media Library Status, WRKMLBSTS. The system admins came to me asked if there was a way I could get to the same information as is displayed by WRKMLBSTS.
They had become frustrated with the command as it did not offer the ability to output its results to an outfile or a spool file, that they would then copy to a file.
“Is there something in SQL you can work your magic with?” they asked.
A quick search of IBM’s documentation portal gave me what was needed, a view called MEDIA_LIBRARY_INFO.
Join me discussing why to embrace #opensource on #ibmi at @i_ug_uk tomorrow @unionjackclub London #ibmchampion #ibmioss
Join me discussing why to embrace #opensource on #ibmi at @i_ug_uk tomorrow @unionjackclub London #ibmchampion #ibmioss
– Andy Youens ⚓ (@AndyYouens)06:16 – Mar 09, 2022
