Re: myexport question (SQLCMD and decimals)

2009/7/8 Javier Pérez Arenal <jperez@uniovi.es>: > Hello to everyone on the list > > I am a regular and avid reader of the list and now I've decided to use the > famous utilities of Art S. Kagel, namely "myexport" (it would be really > great to have an export of the database without the damned exclusive lock > ....), I have a little problem. To summarize: > > S.O.: RedHat Linux 5.2 x86_64 > IDS version: 11.50.FC4 > SDK version: 3.50.xC4 > Locale of the database: utf-8 > environment variables: > - CLIENT_LOCALE = es_es.utf8 / es_es.cp1252 (I tested with the two ...) > - DB_LOCALE = es_es.utf8 > - DBMONEY =, > - DBDATE = DMY4 - > > I downloaded the SQLCMD and ak_utils(x) utilities, I have compiled > everything you need and I managed to make a "myexport" apparently without > problems. > > The issue is that the sqlunload is taking the decimal numbers with a dot > instead of a comma (I need this to assure compatibility with dbimport...) > and it is cutting the decimal positions to 1, when they have to be a few > more ... Can you provide the schema of the table in question? The bug would be in SQLCMD, or in ESQL/C on which it relies. Which version of SQLCMD are you using? (Chances are you're using SQLCMD v86.00 since that's the current version at the IIUG, but it is as well to be sure.) I'll need to look at the comma vs dot issue - that I regard as (relatively) minor. The truncation is a much more serious issue; it should not be doing that. > Is quite possible that the solution to my problems are trivial, but I take a > few days fighting this and I can not move forward. > > Before you answer, give you all thank you for the amount of wisdom that put > on the list. > > Regards. > > PS: (I must also thank the translator of Google ... ;-)) > -- > Javier Perez Arenal - jperez@uniovi.es > Jefe del Area Técnica de Informática y Comunicaciones > Vicerrectorado de Informática y Comunicaciones > Universidad de Oviedo > Edificio Severo Ochoa > C/ Fernando Bongera s/n, Campus del Cristo > 33006 - Oviedo, Asturias -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Eddie Izzard - "Never put a sock in a toaster." - http://www.brainyquote.com/quotes/authors/e/eddie_izzard.html