Question on SQL Statement
IDS 11.50.UC5 Linux
In order to move two fields at the same time from one table to a smart blob
without having two passes at the table, I need to merge the following two
statements into one:
ALTER TABLE images MODIFY b_image_byte BLOB, PUT b_image_byte IN (images01sbs,images02sbs) (EXTENT SIZE 4, NO LOG, KEEP ACCESS TIME);
ALTER TABLE images MODIFY b_text_byte CLOB, PUT b_text_byte IN (images01sbs,images02sbs) (EXTENT SIZE 4, NO LOG, KEEP ACCESS TIME);
I have tried it several different ways but always get a syntax error.
Thanks in advance.
Clifton
_________________________________________________________________
Hotmail: Trusted email with Microsofts powerful SPAM protection.
http://clk.atdmt.com/GBL/go/177141664/direct/01/
I will guess you have tried the following;
ALTER TABLE images
MODIFY (b_image_byte BLOB, b_text_byte CLOB),
PUT b_image_byte IN (images01sbs, images02sbs)
(EXTENT SIZE 4, NO LOG, KEEP ACCESS TIME),
PUT b_text_byte IN (images01sbs, images02sbs)
(EXTENT SIZE 4, NO LOG, KEEP ACCESS TIME);
Unless I didn't follow the railroads correctly it should work... Don't have
a system to test this on, hope you figure it out.
Eric B. Rowell
On Tue, Jan 5, 2010 at 4:16 PM, Clifton Bean <clifton_bean@hotmail.com>wrote:
> IDS 11.50.UC5 Linux
>
> In order to move two fields at the same time from one table to a smart blob
> without having two passes at the table, I need to merge the following two
> statements into one:
>
> ALTER TABLE images MODIFY b_image_byte BLOB, PUT b_image_byte IN
> (images01sbs,> images02sbs) (EXTENT SIZE 4, NO LOG, KEEP ACCESS TIME);
>
> ALTER TABLE images MODIFY b_text_byte CLOB, PUT b_text_byte IN
> (images01sbs,> images02sbs) (EXTENT SIZE 4, NO LOG, KEEP ACCESS TIME);
>
> I have tried it several different ways but always get a syntax error.
>
> Thanks in advance.
>
> Clifton
>
> _________________________________________________________________
> Hotmail: Trusted email with Microsofts powerful SPAM protection.
> http://clk.atdmt.com/GBL/go/177141664/direct/01/
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Eric B. Rowell
--0016e6d9a2c7321d75047c71f7c2
Try this:
ALTER TABLE images MODIFY (b_image_byte BLOB, b_text_byte CLOB),
PUT b_image_byte IN (images01sbs, images02sbs) (EXTENT SIZE 4, NO
LOG, KEEP ACCESS TIME),
PUT b_text_byte IN (images01sbs, images02sbs) (EXTENT SIZE 4, NO
LOG, KEEP ACCESS TIME);
Art
Art S. Kagel
AdvanceDataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Tue, Jan 5, 2010 at 4:16 PM, Clifton Bean <clifton_bean@hotmail.com>wrote:
> IDS 11.50.UC5 Linux
>
> In order to move two fields at the same time from one table to a smart blob
> without having two passes at the table, I need to merge the following two
> statements into one:
>
> ALTER TABLE images MODIFY b_image_byte BLOB, PUT b_image_byte IN
> (images01sbs,> images02sbs) (EXTENT SIZE 4, NO LOG, KEEP ACCESS TIME);
>
> ALTER TABLE images MODIFY b_text_byte CLOB, PUT b_text_byte IN
> (images01sbs,> images02sbs) (EXTENT SIZE 4, NO LOG, KEEP ACCESS TIME);
>
> I have tried it several different ways but always get a syntax error.
>
> Thanks in advance.
>
> Clifton
>
> _________________________________________________________________
> Hotmail: Trusted email with Microsofts powerful SPAM protection.
> http://clk.atdmt.com/GBL/go/177141664/direct/01/
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--002354530938896e68047c73df01