RDBMS stage
Posted: Thu May 05, 2011 10:11 pm
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.
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.