Skip to main content
Solved

Define IAL

  • October 29, 2024
  • 5 replies
  • 165 views

Forum|alt.badge.img+10
  • Hero (Customer)
  • 123 replies

Hello.

I would like to view the definitiion of an IAL but I can’t find it, not even via SQL developer, what’s the way the view the definition of an IAL?

Best answer by MWitczak

In SQL Developer, if you are logged in as the Application Owner, you will see a selection called “Other Users”

 

Expand this, find IFSINFO, and expand the “Views” area, search for the IAL you need, and click on the SQL tab - that may get you what you are looking for.

View original
Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 123 replies
  • October 29, 2024

For example, I would like to view the SQL querry used to define this IAL :

 


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1227 replies
  • October 29, 2024

Hi @romsar 

in IEE it isn’t available. You find it in PLSQL developer.

Example: IFSINFO.MY_IAL

Note: permissions are required for IALs

 


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 123 replies
  • October 29, 2024

@link I was sure it was possible to view their definitions via SQL developer, but I have a weird behavior. 

When I filter the views list with SFD_LO_HR_012_IAL, the list is empty, but if I do a right click on SFD_LO_HR_012_IAL in the querry builder, click on “open declaration”, I can find it this way.

 

 

is that the only way to view the query? I’m connected to the database by using the IFSAPP user


MWitczak
Hero (Customer)
Forum|alt.badge.img+10
  • Hero (Customer)
  • 63 replies
  • Answer
  • October 29, 2024

In SQL Developer, if you are logged in as the Application Owner, you will see a selection called “Other Users”

 

Expand this, find IFSINFO, and expand the “Views” area, search for the IAL you need, and click on the SQL tab - that may get you what you are looking for.


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 123 replies
  • October 29, 2024

Thanks @MWitczak that’s exactly what I needed


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings