How to create a logical file with data from more than one member Simon Hutchinson

​[[{“value”:”I wrote an earlier post about how to define a file twice in a RPG program so that I can use two members in the file. This led to a further discussion about could I combine data from those multiple members into one using a DDS logical file. This post demonstrates the results of those subsequent discussions.
I am going to use the same file as I did in the earlier post. If you have questions about file layouts, etc., check that post.
I am going to add a third member to the file, which will be called THIRD:

ADDPFM FILE(TESTFILE) MBR(THIRD) TEXT(‘Just added’)

I can list the members in TESTFILE using the SYSMEMBERSTAT SQL View:
Read more »”}]] Read More 

Mapepire Introduction Andy Youens

​[[{“value”:”In my last couple of articles, I have shown python accessing data on the IBM i, accessing both DB2 for i and SQLite. The SQLite article used an SQLite package to get the data, and for the DB2 for i example I used ODBC to retrieve data from the IBM i. In this article I’ll
The post Mapepire Introduction first appeared on PowerWire.”}]] Read More 

Passwords – Looking Ahead Rudi van Helvoirt

​[[{“value”:”Be it auditors, the recent NIS2 Directive , or just common sense, stepping away from IBM i user profiles with never expiring passwords has always been the better choice. Since IBM i has been around for quite some time, a lot of the security options have gotten a bit long in the tooth. For sure,
The post Passwords – Looking Ahead first appeared on PowerWire.”}]] Read More 

Verified by MonsterInsights