Hot answers tagged

1

The only problem seems to be your missing quotes for the dates. As they are enclosed in the string the have to be escaped (with a second single quote) like in my example: CALL SYSPROC.ADMIN_MOVE_TABLE( 'ADMIN', 'TRANSACTION', '', '', '', '', '', '(TRANSACTIONDATE) (STARTING FROM (''1/1/2010'') ENDING AT (''1/1/2017'') EVERY 1 MONTH)', ...


1

You can achieve something like this using a federated view. After configuring the federated data source as described in the manual, you would create a nickname for the archive table CREATE NICKNAME Archive_Prod FOR archive_server.archive_schema.Archive_Prod; After that you would create a view joining the two tables: CREATE VIEW v_active_prod AS SELECT ...



Only top voted, non community-wiki answers of a minimum length are eligible