IDS Forum

Re: HPL - unmapped blob

Posted By: VIKAS HIVARKAR
Date: Friday, 19 June 2009, at 3:32 a.m.

In Response To: Re: HPL - unmapped blob (Art Kagel)

Hi,

How can i create a map file for mapping of BYTE, TEXT and lvarchar datatypes and use this map file with onpload in order to unload data from these columns as well.

I see the documentation and it says
The map file is a text file. The format of the map file is:

[server.database.]type_name lib_name entry_point [c++if_major.c++if_minor]

Seriously, the documentation for HPL using onpladm and onpload options is not that informative, The documentation shows every example with GUI :(

Thanks to Andrew Ford for his articles on HPL but then now those articles are not available anymore, click on the link (http://www.ibmdatabasemag.com/blog/main/archives/2008/05/the_informix_hi.html)it takes to the new magzine protal check for archives and I'm back on the same page :((

Any information on how to mapp the datatypes BYTE/TEXT/lvarchar in order to unload them to seperate files, would be help full

Thanks in advance
Regards
Vikas

*******************************************************************************
The coltype of those column types are:

SQLBYTES 11
SQLTEXT 12
SQLUDTVAR 40

Note that LVARCHAR columns are implemented as a Variable length User Defined
Type (VUDT) the type of a VUDT is 40. For an LVARCHAR column the
extended_id column in syscolumns will have the id of the LVARCHAR extended
type which is 1 (one). You can look up the extended_id in the sysxtdtypes
table.

You can find these defines in the ESQL/C header file:
$INFORMIXDIR/incl/esql/sqltypes.h along with a macro you can use to filter
out any of several attributes that are encoded in the coltype bits along
with the actual type (ex: NOT NULL).

#define SQLTYPE 0xFF
#define MASKNONULL(t) ((t) & (SQLTYPE))

Art

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 Thu, Jun 18, 2009 at 4:29 AM, VIKAS HIVARKAR <vikas.hivarkar@gmail.com>wrote:

> Hi,
>
> IDS 11.10 FC3 on Solaris 10
>
> I am trying to unload all the tables from a database using a shell script
> that
> creates HPL jobs(onpladm) and then unload using onpload.
>
> Except for 5 tables the scripts runs well and unload all the tables to
> tab.unl
> files, The following Error is same for all the 5 tables with the
> corresponding
> column name.
>
> "Query contains unmapped simple large object or blob com - cannot proceed
> Error occured at HPL failpoint: 16110"
>
> The columns have eighter TEXT, BYTE or lvarchar datatypes which i
> understand
> are not supported by HPL express mode.
>
> So one way is to find such tables having Simple LOs, Ext Type data types,
> ensuring constraints, or invoking triggers and run the unload with Deluxe
> mode.
>
> I'm trying to find such tables with syscolumns - coltype but not sure what
> all
> types should i consider which are unsupported by express mode.
>
> The docs also mention about extended_id but not sure if i can use it?
>
> Any help on this is appreciated!
>
> one more question in the above error what does "unmapped" means?
>
> Regards,
> Vikas
>
>
>
> *******************************************************************************

Messages In This Thread

• HPL - unmapped blob
  VIKAS HIVARKAR -- Thursday, 18 June 2009, at 4:29 a.m.
  • Re: HPL - unmapped blob
    Art Kagel -- Thursday, 18 June 2009, at 11:13 a.m.
    • Re: HPL - unmapped blob
      VIKAS HIVARKAR -- Friday, 19 June 2009, at 3:32 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.