adding new fragment to a table

Posted in 2003

DarrenJacobs@carmax.com — Tue, 01 Apr 2003 15:29:21 — source: IIUG Forums & Mailing Lists

All, I'm having a little problem with adding a new dbspace to a frag'd table. The statement I'm trying to run is below. I get a syntax error when trying to run the statement below. Could someone give me a hand with the correct statement? The table is frag'd by expression using a date range. alter fragment on table <tabname>add fragment by expression ( (accounting_dt >= DATE ('03-01-2001' ) ) AND (accounting_dt <= DATE ('02-28-2002' ) ) ) in <dbspace name> Thanks for any assistance.