RDBMS stage

[agathaeleanor]

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.

[yammanur.dwhcareer]

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.