myexport question

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 ... 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

You'll have to wait for Jonathan to answer for a definitive reply, but IB that sqlunload obeys the standard Informix environment variables for value formatting. So: DBFLTMASK scale Where scale is the number of decimal digits that you want the IBM Informix client application to display in the floating-point values. Here scale must be smaller than 16, the default number of digits displayed DBMONEY The DBMONEY environment variable specifies the display format of values in columns of smallfloat, FLOAT, DECIMAL, or MONEY data types, and of complex data types derived from any of these data types. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. 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 ... > > 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 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5adf4c0cb2c046e3bd5ca

OK Art I will await the response from Jonathan ... Thanks anyway! -- 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 -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de Art Kagel Enviado el: jueves, 09 de julio de 2009 3:33 Para: ids@iiug.org Asunto: Re: myexport question [16270] You'll have to wait for Jonathan to answer for a definitive reply, but IB that sqlunload obeys the standard Informix environment variables for value formatting. So: DBFLTMASK scale Where scale is the number of decimal digits that you want the IBM Informix client application to display in the floating-point values. Here scale must be smaller than 16, the default number of digits displayed DBMONEY The DBMONEY environment variable specifies the display format of values in columns of smallfloat, FLOAT, DECIMAL, or MONEY data types, and of complex data types derived from any of these data types. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. 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 ... > > 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 > > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5adf4c0cb2c046e3bd5ca **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Hello again... Maybe I forget to mention that the environment variables that Art tell me in the past message do not work ... This would be the result of an unload from dbaccess command-line utility: 1935|2009-06-25 10:57:29.22300|pilarcz|2009-06-25 11:16:45.04600|pilarcz|7,69999981|3|3|8|SRl6yd8cX8yXyZk|147| 1936|2009-06-25 10:57:29.22400|pilarcz|2009-06-25 11:16:45.04800|pilarcz|7,30000019|3|3|8|ktKigaVRolPOEal|147| 1937|2009-06-25 10:57:29.22600|pilarcz|2009-06-25 11:16:45.05300|pilarcz|7,19999981|3|3|8|04IiNWGk07GPmvu|147| 1938|2009-06-25 10:57:29.22800|pilarcz|2009-06-25 11:16:45.04200|pilarcz|7,9000001|3|3|8|8rDPv6GH6ES14CQ|147| ... And this would be the result of sqlunload: 1935|2009-06-25 10:57:29.22300|pilarcz|2009-06-25 11:16:45.04600|pilarcz|7.7|3|3|8|SRl6yd8cX8yXyZk|147| 1936|2009-06-25 10:57:29.22400|pilarcz|2009-06-25 11:16:45.04800|pilarcz|7.3|3|3|8|ktKigaVRolPOEal|147| 1937|2009-06-25 10:57:29.22600|pilarcz|2009-06-25 11:16:45.05300|pilarcz|7.2|3|3|8|04IiNWGk07GPmvu|147| 1938|2009-06-25 10:57:29.22800|pilarcz|2009-06-25 11:16:45.04200|pilarcz|7.9|3|3|8|8rDPv6GH6ES14CQ|147| The differences are in the decimal numbers, as can be seen. If you need more information, please do not hesitate to ask. Best Regards. -- 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 -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de Javier Pérez Arenal Enviado el: jueves, 09 de julio de 2009 9:42 Para: ids@iiug.org Asunto: RE: myexport question [16274] OK Art I will await the response from Jonathan ... Thanks anyway! -- 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 -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de Art Kagel Enviado el: jueves, 09 de julio de 2009 3:33 Para: ids@iiug.org Asunto: Re: myexport question [16270] You'll have to wait for Jonathan to answer for a definitive reply, but IB that sqlunload obeys the standard Informix environment variables for value formatting. So: DBFLTMASK scale Where scale is the number of decimal digits that you want the IBM Informix client application to display in the floating-point values. Here scale must be smaller than 16, the default number of digits displayed DBMONEY The DBMONEY environment variable specifies the display format of values in columns of smallfloat, FLOAT, DECIMAL, or MONEY data types, and of complex data types derived from any of these data types. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. 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 ... > > 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 > > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5adf4c0cb2c046e3bd5ca **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.