Skip to main content
Solved

How to extract the source code for an IAL

  • January 24, 2020
  • 3 replies
  • 1309 views

Forum|alt.badge.img+10

I have an IAL that I want to duplicate in another IFS system. I do not have access to the original source.  Does anyone have suggestions how I can extract the IAL and copy it to my other IFS system?

Both are IFS8 running Oracle 12c.

Best answer by CallumW

I use the PL/SQL Developer IDE and I normally access it by typing out the IAL in full and then whilst holding Ctrl, right click the line

 

If you use a different IDE such as SQL Developer - just perform a google search on how to view the view, there should be some set of instructions on how to do it.

 

Failing that you can perform an SQL query:

select text from dba_views a where view_name = 'SALES_VALUES_FORECAST_IAL'

 

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

3 replies

CallumW
Superhero (Partner)
Forum|alt.badge.img+15
  • Superhero (Partner)
  • 128 replies
  • Answer
  • January 25, 2020

I use the PL/SQL Developer IDE and I normally access it by typing out the IAL in full and then whilst holding Ctrl, right click the line

 

If you use a different IDE such as SQL Developer - just perform a google search on how to view the view, there should be some set of instructions on how to do it.

 

Failing that you can perform an SQL query:

select text from dba_views a where view_name = 'SALES_VALUES_FORECAST_IAL'

 


durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • 534 replies
  • March 26, 2020

Callum’s answer is the correct one. Adding to it…

IFSINFO may not have permission to read the dictionary view DBA_VIEWS, so you can use USER_VIEWS instead while logged in as IFSINFO.


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 48 replies
  • March 26, 2020

Callum’s first answer provides the sql, complete with the ‘create or replace….’ statement. Not just the ‘select...’

His second answer provides the sql without the ‘create or replace...’ portion.

I found a third one using pl/sql developer.  In the views for user IFSINFO, right mouse click on the view you are interested in. Select ‘View Documentation’.  It will display the columns followed by the sql statement to create the view.

 


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