HPL Load

Posted in 2007

Topics: Data Types & Schema Design, Migration, Import/Export & Data Conversion

VICTOR HUAQUISTO — Sat, 01 Sep 2007 22:09:50 — source: IIUG Forums & Mailing Lists

Hi, I unloaded a table with lvarchar column using a HPL job in express mode without conversion. I made a pipe device ( compress > file.Z) and now I am trying to load the table and HPL show me the following message: Tables with BLOBS or extended types cannot be loaded in Express Mode. The question is: How I can load the data? Using that? Thanks, Victor.

↪ replying to VICTOR HUAQUISTO

Jonathan Leffler — Mon, 03 Sep 2007 06:28:02 — source: IIUG Forums & Mailing Lists

On 9/1/07, VICTOR HUAQUISTO <vhuaquis@sunat.gob.pe> wrote: > I unloaded a table with lvarchar column using a HPL job in express mode > without conversion. I made a pipe device ( compress > file.Z) and now I am > trying to load the table and HPL show me the following message: Tables with > BLOBS or extended types cannot be loaded in Express Mode. > > The question is: How I can load the data? Using that? Deluxe Mode? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2007.0826 -- http://dbi.perl.org/ NB: Please do not use this email for correspondence. I don't necessarily read it every week, even.

↪ replying to VICTOR HUAQUISTO

Jack Parker — Tue, 04 Sep 2007 16:22:53 — source: IIUG Forums & Mailing Lists

Pop into ipload and change the job to deluxe mode. You may also be able to do this from the command line (I forget off the top of my head). j. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of VICTOR HUAQUISTO Sent: Saturday, September 01, 2007 6:10 PM To: ids@iiug.org Subject: HPL Load [9890] Hi, I unloaded a table with lvarchar column using a HPL job in express mode without conversion. I made a pipe device ( compress > file.Z) and now I am trying to load the table and HPL show me the following message: Tables with BLOBS or extended types cannot be loaded in Express Mode. The question is: How I can load the data? Using that? Thanks, Victor. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.