Re: moving text BLOBS?

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 # -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-