SQL*Loader understands how to translate PACKED and
ZONED DECIMAL format; pretty sure that PRO*Cobol does as well, though I
don't do Cobol...
If you're interested in conversion routines, I've a
"C" function named "ptof()" that converts packed-decimal to
floating-point; wrote it 10 years ago and have just been hauling it around
since. However, the converse function ("ftop()") seems to have disappeared
in the mists of time. It wouldn't be too hard to reconstruct, but the need
hasn't arisen...
The "ptof()" source code comes with a pretty
explanation of packed-decimal format, reprinted here:
Just recently, I had the dubious pleasure of
writing PACKED2NUMBER and NUMBER2PACKED functions in PL/SQL. These took
packed-decimal numbers as input (in RAW format) and returned a NUMBER and
vice-versa...
I haven't posted them, but I'd be glad to if
you need them...
|
- Packed decimal Brooks, Russ
- RE: Packed decimal Karniotis, Stephen
- RE: Packed decimal DENNIS WILLIAMS
- Tim Gorman