Happy Holidays To You And Yours From Us And Ours Timothy Prickett Morgan

​First of all, thank you.
It is a great privilege and an honor to do the work we do for the IBM i and Power Systems customer base and the software vendors, hardware sellers, and service providers who also serve customers like you. If history has demonstrated nothing else in the more than five decades of IBM midrange computing, it is that we are one single ecosystem, that we are all in this together and always have been.
We did a little bit more content earlier this year, and so that means we can get our Christmas break a little …
The post Happy Holidays To You And Yours From Us And Ours appeared first on IT Jungle. Read More 

IBM i PTF Guide, Volume 25, Number 50 Doug Bidwell

​Well, there are two new security vulnerabilities in the IBM i stack, as we report elsewhere in this issue of The Four Hundred. And there is also an update to the System Planning Tool. Let’s do the latter first and the former last.
The System Planning Tool, version 6.23.340, is now available for download at this link. The System Planning Tool is used by customers and business partners to build valid system configurations for Power Systems machines and their software stacks. You can look at the release notes for various SPT generations here.
Now on to the …
The post IBM i PTF Guide, Volume 25, Number 50 appeared first on IT Jungle. Read More 

Can sql stored procedures return character values? uzumymw_

​I have a sub procedure, which returns a message text(OUT parameter) based on a message id(IN parameter). I want to return a string of text upon returning and not using the OUT parameter. Just like we do in rpgle using return opcode.
Apparently stored procedures can only return integers?
I don’t want to use an out parameter and then using it where needed. The above procedure fetches multiple strings upto 50, so I will need 50 such variables in the calling pgm/procedure.
Can I just call that stored procedure directly where the return value is needed?
Thanks
submitted by /u/uzumymw_[link][comments] Read More 

Verified by MonsterInsights