
January 15th, 2007, 05:40 PM
|
|
Registered User
|
|
Join Date: Jan 2007
Posts: 1
Time spent in forums: 6 m 4 sec
Reputation Power: 0
|
|
|
Load From Partitions Across Federated Connection
I have a production and a test database and I need to pull 25% of the data on the production table to the test table. I have a nickname on the test table pointing to the production table and when I try to use:
select * from <schema>.<prd_table> where dbpartitionnum<part_key> in (1,2,3,4)
I get an error: Invalid use of the row based funtion: SYSIBM.DBPARTITIONNUM.
Is this due to the fact that I'm trying to pull across a federated connection?
Of course, it works fine if working on local databases.
Any help would be appreciated.
Thanks...db2new
|