IBM i SQL Security for Database-driven Components
Various widgets, including auto-complete text boxes, database driven drop-downs, grids and charts use SQL to retrieve the required data from the database. This feature is configured through properties on the individual widgets.Â
SQL statements for widgets run in a separate job from the Profound UI / Genie application itself, so QTEMP cannot be used with this feature. However, the library list and user profile of these separate jobs are synchronized with the Profound UI / Genie application session. The SQL queries will therefore resolve unqualified file references using the library list, and normal IBM i object authorities are in play. Â
Some documentation pages have recently moved to a new section: Profound AppDev. If you are having trouble finding specific pages, try the documentation search capability or reach out to our Support team!