Originally posted by: jvanboga
It sounds like you are connecting the DB in question fine. When I can connect but can’t see the table it usually means that the user ID I’ve logged in as doesn’t own the table. Your user may still have the rights to read, insert, update etc but if it doesn’t own the table….
You can handle this in different ways. …
1. In my world I have the owner’s ID/PW for most of table I need in the Dev regions but not necessarily in QA, UA, PROD etc… I build the tree based on where I have ownership access but change the ID/PW to what will be used in production post tree build.
2. I have also asked a DBA to deploy a temporary version of the table under the user ID I’ll have is the production/test regions. Once the type tree is built the temp table can be dropped. (if I have access to the table definitions I will do this myself.)
3. I don’t use version 8.2 or 8.3 here. Those versions may allow you to build a tree while pointing at another user’s tables
That said, you shouldn’t have any trouble building a tree for a table belonging to another user via a select statement or query. You may have to modify the related table before you can use it to insert/update data but you can build the tree with a simple query ‘select * from id.table’.
Finally, once you’d defined your type tree using one of the 3 methods above you’ll need to define the table key before you can insert/update successfully.
Hope that helps…
#DataExchange#IBMSterlingTransformationExtender#IBM-Websphere-Transformation-Extender