TRANSFORM A VIEW
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
TRANSFORM A VIEW
Hi Friends,
Can we transform a view(NOT Table) from source database to target.Is there any way or chance to do so.Please help me.
Can we transform a view(NOT Table) from source database to target.Is there any way or chance to do so.Please help me.
Warm Regards,
Vijay
Vijay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes (assuming that you have pertinent privileges).
If the view is in source, simply SELECT from it as you would from a table.
If the target is a view, then it must be an updatable view under the rules of the database, in addition to the privileges requirements.
If the view is in source, simply SELECT from it as you would from a table.
If the target is a view, then it must be an updatable view under the rules of the database, in addition to the privileges requirements.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 41
- Joined: Thu Oct 18, 2007 10:16 pm
- Location: Bangalore
- Contact:
Re: TRANSFORM A VIEW
Yes, you can...
Provided you have privileges to do that..
Specially for a view refresh, which is nothing but updating the table.
Provided you have privileges to do that..
Specially for a view refresh, which is nothing but updating the table.
Cheers
Baksh
Baksh
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
Thank you.Yes this is another QuestionArndW wrote:That is not what was asked, you can read a view from one database and write to a table or updateable view in another database. ...
![Smile :)](./images/smilies/icon_smile.gif)
Anyway when i was trying to load data from a view I am getting target also as a view.May I know what could be the issue please.
Warm Regards,
Vijay
Vijay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage does not control this. If the name of your target table is actually the name of a view, then it's a view you have. Chat with your DBA. If DataStage is generating DDL, it's always CREATE TABLE unless manually edited so you would never get a view in this case.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am