If I use myexport to export an Informix 11 database and then try to import it
with myimport or dbimport I get the following error:

CREATE AGGREGATE 'informix'.genxml WITH (
INIT = init_aggrxml,
ITER = iter_aggrxml,
COMBINE = comb_aggrxml,
FINAL = final_aggrxml,
HANDLESNULLS
);
*** execute sqlobj
9400 - User-defined aggregate genxml already exists.

If I use dbexport I don't get this error - but then I also don't get all the
genxml* aggregates being outputted either (see below).

Is this a problem with my setup or with myexport? I have sqlcmd-81.03 and the
latest myexport (downloaded in the middle of December).

Aggregates in myexport sql:

CREATE AGGREGATE 'informix'.genxml WITH (
INIT = init_aggrxml,
ITER = iter_aggrxml,
COMBINE = comb_aggrxml,
FINAL = final_aggrxml,
HANDLESNULLS
);

CREATE AGGREGATE 'informix'.genxmlclob WITH (
INIT = init_aggrxmlc,
ITER = iter_aggrxmlc,
COMBINE = comb_aggrxmlc,
FINAL = final_aggrxmlc,
HANDLESNULLS
);

CREATE AGGREGATE 'informix'.genxmlelem WITH (
INIT = init_aggrelem,
ITER = iter_aggrelem,
COMBINE = comb_aggrelem,
FINAL = final_aggrelem,
HANDLESNULLS
);

CREATE AGGREGATE 'informix'.genxmlelemclob WITH (
INIT = init_aggrelemc,
ITER = iter_aggrelemc,
COMBINE = comb_aggrelemc,
FINAL = final_aggrelemc,
HANDLESNULLS
);

CREATE AGGREGATE 'informix'.genxmlschema WITH (
INIT = init_aggrschema,
ITER = iter_aggrschema,
COMBINE = comb_aggrschema,
FINAL = final_aggrschema,
HANDLESNULLS
);

CREATE AGGREGATE 'informix'.genxmlschemaclob WITH (
INIT = init_aggrschemac,
ITER = iter_aggrschemac,
COMBINE = comb_aggrschemac,
FINAL = final_aggrschemac,
HANDLESNULLS
);

Thanks

--
Regards

Scott Newton | R&D Solution Specialist | Integral Technology Group Ltd
95 Ascot Ave, Greenlane | PO Box 302313, North Harbour, North Shore City 0751
DDI 09 302 3788 | Fax 09 477 0478*| www.integralgroup.co.nz

On Dec 26, 7:03 pm, Scott Newton <scott.new...@integralgroup.co.nz>
wrote:
> If I use myexport to export an Informix 11 database and then try to import it
> with myimport or dbimport I get the following error:

Scott,

The problem's not in myexport itself but in myschema. It looks like
these are built-in aggregates that are created at database create
time. Myschema is not filtering them out and is creating them in the
schema file. IBM keeps adding more and more built-in objects that I
haven't filtered out with each new release since 10.00.

Please send me the output of dbschema -ss and myexport -l in
attachments and I'll see if I can get a fix to you. For a quick fix
you can run this awk/gawk/nawk script to remove them:

mv mydatabase.sql mydatabase.sql.bad
awk 'BEGIN{AGG=0;}/CREATE AGGREGATE/{AGG=1; print "{", $1; next;}/);/
{if (AGG == 1) {print $1, "}";} else {print $1;}; AGG=0; next}'
<mydatabase.sql.bad >mydatabase.sql

Not tested but it should work. Send files to me at
art.kagel@gmail.com from the address to which you want me to return
things.

Art

> CREATE AGGREGATE 'informix'.genxml WITH (
> INIT = init_aggrxml,
> ITER = iter_aggrxml,
> COMBINE = comb_aggrxml,
> FINAL = final_aggrxml,
> HANDLESNULLS
> );
> *** execute sqlobj
> 9400 - User-defined aggregate genxml already exists.
>
> If I use dbexport I don't get this error - but then I also don't get all the
> genxml* aggregates being outputted either (see below).
>
> Is this a problem with my setup or with myexport? I have sqlcmd-81.03 and the
> latest myexport (downloaded in the middle of December).
>
> Aggregates in myexport sql:
>
> CREATE AGGREGATE 'informix'.genxml WITH (
> INIT = init_aggrxml,
> ITER = iter_aggrxml,
> COMBINE = comb_aggrxml,
> FINAL = final_aggrxml,
> HANDLESNULLS
> );
>
> CREATE AGGREGATE 'informix'.genxmlclob WITH (
> INIT = init_aggrxmlc,
> ITER = iter_aggrxmlc,
> COMBINE = comb_aggrxmlc,
> FINAL = final_aggrxmlc,
> HANDLESNULLS
> );
>
> CREATE AGGREGATE 'informix'.genxmlelem WITH (
> INIT = init_aggrelem,
> ITER = iter_aggrelem,
> COMBINE = comb_aggrelem,
> FINAL = final_aggrelem,
> HANDLESNULLS
> );
>
> CREATE AGGREGATE 'informix'.genxmlelemclob WITH (
> INIT = init_aggrelemc,
> ITER = iter_aggrelemc,
> COMBINE = comb_aggrelemc,
> FINAL = final_aggrelemc,
> HANDLESNULLS
> );
>
> CREATE AGGREGATE 'informix'.genxmlschema WITH (
> INIT = init_aggrschema,
> ITER = iter_aggrschema,
> COMBINE = comb_aggrschema,
> FINAL = final_aggrschema,
> HANDLESNULLS
> );
>
> CREATE AGGREGATE 'informix'.genxmlschemaclob WITH (
> INIT = init_aggrschemac,
> ITER = iter_aggrschemac,
> COMBINE = comb_aggrschemac,
> FINAL = final_aggrschemac,
> HANDLESNULLS
> );
>
> Thanks
>
> --
> Regards
>
> Scott Newton | R&D Solution Specialist | Integral Technology Group Ltd
> 95 Ascot Ave, Greenlane | PO Box 302313, North Harbour, North Shore City 0751
> DDI 09 302 3788 | Fax 09 477 0478 |www.integralgroup.co.nz