> -----Original Message-----
> From: Michael Kim [mailto:mkim@...]
> Sent: Miércoles 31 de Enero de 2001 17:07
>
> CREATE TABLE APP_REL_IMAGE_FILE
> (
> ID Integer NOT NULL,
> Active_Date VARCHAR (10),
> Employee Integer,
> App_Service Integer [288],
> App_Client_Type Integer [288],
> App_Client Integer [288],
> App_Status VARCHAR (288),
> Internet VARCHAR (288),
> PRIMARY KEY (ID)
> );

[snip]

> UPDATE APP_REL_IMAGE_FILE
> SET APP_REL_IMAGE_FILE.APP_SERVICE[:APP_SLOT] =
> :IN_SERVICE,

That's not an IBO question, of course. Procedures are very limited when
dealing with segmented blobs, they only can get and return BLOB IDs and for
reading blob chunks, they need to call a UDF. Arrays are implemented on top
of stream blobs and you can't manipulate arrays in procedures. Also, the
DSQL interface won't allow you an update on a single array field and less
even trying to use a parameter as an index for the array. You only can
select specific array elements, for example
select arrayfield[5] from mytable

C.