Partition read from DB2 table

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
soumya5891
Participant
Posts: 152
Joined: Mon Mar 07, 2011 6:16 am

Partition read from DB2 table

Post by soumya5891 »

I am using a DB2 connector for extraction data from a large DB2 table. If I use partition read and set generate sql(for partition read) to No then the query looks like the following:

SELECT COL1,COL2,COL3 FROM SCHEMA.TABLE WHERE NODENUMBER(COL2)=CURRENT NODE.

Considering COL1,COL2 composite primary key and COL2 is the distribution key.

Now if I set generate sql(for partition read) to Yes then what will be the column in the following sql in place of partion_col

SELECT COL1,COL2,COL3 FROM SCHEMA.TABLE WHERE NODENUMBER(partition_col)=CURRENT NODE.
Soumya
Post Reply