Retrieving file’s keys with SQL, having to use DSPFD Simon Hutchinson

​[[{“value”:”In my last post I wrote about how to list a file’s key fields using the file QADBKATR to retrieve the key fields’ information from.
I mentioned that there may be times that you are not authorized to use the QADBKATR file. If you are not authorized how else can you get the key fields? And present them as I did in the previous example?
I have to fall back and use the Display File Description command, DSPFD, using the Access Path value in the “Type of information” parameter:

DSPFD FILE(MYLIB/TESTFILE) TYPE(*ACCPTH)

Read more »”}]] Read More 

Common: IBM iSee Video Blog

​Short demonstrations of tools, techniques and examples (including working SQL examples!!) to help you solve real problems that are part of your everyday work.  Presented by Scott Forstie and Tim Rowe, IBM Read More 

Profound Logic Enhances Legacy System Futurization with Introduction of Python to its Open-Source Transformation Services Profound Logic

​[[{“value”:”Profound Logic, a trailblazer in AI–enhanced IBM i futurization, proudly announces a significant expansion of its established transformation services with the addition of Python to its Profound Transformation offering. Building on our long-standing capability to futurize legacy systems by transitioning to modern, open-source programming languages like Node.js and cloud migration services, this new initiative introduces Python as an additional target language, enhancing and broadening the scope of our modernization solutions.
The post Profound Logic Enhances Legacy System Futurization with Introduction of Python to its Open-Source Transformation Services appeared first on Profound Logic.”}]] Read More 

Transitioning from Db2 Web Query to LANSA BI: A Strategic Move LANSA Editors

​[[{“value”:”Business intelligence (BI) tools have constantly adapted to changing environments that have empowered organizations in their requirement for data-driven decision-making. Over time, there have been significant changes in the BI tools available in the IBM ecosystem. Legacy tools like IBM Db2 Web Query, a web-based interface for querying Db2 databases on IBM i, formerly known
The post Transitioning from Db2 Web Query to LANSA BI: A Strategic Move appeared first on .”}]] Read More 

Verified by MonsterInsights