dbexport bug?

I have a problem with dbexport command. Not export de table with text an byte fields Some idea why? Thanks -- Saludos Cordiales Rubén Dután Gerente APLEXT CIA. LTDA. Soluciones AX-ERP & TIC www.aplext.com.ec -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. For all your IT requirements visit: http://www.transtec.co.uk

Ruben, that should work, but I don't have a guess what is causing the failure. Are there any message in the online log or at the command line? Sometimes there are problems with odd combinations of delimiter characters embedded in TEXT columns, but BYTE types should be encoded as a stream of hex values so that should not be an issue. As an aside, if you want to try it, my dbexport/dbimport replacement package, myexport, can export TEXT and BYTE data with no problem. You can download it from the IIUG Repository. It also requires my utils2_ak package (for myschema). If you are using the -E option (use external tables for export and import) you don't need anything else. If you want to use HPLoader you will also need Ravi Krishna's myonpload package - note that -E is faster than using HPLoader and MUCH faster than dbexport/dbimport even without using the parallel option which just turbo boosts the whole operation! Note also that myexport and myimport are compatible with dbexport and dbimport in that you can export with either myexport or dbexport and import with either myimport of dbimport. Art Art S. Kagel, President and Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. 2014-09-24 10:39 GMT-04:00 Ruben Dutan <ruben.dutan@aplext.com.ec>: > I have a problem with dbexport command. Not export de table with text an > byte fields > Some idea why? > Thanks > -- > Saludos Cordiales > > Rubén Dután > Gerente > APLEXT CIA. LTDA. > Soluciones AX-ERP & TIC > www.aplext.com.ec > > -- > Este mensaje ha sido analizado por MailScanner > en busca de virus y otros contenidos peligrosos, > y se considera que está limpio. > For all your IT requirements visit: http://www.transtec.co.uk > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1134652eaef8f80503d0d48a

Thanks Art El mié, 24-09-2014 a las 10:52 -0400, Art Kagel escribió: > Ruben, that should work, but I don't have a guess what is causing the > failure. Are there any message in the online log or at the command line? > Sometimes there are problems with odd combinations of delimiter characters > embedded in TEXT columns, but BYTE types should be encoded as a stream of > hex values so that should not be an issue. > > As an aside, if you want to try it, my dbexport/dbimport replacement > package, myexport, can export TEXT and BYTE data with no problem. You can > download it from the IIUG Repository. It also requires my utils2_ak > package (for myschema). If you are using the -E option (use external > tables for export and import) you don't need anything else. If you want to > use HPLoader you will also need Ravi Krishna's myonpload package - note > that -E is faster than using HPLoader and MUCH faster than > dbexport/dbimport even without using the parallel option which just turbo > boosts the whole operation! > > Note also that myexport and myimport are compatible with dbexport and > dbimport in that you can export with either myexport or dbexport and import > with either myimport of dbimport. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > 2014-09-24 10:39 GMT-04:00 Ruben Dutan <ruben.dutan@aplext.com.ec>: > > > I have a problem with dbexport command. Not export de table with text an > > byte fields > > Some idea why? > > Thanks > > -- > > Saludos Cordiales > > > > Rubén Dután > > Gerente > > APLEXT CIA. LTDA. > > Soluciones AX-ERP & TIC > > www.aplext.com.ec > > > > -- > > Este mensaje ha sido analizado por MailScanner > > en busca de virus y otros contenidos peligrosos, > > y se considera que est limpio. > > For all your IT requirements visit: http://www.transtec.co.uk > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a1134652eaef8f80503d0d48a > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. For all your IT requirements visit: http://www.transtec.co.uk

