Re: Can Art's dbcopy migrate BLOB data?
The dbcopy utility should work for TEXT and BYTE columns. The very first table I used it for, indeed the original impetous for writing it, was a table with a TEXT BLOB. Honestly I haven't tested that code for years and so there may be a problem. What version of the source are you using? The latest, installed on IIUG and Oninit just last week, was modified to hopefully make it 64bit safe. I may have F*&^ed something up there. But if it's an older version, I don't know. What were the specific error(s)? Art On Mon, Jan 19, 2009 at 1:20 PM, <joeclhua@gmail.com> wrote: > I migrated a table with data type TEXT & BYTE stored in BLOB space > using Art's utlity dbcopy, it failed. > Just wondering whether dbcopy can copy blob data ? > Except dbcopy , Any other way that I can migrate blob data? > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) 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 1月21日, 上午11時57分, Art Kagel <art.ka...@gmail.com> wrote: > The dbcopy utility should work for TEXT and BYTE columns. The very first > table I used it for, indeed the original impetous for writing it, was a > table with a TEXT BLOB. Honestly I haven't tested that code for years and > so there may be a problem. What version of the source are you using? The > latest, installed on IIUG and Oninit just last week, was modified to > hopefully make it 64bit safe. I may have F*&^ed something up there. But if > it's an older version, I don't know. What were the specific error(s)? > > Art > > On Mon, Jan 19, 2009 at 1:20 PM, <joecl...@gmail.com> wrote: > > I migrated a table with data type TEXT & BYTE stored in BLOB space > > using Art's utlity dbcopy, it failed. > > Just wondering whether dbcopy can copy blob data ? > > Except dbcopy , Any other way that I can migrate blob data? > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (a...@iiug.org) > > 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. Dear Art and all other gurus, Thanks for your reply. dbcopy version: dbcopy.ec: Revision: 1.40 after execution , It did not display any error message , only dispaly 0 record are copyed