Solved

IAL PREFIX

4 years ago
Apr 17, 2022 8:11 PM UTC
6 replies
344 views

+14

ZTC ZTC JGOTA
Hero (Customer)

Hello IFS Community,

How do I know the username used to run an IAL?

Does IFS have a place where I could see the prefixes?

I am trying to run the query the following way

select * from &IAL.PART_COST2

(According to different posts I have read in the community) I need to add the prefix &IAL.

A pop-up window shows up asking for the value of IAL, and I input my AO, then the result is table or view does not exist.

Fyi. The IAL was created correctly (See fig ). However, I do not know if I enter the correct username for IAL.

Best answer by sutekh137

Assuming permissions are OK, you have to look “up and over” into a different schema. In this case, “IFSINFO”. So, instead of using &IAL.<viewname>, use IFSINFO.<viewname>.

Hope that helps!

Joe Kaufman

View original

S

+12

sutekh137
Hero
4 years ago
Apr 17, 2022 9:00 PM UTC

By default the “info” user is IFSINFO. Look in Oracle for other schemas starting with “IFS”.

Where are you being prompted for “IAL”? When you write a Quick Report (for example) against an IAL, the &IAL should resolve without you needing to enter anything, as that is a globally defined parameter so IFS should not prompt you for input.

Joe Kaufman

Just because something is part of a plan doesn't make it right.

Like

+14

ZTC ZTC JGOTA
Author
Hero (Customer)
4 years ago
Apr 17, 2022 10:19 PM UTC

Hello @sutekh137

Thanks for your answer.

I am trying to use my PL/SQL developer tool to query the data.

How can I query an IAL view?

I am trying to do it this way => select * from &IAL.PART_COST2

Thanks,

JL

Like

S

+12

sutekh137
Hero
Answer
4 years ago
Apr 17, 2022 10:30 PM UTC

Assuming permissions are OK, you have to look “up and over” into a different schema. In this case, “IFSINFO”. So, instead of using &IAL.<viewname>, use IFSINFO.<viewname>.

Hope that helps!

Joe Kaufman

Just because something is part of a plan doesn't make it right.