Blog

In my talk last year at @NodeConfRemote I mentioned IBM i as a #nodejs ecosystem success story. You can now read more about how that came about and how #nodejs has been embraced by the #ibmi ecosystem. Thanks to @IBMJesseG for sharing: developer.ibm.com/languages/node…

– Michael Dawson (@mhdawson1)13:47 – Jul 06, 2021

What a fantastic day at #iug #intpower we had yesterday. Looking forward to another great day today! #IBMi

– redbourn.co.uk (@RedbournSystems)01:28 – Jul 07, 2021

Thank you to all who attended my #opensource workshop at #iug user group yesterday, hope you enjoyed it. Don’t forget we are still giving #virtual #training on #IBMi. Get in touch, lets talk #OpenSource on #IBMi #IBMChampion @FormaServe pic.twitter.com/t2wfZEwCGw

– Andy Youens ⚓ (@AndyYouens)01:20 – Jul 07, 2021

OMG an in person #ibmi event!
Great to see some many people here at #intpower #ibmchampion pic.twitter.com/EEDRpahq38

– Steve Bradshaw (@smjbradshaw)01:18 – Jul 07, 2021

When anyone asks for information that they are going to “pull” from the IBM i into another database or to interface to another application on the IBM i I do not want them to access the “live” files for several reasons:

Control the information they can get to, don’t show them what they do not needIf there are calculations or other mapping that needs to be performed perform them, rather than rely on them to do it and then find they have not done so in the right mannerMap data from the files and tables into the type of data format they wantPrevent them from being able to insert, change, or delete data from files and tables

In my opinion the perfect tool for this is a SQL View. I can build it the way I want and tell them to use that.

Read more »