Search found 2 matches

by skcwong
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....
by skcwong
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

I'm having the same problem with DB2 UDB stage (upsert option). Anyone got the solution? Thanks!