Originally posted by: SystemAdmin

Hi There

I have created an MDQ file which happliy accesses my DB2 Database (on a MVS platform) via ODBC (i.e I create a query and generate tree from it)

However, I would like to have these tables on the PC for insertion and updates (currently in my output card I just put any value in the table name)

I cant find any documentation that clearly tells you how to do this. If I double click on the "table" icon I just get a message saying there are no tables defined.

What am I doing wrong??

Thanks in advance
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

So you're reading from these tables via a query using a Window's ODBC, but when you try to build a tree to do updates, it won't let you??
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

when you are creating the database in DID there is an option called

access user tables/procedures only. By default it is 'yes'. give 'no' here and try.you may see all the tables.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender