myexport and Informix 11 compatibility
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