Re: myexport and Informix 11 compatibility

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