PowerCenter
- PowerCenter 10.5
- All Products
SELECT <column list> FROM <table name> PARTITION <database_partition1name> UNION ALL SELECT <column list> FROM <table name> PARTITION <database_partition4name> UNION ALL
SELECT <column list> FROM <table name> WHERE (nodenumber(<column 1>)=0OR nodenumber(<column 1>) =3)
SELECT <column list> FROM <table name> SUBPARTITION <database_subpartition1_aname> UNION ALL SELECT <column list> FROM <table name> SUBPARTITION <database_subpartition1_bname> UNION ALL SELECT <column list> FROM <table name> SUBPARTITION <database_subpartition4_aname> UNION ALL SELECT <column list> FROM <table name> SUBPARTITION <database_subpartition4_bname> UNION ALL