Oninit cdi / Archive
Talk to an expert →

decimal point or comma

Posted in 2003

Topics: Migration, Import/Export & Data Conversion

DeeWee — — source: Usenet: comp.databases.informix

Hi, I have to create 2 files, one (file-a) must have a decimal point, the other (file-b) a decimal comma. Using the SQL Editor I wrote -------------------------------------------------------- unload to 't:\\file-a.txt' DELIMITER ' ' select t_item, t_dsca, t_amount from inv; unload to 't:\\file-b.txt' DELIMITER ' ' select t_item, t_dsca, t_amount from inv;-------------------------------------------------------- setnet32 is used to set DBMONEY=, Both files now have a , as decimal sign in t_amount. How can I temporarily change the , to . ? TIA, D. Willems

↪ replying to DeeWee
Dirk Gunsth���vel — — source: Usenet: comp.databases.informix

Hi :-) I dont know if I understand correctly but you can always either set the registry value or the environment variable DBMONEY to the desired value between the two runs via a program. Environment variable is probably better because it changes the value only for the current shell. Regards, Dirk -- -- Dirk Gunsthoevel IT Systemanalyse phone: +49 (0)251 624947 -- Steinfurter Str. 61 fax: +49 (0)251 1624111 -- D-48149 Muenster http://www.GunCon.de/ -- "The cost of living hasn't affected its popularity." "DeeWee" <1@2.3> schrieb im Newsbeitrag news:3f656ca9$0$24143$ba620e4c@reader1.news.skynet.be... > Hi, > > I have to create 2 files, one (file-a) must have a decimal point, the other > (file-b) a decimal comma. > > Using the SQL Editor I wrote > -------------------------------------------------------- > unload to 't:\\file-a.txt' DELIMITER ' ' > select t_item, t_dsca, t_amount from inv;> > unload to 't:\\file-b.txt' DELIMITER ' ' > select t_item, t_dsca, t_amount from inv;> -------------------------------------------------------- > > setnet32 is used to set DBMONEY=, > > Both files now have a , as decimal sign in t_amount. > How can I temporarily change the , to . ? > > TIA, > > D. Willems > >

↪ replying to Dirk Gunsth���vel
DeeWee — — source: Usenet: comp.databases.informix

Thanks for your reaction. Your suggestion is correct. I hoped that I could do it in the SQL script i.e. between the two unload's without leaving the script. Hoping you have such solution, D. Willems "Dirk Gunsth'vel" <dirk@guncon.de> schreef in bericht news:bk6u46$pdh$1@news1.transmedia.de... > Hi :-) > I dont know if I understand correctly but you can always either > set the registry value or the environment variable DBMONEY > to the desired value between the two runs via a program. > Environment variable is probably better because it changes > the value only for the current shell. > > Regards, > Dirk > > -- > -- Dirk Gunsthoevel IT Systemanalyse phone: +49 (0)251 624947 > -- Steinfurter Str. 61 fax: +49 (0)251 1624111 > -- D-48149 Muenster http://www.GunCon.de/ > -- "The cost of living hasn't affected its popularity." > > > "DeeWee" <1@2.3> schrieb im Newsbeitrag news:3f656ca9$0$24143$ba620e4c@reader1.news.skynet.be... > > Hi, > > > > I have to create 2 files, one (file-a) must have a decimal point, the other > > (file-b) a decimal comma. > > > > Using the SQL Editor I wrote > > -------------------------------------------------------- > > unload to 't:\\file-a.txt' DELIMITER ' ' > > select t_item, t_dsca, t_amount from inv;> > > > unload to 't:\\file-b.txt' DELIMITER ' ' > > select t_item, t_dsca, t_amount from inv;> > -------------------------------------------------------- > > > > setnet32 is used to set DBMONEY=, > > > > Both files now have a , as decimal sign in t_amount. > > How can I temporarily change the , to . ? > > > > TIA, > > > > D. Willems > > > > > >

Related threads