Re: moving text BLOBS?
Maybe like Joe I'm missing the point but would the following do what you
want?
insert into
select col1, col2, col3, "Blob type a"
from tableA
where type A blobs condition
union
select col1, col2, col3,"Blob type b"
from tableA
where type b blobs condition
union
select col1, col2, col3, "Blob type c"
from tableA
where type c blobs condition
Jim Kistler <kistler@an.hp.com> wrote in article
<6617ns$6a7@hpaneqb4.an.hp.com>...
> Joe Baric (jbaric@informix.com) wrote:
> : I may be confused on what you need here,
> : but what you can do is use
> : insert into tab1
> : select from tab2
>
> : where tab2 contains all the blob columns.
>
> : Joe B
>
> : Jim Kistler wrote:
> : >
> : > I need to extract existing text BLOB data from one table and insert
the
> : > BLOB into a different table using only ISQL ( not 4GL, ESQL/C, etc. )
for
> : > a bunch of records!
> : >
>
> Joe:
>
> Thanks for suggestion, but I think the simple "insert....select"
> sequence will just clone what I have in one table to a new table.
>
> What I want to do is select a text BLOB from Table A and insert it into
> Table B where Table A has 40 columns and Table B has 4 columns. Also,
> one of Table B's columns needs to include a descriptor label that
indicates
> the section of Table A that the BLOB was taken from since I need to
> remove three different text blobs from Table A.
>
> I think I need to use the unload/load commands and do some intermediate
> processing of the unloaded data to get the proper descriptor label set
> for loading into the new table.
>
> Any other suggestions would be greatly appreciated!
>
> Thanks,
>
> Jim
> --
>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-=-
> Jim Kistler - kistler@an.hp.com # Some see issues and ask,
"Why?
> Hewlett-Packard Co. Imaging Systems # Others see opportunities and
> 3000 Minuteman Road, Andover, MA 01810 # ask, "Why not?"
> TEL: 508-659-2251 - FAX: 508-687-7265 #
>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-=-
>