Re: Oracle and Microfocus Cobol

I suspect that it's because Oracle receives/delivers numeric data in signed binary format. I've had some success using to_char/to_num in the Select declaration, but generally I find it easier to define multiple (not redefined) fields and move my data into a 'normal' field right after I receive it or to an Oracle field right before I send it.

Johan den Boer wrote:

> Hi,
>
> Why can't you use normal picture clauses in microfocus cobol
> and embeded sql ( oracle ).
>
> 01 myfield pic 9(04) does not work
>
> in the precompiler, you have to convert it to say
>
> 01 myfield pic s9(04) comp.
>
> Is there a work around for this problem ?
>
> regards
>
> Johan den Boer
>
> email : jj.den.boer_at_hccnet.nl
Received on Thu Apr 06 2000 - 14:39:59 CDT