Try Datastage Manager >> (1)Import >> (2)Table Definitions >> (3)ODBC Table Definitions.
Ogmios
Importing DB2 Views in Datastage
Moderators: chulett, rschirm, roy
Strange, never had that problem. A DataStage server doesn't even have to run on the same machine as the database so why would you need 777 permissions?Jay wrote:hi luc,
i had a similar problem with DB2 7.2. you will have to give 777 permission to the directory where your tables are in the database. i read it in the documentation. you might want to take a look there too.
jay
Ogmios
-
- Participant
- Posts: 1
- Joined: Sat Mar 27, 2004 11:40 pm
Re: Importing DB2 Views in Datastage
Luciano
First try using a table instead of theview. Make sure it work for the table.
If it works for the table but not for views, try using a direct query as suggested by Jay. we had similar problems.
Thanks Naren
First try using a table instead of theview. Make sure it work for the table.
If it works for the table but not for views, try using a direct query as suggested by Jay. we had similar problems.
Thanks Naren
Hi, Everyone!
Thanks for requests! However, the problem must to be an user profile problem and not 777 permissions and so on. The DBA is working for solve this problem, but nobody knows if the problem is or not an user profile problem. If I have any solution, I will tell you the solution. For while, I am wainting for the DBA analysis.
If anyone has any idea, please, help-me.
Thanks for all,
Thanks for requests! However, the problem must to be an user profile problem and not 777 permissions and so on. The DBA is working for solve this problem, but nobody knows if the problem is or not an user profile problem. If I have any solution, I will tell you the solution. For while, I am wainting for the DBA analysis.
If anyone has any idea, please, help-me.
Thanks for all,
Luciano Duarte
Did you try importing the views via "ODBC Table Definitions" instead of via "MetaData", I've been using it this way with DB2 ever since I started with DataStage.luciano wrote: Hi, Everyone!
Thanks for requests! However, the problem must to be an user profile problem and not 777 permissions and so on. The DBA is working for solve this problem, but nobody knows if the problem is or not an user profile problem. If I have any solution, I will tell you the solution. For while, I am wainting for the DBA analysis.
If anyone has any idea, please, help-me.
Thanks for all,
Ogmios
-
- Participant
- Posts: 2
- Joined: Mon Jan 12, 2004 1:32 am
- Contact: