Grande successo per il primo corso organizzato da Faq400.com e IBM Italia: 380 partecipanti, 240 aziende diverse … Auditorium al completo più altra sala in video-conferenza.
I was reading some questions and answers on StackOverflow and I found this post: Concatenate Multiple Row Values into 1 Row, with SQL for iSeries Curious about “connect by” sql and hierarchical queries I tried with this simple BOM Bill Of Materials … I want esplode my BOM in a three view like this … Level…
“IBMi Next Step : Strumenti moderni per lo sviluppatore”
Una collaborazione Faq400.com e IBM Italia
What ? Can I watch Taxi Driver movie on IBMi via Netflix ? No, but using only RPG and SQL UDF HTTPGETBLOB now you can call an IBM Watson API and transform a generic text (in different languages) in a wav/flac file and play it with a simple STRPCCMD. Let’s start from the beginning. I…
Taking the cue from some posts on the web about writing better RPG code I took an old and simple Fixed Format RPG Code, converted it to Free Format, then some hammer blows to give it a better shape. Source codes here: test02fix, test02free, psds_free, psds_fixed References: A Style Guide For Modern RPG And ILE – Paul Tuohy Some…
Everybody knows Giovanni B. Perotti and his great work with Mel Rothmann for CGIDEV2 Open Source project, he is retired but often pop out some new utilities, like his last work EZ4PARSE.
EZ4PARSE is an utility to convert xml document into a phisical files: more often whe face the necessity to extract XML data from XML documents … if we could see them like normal db2 tables life would be simple for RPG old school programmers like me.
So let’s we try with some simple XML sample documents.
August in Italy … holidays, vacations, many companies closed, sea, montain, sport … not so busy yeah ! … so in those days I tried to expand my Linkedin network and to study something news … Reading Linkedin Pulse I stumbled upon a Marinus Van Sandwik’s post about RPG and RPG Free by Jon Paris and…
I’ve got an IFS directory with a lot of CSV / TXT files for ERP-Ecommerce integration for one of my customer who, sometimes, has to search a string in all that files. Now he use Microsoft Windows Search utility but ask me for an utility from IBMi.
Googling csv, IFS and SQL I stumbled upon two awsome utilities:
I downloaded this two utilities, generate two UDF e build a little app who get string, filename, path in input and return an array with filename, filedate, rows with my string.
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.
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 !”