Skip to content

Is there a way to view an IAL's actual SQL definition when Developer Studio access isn't available, since it also doesn't show up as an ordinary object under the application-owner schema in a SQL tool?

Answer

In SQL Developer (or an equivalent tool), log in as the Application Owner and look for an "Other Users" section in the connection tree — expand it, find the IFSINFO schema, expand its Views, locate the IAL by name, and open its SQL tab to see the underlying view definition; IALs are exposed as views under the IFSINFO schema rather than under the application-owner's own schema, which is why they don't show up where you'd normally expect to find them.

← Browse Developer Studio, deployment, and upgrades questions