DSXchange

ya eventhough the user who has the privilege,everytime the schemas are generating and he got to remove them right instead of that if we select the option of not generating the schemas then it wouldn't be a problem.

Thanks.

ok

Hi Guys,
Anyone know about how to remove the temporary schema generation in IBM INFOSPHERE WAREHOUSE 9.7. I am getting an error as "you does not have privilege to create schema".

Thanks

Hi Guys,
Anyone know about how to remove the temporary schema generation in IBM INFOSPHERE WAREHOUSE 9.7. I am getting an error as "you does not have privilege to create schema".

Thanks

@vivek thanks for that but i contacted my admin about this he said DB2 for Z/OS is standard for everyone. so can you please help me further in this.

Thanks

Ya database is db2, we tried for commit limit=0 but still not working

Commit/Rollback Implementation for Database transaction from ETL scripts.
The current implementation is not able to rollback database transactions in case there is a error in DB. we have set the 0 it is not doing the rollback. Can you guys help in solving the issue.