HPL NULL Blobs

Posted in 2011

Topics: Migration, Import/Export & Data Conversion, Platform-Specific Issues

CEW — Tue, 14 Jun 2011 03:41:28 -0700 (PDT) — source: Usenet: comp.databases.informix

We have a situation whereby an HPL Unload and re-Load is causing a table that contains Blobs (TEXT and BYTE columns) to replace NULL entries with NOT NULL values in the destination table. The process is using the Deluxe Without Replication option and the GUI (ipload) front end. Versions: IDS7.31 on Solaris 10

↪ replying to CEW

Jonathan Leffler — Tue, 14 Jun 2011 09:50:12 -0700 — source: Usenet: comp.databases.informix

On Tue, Jun 14, 2011 at 03:41, CEW <chriswest65@sky.com> wrote: > We have a situation whereby an HPL Unload and re-Load is causing a > table that contains Blobs (TEXT and BYTE columns) to replace NULL > entries with NOT NULL values in the destination table. > > The process is using the Deluxe Without Replication option and the GUI > (ipload) front end. > > Versions: > IDS7.31 on Solaris 10 > You are aware that IDS 7.31 is out of support and has been since October 2009. When did this start happening? Did it happen before? What did you change when it started happening? Can you provide a minimal reproduction of the problem (eg on a table CREATE TABLE BlobExample(ID SERIAL NOT NULL, Blob TEXT IN TABLE) and the relevant information from HPL - the job setup etc. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused."