In earlier editions of this august publication, I covered the SQL PL looping structures that I consider to be the most useful. Today I cover the remaining looping structures. I cover them for completeness, but also because what I consider to be most useful may not be what you consider to be most useful. To…
DettagliLearn how to get a list of all the objects in a library using the SQL View OBJECT_STATISTICS
Source: Using SQL for object’s statistics | RPGPGM.COM – From AS400 to IBM i
If you need a simple subfile to show or update records from a table … this WrtSFL utility is for you !
Thanks Sumit Goyal
Source: WrtSFL : Write complete Subfile code in less than 20 seconds. – QSys400.com
A deep post about Numeric Datatypes in RPG
In my humble opinion if you choose to code in RPG Free and RPG Totally free you have to move away from SEU to Rdi, Orion or other EDI tools … But sometimes you have to modify few rows of code, not from you PC, maybe from a warehouse’s PC … With those Simon’s advices…
Dettagli
Calling external program in RPG totally free as an internal procedure
As Calculations specifications no longer exist in totally free RPG, how do you call another program as you cannot use the CALL operation code?
Source: Calling a program in totally free RPG | RPGPGM.COM – From AS400 to IBM i
TechTip: Just a Bit About Git
Source: TechTip: Just a Bit About Git | Programming
RPG Academy: Write Better Code – Commenting and Documenting Strategies
Source: RPG Academy: Write Better Code – Commenting and Documenting Strategies | RPG
“AS400″”IBMi””AS400 SQL””RPGLE””CLLE””SQL functions””AS400 JAVA”
Source: It is all about IBM i: How to create a Subfile program without using any native I/O operations.
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…
Dettagli