dbTalk Databases Forums  

HPL NULL Blobs

comp.databases.informix comp.databases.informix


Discuss HPL NULL Blobs in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
CEW
 
Posts: n/a

Default HPL NULL Blobs - 06-14-2011 , 05:41 AM






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

Reply With Quote
  #2  
Old   
Jonathan Leffler
 
Posts: n/a

Default Re: HPL NULL Blobs - 06-14-2011 , 11:50 AM






On Tue, Jun 14, 2011 at 03:41, CEW <chriswest65 (AT) sky (DOT) com> wrote:

Quote:
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 (AT) gmail (DOT) 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."

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.