Re: adding new fragment to a table
Art,
That did it!! Thanks alot. I greatly appreciate your help.
"ART KAGEL,
BLOOMBERG/ 65E To: DarrenJacobs@carmax.com
55TH" cc:
<KAGEL@bloomberg Subject: Re: adding new fragment to a table
.net>
04/01/03 11:17
AM
----- Original Message -----
From: Darrenjacob.... <DarrenJacobs@carmax.com>
At: 4/ 1 11:03
> 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 <== FIX: Just get rid of this clause
> (
> (accounting_dt >= DATE ('03-01-2001' ) ) AND
> (accounting_dt <= DATE ('02-28-2002' ) )
> ) in <dbspace name>
Art S. Kagel