Hi all experts,
I have a query to execute as below,
execute dbms_mview.refresh(#view_name#)
I tried to run the query in datastage using Oracle Enterprise stage but failed due to "update statement prepare failed" error.
Thus, I am thinking to plug the query to dynamic RDBMS stage.
However, the stage required me to put in Connection Name which i am not sure what should i put.
May I know if i need to make any configuration in order to get the Connection Name? Should I run the above mentioned query with different stage instead of dynamic RDBMS?
Thanks for your advise.
RDBMS stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia
-
- Participant
- Posts: 7
- Joined: Sun Apr 10, 2011 11:30 am
- Location: Delhi
Re: RDBMS stage
Hi!
I am not able to understand why it throws error like 'Update prepare failure'. Are you using it as a target?
Then, coming to RDMS stage you should create a ODBC connection first.
I am not able to understand why it throws error like 'Update prepare failure'. Are you using it as a target?
Then, coming to RDMS stage you should create a ODBC connection first.