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

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

Combining data from the same file in multiple libraries into a view

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 »

Low-Code Open Source Enterprise Resource Planning Software for IBM i

Visual LANSA’s hybrid low-code approach means you can build entire enterprise applications more efficiently than any other low-code app builder on the market. Providing developers with all the tools they will ever need in one IDE streamlines the entire application development process. No need to learn other development languages as hybrid low-code eliminates the work … …

Read More >

The post Low-Code Open Source Enterprise Resource Planning Software for IBM i appeared first on Lansa.

Verified by MonsterInsights