Originally posted by: PatPather

Well, I have 2 questions.

1.  Is it possible to delete specific records using WTX?  The input to this process will be a file of keys to te records to be deleted.

2.  Can the Database Interface Designer in WTX be configured for jdbc/odbc connections.  I have used DID with both DB2 connect and full DB2 with no issues.  

Thank you

Originally posted by: Tim Rabbitt

Hello:

To answer your questions:

1) If you know the specific criteria to identify data/records you need to delete from a database, then, yes, you do this with a WTX map

2) WTX does not support jdbc adapters/connections but it does provide support for ODBC.

Information about using WTX with ODBC can be found at: http://www-01.ibm.com/support/knowledgecenter/SSVSD8_8.4.1/com.ibm.websphere.dtx.adapodbc.doc/topics/g_odbc_ODBC_Adapter.htm?lang=en

Regards,

Tim Rabbitt

Originally posted by: paul.brett

There is currently no JDBC adapter, but if you feel this is a product feature that has solid business justification, please feel free to make a Request For Enhancement at the B2B & Commerce RFE Community page:

https://www.ibm.com/developerworks/rfe/?BRAND_ID=343&PROD_ID=948

Other WTX (and non WTX) users can vote on this enhancement, and the more votes it gets, the better the chances of it making itm into a future release.

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: PatPather

Thank you Paul

Will vote on this soon.

Take care

Originally posted by: PatPather

Thank you Tim

Would you be able to provide me with a link to documentation on deleting DB2 rows?

I have not been able to get to using the ODBC, but will be trying this soon.

Thank you

Originally posted by: PatPather

Issues - we have DB2 9.7 on our server and DB2 10.1on zOS, AND the connection package for 9.7 is not loaded on zOS.  We should be adding this package on the host soon. Also, we should be upgrading to DB2 10 on the server.  So, let's see which happens first! 

Thank you