Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.