Yes you can ! You can go to IBM RFE Community (Request for Enanchement) and add your request or vote for other’s requests …. Here’s some example … but follow the link to the updated list DB2 service for IFS listing I’d like to be able to get a list of IFS files within a directory using…Dettagli
Look at this Youtube Video by Sumit Goyal … he created an utility to generate RPG code and DSPF from a free SQL statement on any of your tables …
Download a SAVF from the link at this page : https://youtu.be/uohY9uGazfw
Nice job Sumit !
Some of my clients every day or every week load Exchange Rates into ERP’s exchange tables … so I Googled for something and I stumbled upon this IBM guide: Accessing web services using IBM DB2 for i HTTP UDFs and UDTFs … I took the cue from it for this simple utility.Dettagli
Does anybody remember “1, 2, 3 ,4 gimme some more ” by DDSound , was 1978 and I was a child …
When I tried to use DB2 for i OLAP functions to make a simple ABC Analysis (Pareto) I found out that OVER() work only with ROW_NUMBER(), RANK() and DENSE_RANK(), if I need a SUM() or AVG() or something else I can’t use OVER() !
“Hey Rochester, Gimme some more !”Dettagli
Read about 7.3 and new functionalities on this PowerWire’s post
IBM i 7.3, little things mean a lot
Two new SQL for i functions: LAG and LEAD … learn them at LAG And LEAD Functions In DB2 for i 7.3
Global Temporary Tables are not so new in Db2 for i … see those Ted Holt posts:
If you never tried Rdi debug features, or you don’t use Rdi, read this Susan Gantner post on Four Hundred Guru:
Watch Your Data While Stepping Out With RDi Debug
Running WebSocket applications on IBM i
Using WebSocket for real-time web applications