Search found 2 matches
- Mon Jun 26, 2006 5:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Table through DB2 Enterprise Stage
- Replies: 13
- Views: 6396
When we pull from a partitioned table, we use the nodenumber function and current node option in DB2: Query select customer_id, cust_name from mydb.customer_tb where nodenumber(customer_id) = current node select c.customer_id, c.cust_name, a.street_addr, a.city_nm, a.state_cd, a.zip_9_cd from mydb....
- Thu Mar 23, 2006 4:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: About SQL Code 0803N
- Replies: 7
- Views: 4166