Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Execute file with multiple SQL queries

user12863665
Member Posts: 131 Blue Ribbon
I would like to execute multiple sql queries(delete statements on different tables) as part of ODI package.
Anyone suggest me how can I do that with simple way in ODI.
Answers
-
Hi,
Create an ODI procedure and add a task based on Oracle technology.
The code will be:
begin
delete from .....;
insert into ..........;
end;
-
Thank you the advice.Is there a way I can pick the file path instead of hardcoding these statements.
intention is to update the statements in the file. Automatically ODI package has to execute those sql statements.
-
If you want dynamic file paths try using ODI variables in combination with the Options that can be set on the ODI Procedure