Search found 3 matches
- Tue Apr 10, 2007 12:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Connecting to DB2 Databases
- Replies: 1
- Views: 958
Connecting to DB2 Databases
Is it possible to make connections to different versions of MVS DB2 from a single DataStage client. We are pulling data from two different MVS sytems via DB2 Connect and they are at different levels of DB2 one is a Version 7 and the other Version 8. The question is can we set up to pull from these a...
- Wed Mar 07, 2007 1:11 pm
- Forum: General
- Topic: Delete from DB2 Table
- Replies: 3
- Views: 1819
Thanks for your help
I guess its true - We overthink everything the answeres were great thanks
- Wed Mar 07, 2007 11:07 am
- Forum: General
- Topic: Delete from DB2 Table
- Replies: 3
- Views: 1819
Delete from DB2 Table
This is a VERY basic question. How do I perform a delete using DB2_API Stages or any other staes , using what would be a normal subselect in SQL
ex: Delete from A where col1 in ( select col2 from B)
ex: Delete from A where col1 in ( select col2 from B)