Re: moving text BLOBS?

Jim Kistler (kistler@an.hp.com) wrote: : 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 : -- Joe: Okay....I tried a more "detailed" insert/select statement and now I believe it will work just fine. A point that had been nagging me was the ability to determine if a text BLOB was null or not. If it is null, I don't want to create a record in the new table and somewhere in the distant past I had discovered that I was not able to detect null BLOBS in a report I was writing and had not tried to do this again till now...now I can!... anyone know if something in ISQL changed that I missed? Now, I believe I am able to make the data transfer. Thanks again! 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 # -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-