× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Given a test PF defined in good-old-fashioned DDS as follows (extra spaces squeezed out):
A UNIQUE
A R TEST04AP13
A PACKED 5P 0
A FLOAT1 7F 0
A DOUBLEFLT1 15F 0 FLTPCN(*DOUBLE)
A FLOAT2 7F 2
A DOUBLEFLT2 15F 7 FLTPCN(*DOUBLE)
A FLOAT3 7F 6
A DOUBLEFLT3 15F14 FLTPCN(*DOUBLE)
A K PACKED

Notice that the floating point fields have "preferred" number of decimal places defined.

If I get the meta-data the old-fashioned way, via the system APIs, then I can get the preferred number of decimal places, and QuestView pays attention to that, and displays them thusly:
PACKED . . . : 12345
FLOAT1 . . . : 1234500.E-002
DOUBLEFLT1 . : 123456789000000.E-005
FLOAT2 . . . : 12345.00E+000
DOUBLEFLT2 . : 12345678.9000000E+002
FLOAT3 . . . : 1.234500E+004
DOUBLEFLT3 . : 1.23456789000000E+009

But if I get the meta-data through a JDBC connection, then getScale() always returns zero, meaning that I have to arbitrarily decide the preferred number of decimal places to show.

Unless there's another way of getting that value via JDBC?

****
While I'm at it: I note that if I use a view name instead of a table name, I don't see the table's primary key, and neither do I see any indexes. So apparently, I need to have the table name in order to get primary key and index information.

Can anybody point me in the right direction on how to get from a view to its based-on table(s) via JDBC, so I can look up the keys? (And yes, I know, views that aren't DDS LFs don't have their own indexes built in.)

--
JHHL

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.