Re: decimal point or comma
Hi again :-)
I cant see why dividing your dbaccess script into two parts
would be harmfull.
Nevertheless if you really have to do it in one script I would
suggest to set DBMONEY to . and write a Stored
Procedure which changes . to , and use that on the
appropriate columns during the second unload.
Hope that helps.
Regards,
Dirk
> 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
> > >
> > >
> >
> >
>
>