Precision of results

[Ina Schmitz]

Hi all,

I am using DB2 V8.2(German version) under Windows XP.

I would like to have that the results shown in "Abfrageergebnisse" (I don't
know which the equivalent in the English version is; something like "query
results"?) are shown in the precision they really have. For example, in a
field distance, I see a value "0.003". When I click on this value, I get the
value "0.00291822977162526". What do I have to do that this value is written
in the field just when getting my results (so that I see this value from
beginning and don't have to click on the value for each tuple to see the
exact result)?

Thanks for ideas,
Ina

[juliane26]

How was the column defined in DB2 (datatype?)?
What is the select statement you use ?

I suppose you are talking about the command editor GUI.

What do you get when executing the select statement directly from
command line ?

[Ina Schmitz]

What is the select statement you use ? The statement I use is:
select
(DB2GSE.ST_DISTANCE(
DB2GSE.ST_POINT(-0.323303542642646,0.733228164188898,-0.59820671891487,1006),
DB2GSE.ST_POINT(-0.31174530635498898,0.72492324763692095,-0.61424844240842302,1006),'decimal
degree')) as spatial_distance from spatialtest
What do you get when executing the select statement directly from
command line ?

SPATIAL_DISTANCE
------------------------
+1,42331832700911E-002

But when I execute this in the GUI, I just get: 0.014. I just get the exact
value when I click on 0.014.
I would like to get the exact value also in the GUI. Do you have any idea
how to get this?

Thanks for ideas,
Ina

[Pierre Saint-Jacques]

I don't believe you can. The GUI appl. receives the actual value but the
program specifies a different representation of the data so that it will fit
on the screen (most likely thought for now).
That piece of code would have to be changed and you get that by issuing a
change request to IBM.
I believe the group that supports this is stil the User DEsign Center at the
lab in Toronto.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Ina Schmitz" <we*@inalein.net> a écrit dans le message de news:
dl*************@news.t-online.com...

What is the select statement you use ?

The statement I use is:
select
(DB2GSE.ST_DISTANCE(
DB2GSE.ST_POINT(-0.323303542642646,0.733228164188898,-0.59820671891487,1006),
DB2GSE.ST_POINT(-0.31174530635498898,0.72492324763692095,-0.61424844240842302,1006),'decimal
degree')) as spatial_distance from spatialtest

What do you get when executing the select statement directly from
command line ?

SPATIAL_DISTANCE
------------------------
+1,42331832700911E-002

But when I execute this in the GUI, I just get: 0.014. I just get the
exact value when I click on 0.014.
I would like to get the exact value also in the GUI. Do you have any idea
how to get this?

Thanks for ideas,
Ina

[juliane26]

Ina,
I never used spatial extender.
Stíll, when I look at the GUI, I see also decimal values complete.

did you try resizing the column, so it shows longer numbers? Still, fo
me it shows 0.002... and not a rounded value.

Still, in your case it is more a user defined type from spatial
extender. why not using the sample selects with the ST_AsText point
function given in the documentation ?

http://publib.boulder.ibm.com/infoce...t/rsbp4133.htm

[Knut Stolze]

juliane26 wrote:

Ina,
I never used spatial extender.
StÃ*ll, when I look at the GUI, I see also decimal values complete.

did you try resizing the column, so it shows longer numbers? Still, fo
me it shows 0.002... and not a rounded value.

Still, in your case it is more a user defined type from spatial
extender. why not using the sample selects with the ST_AsText point
function given in the documentation ?

http://publib.boulder.ibm.com/infoce...t/rsbp4133.htm

That's because ST_Distance returns a numeric value and not a geometry. So
you can't simply convert it to a text representation using the ST_AsText
method. But you could use a CHAR function to get a similar conversion:

SELECT CHAR(DB2GSE.ST_POINT(-0.323303542642646, 0.733228164188898,
-0.59820671891487, 1006)..ST_Distance(db2gse.ST_POINT(-0.31174530635498898,
0.72492324763692095, -0.61424844240842302, 1006),'decimal degree')) as
spatial_distance
FROM spatialtest
I also agree that this is a GUI thing. What do you want to do with the
query? Incorporate it into an application or just run them ad-hoc?

You could also run the query on the command line. That would also avoid the
issue and give you the exact results.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Tonkuma]

If GUI means Command Editor, did you check the following check box?
Tools -> Tools Settings -> Command Editor -> Display results for a
single query on the Query Result Page
If so, how about remove the check?