Ruben, I would recommend that you try running unload form dbaccess to get the appropriate error message. If my memory servers my right I recall this happening when DBTEMP in the onconfig is set to a path that is unavailable to Informix user. Setting it to a writeable directory should solve the matter. If its the case create a RAM drive with the size of the largest blob and point DBTEMP to that mount point it will speed up tremendously :) Regards Kenneth Penza Systems Engineer | Infrastructure Services Department MALTA INFORMATION TECHNOLOGY AGENCY Email: Office: URL: kenneth.penzat@gov.mt +356 2599 2867 http://www.mita.gov.mt Please read our Legal Notice: http://emailpolicy.mita.gov.mt Kindly consider your environmental responsibility before printing this e-mail -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Ruben Dutan Sent: Wednesday, 24 September 2014 19:03 To: ids@iiug.org Subject: Re: dbexport bug? [33866] Thanks Art El mié, 24-09-2014 a las 10:52 -0400, Art Kagel escribió: > Ruben, that should work, but I don't have a guess what is causing the > failure. Are there any message in the online log or at the command line? > Sometimes there are problems with odd combinations of delimiter > characters embedded in TEXT columns, but BYTE types should be encoded > as a stream of hex values so that should not be an issue. > > As an aside, if you want to try it, my dbexport/dbimport replacement > package, myexport, can export TEXT and BYTE data with no problem. You > can download it from the IIUG Repository. It also requires my > utils2_ak package (for myschema). If you are using the -E option (use > external tables for export and import) you don't need anything else. > If you want to use HPLoader you will also need Ravi Krishna's > myonpload package - note that -E is faster than using HPLoader and > MUCH faster than dbexport/dbimport even without using the parallel > option which just turbo boosts the whole operation! > > Note also that myexport and myimport are compatible with dbexport and > dbimport in that you can export with either myexport or dbexport and > import with either myimport of dbimport. > > Art > > Art S. Kagel, President and Principal Consultant ASK Database > Management > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own > opinions and do not reflect on the IIUG, nor any other organization > with which I am associated either explicitly, implicitly, or by > inference. Neither do those opinions reflect those of other > individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. > > 2014-09-24 10:39 GMT-04:00 Ruben Dutan <ruben.dutan@aplext.com.ec>: > > > I have a problem with dbexport command. Not export de table with > > text an byte fields Some idea why? > > Thanks > > -- > > Saludos Cordiales > > > > Rubén Dután > > Gerente > > APLEXT CIA. LTDA. > > Soluciones AX-ERP & TIC > > www.aplext.com.ec > > > > -- > > Este mensaje ha sido analizado por MailScanner en busca de virus y > > otros contenidos peligrosos, y se considera que est limpio. > > For all your IT requirements visit: http://www.transtec.co.uk > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a1134652eaef8f80503d0d48a > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. For all your IT requirements visit: http://www.transtec.co.uk ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks Kenneth I run unload and work fine. I think something append with ER because without ER works fine. But I need ER with these tables. -- Saludos Cordiales Rubén Dután Gerente APLEXT CIA. LTDA. Soluciones AX-ERP & TIC www.aplext.com.ec El mar, 30-09-2014 a las 03:32 -0400, Penza Kenneth at MITA escribió: > Ruben, > > I would recommend that you try running unload form dbaccess to get the > appropriate error message. > > If my memory servers my right I recall this happening when DBTEMP in the > onconfig is set to a path that is unavailable to Informix user. Setting it to > a writeable directory should solve the matter. If its the case create a RAM > drive with the size of the largest blob and point DBTEMP to that mount point > it will speed up tremendously :) > > Regards > Kenneth Penza > Systems Engineer | Infrastructure Services Department > MALTA INFORMATION TECHNOLOGY AGENCY > > Email: > Office: > URL: > kenneth.penzat@gov.mt > +356 2599 2867 > http://www.mita.gov.mt > > Please read our Legal Notice: http://emailpolicy.mita.gov.mt > Kindly consider your environmental responsibility before printing this e-mail > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Ruben > Dutan > Sent: Wednesday, 24 September 2014 19:03 > To: ids@iiug.org > Subject: Re: dbexport bug? [33866] > > Thanks Art > > El mié, 24-09-2014 a las 10:52 -0400, Art Kagel escribió: > > Ruben, that should work, but I don't have a guess what is causing the > > failure. Are there any message in the online log or at the command line? > > Sometimes there are problems with odd combinations of delimiter > > characters embedded in TEXT columns, but BYTE types should be encoded > > as a stream of hex values so that should not be an issue. > > > > As an aside, if you want to try it, my dbexport/dbimport replacement > > package, myexport, can export TEXT and BYTE data with no problem. You > > can download it from the IIUG Repository. It also requires my > > utils2_ak package (for myschema). If you are using the -E option (use > > external tables for export and import) you don't need anything else. > > If you want to use HPLoader you will also need Ravi Krishna's > > myonpload package - note that -E is faster than using HPLoader and > > MUCH faster than dbexport/dbimport even without using the parallel > > option which just turbo boosts the whole operation! > > > > Note also that myexport and myimport are compatible with dbexport and > > dbimport in that you can export with either myexport or dbexport and > > import with either myimport of dbimport. > > > > Art > > > > Art S. Kagel, President and Principal Consultant ASK Database > > Management > > > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own > > opinions and do not reflect on the IIUG, nor any other organization > > with which I am associated either explicitly, implicitly, or by > > inference. Neither do those opinions reflect those of other > > individuals affiliated with any entity with which I am affiliated nor those > of the entities themselves. > > > > 2014-09-24 10:39 GMT-04:00 Ruben Dutan <ruben.dutan@aplext.com.ec>: > > > > > I have a problem with dbexport command. Not export de table with > > > text an byte fields Some idea why? > > > Thanks > > > -- > > > Saludos Cordiales > > > > > > Rubén Dután > > > Gerente > > > APLEXT CIA. LTDA. > > > Soluciones AX-ERP & TIC > > > www.aplext.com.ec > > > > > > -- > > > Este mensaje ha sido analizado por MailScanner en busca de virus y > > > otros contenidos peligrosos, y se considera que est limpio. > > > For all your IT requirements visit: http://www.transtec.co.uk > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a1134652eaef8f80503d0d48a > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Este mensaje ha sido analizado por MailScanner en busca de virus y otros > contenidos peligrosos, y se considera que est limpio. > For all your IT requirements visit: http://www.transtec.co.uk > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. For all your IT requirements visit: http://www.transtec.co.uk