Re: COBOL file dump...
From: MPF (abcd_at_senditon.com)
Date: 09/15/04
- Next message: Dan Guzman: "Re: COBOL file dump..."
- Previous message: Hari Prasad: "Re: table create information."
- In reply to: Michael D. Long: "Re: COBOL file dump..."
- Next in thread: Dan Guzman: "Re: COBOL file dump..."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 14 Sep 2004 20:58:51 -0500
Thanks, Michael.
I have another question.. If C, D & possibly F are identifiers, what would
the following value be(with the same format (S9(9) V99 Value +0)?
"0000021162E". This is another "decimal" data type that should translate to
2116.25 (plus or minus, I assume).
Thanks for the suggestion on COBOL books, but I'm apparently in the midst of
a file-format battle - I desire ascii values and I'm receiving
ascii+definition values.
Thanks Again,
Morgan
"Michael D. Long" <michael.d.long-nospam@comcast.net> wrote in message
news:OFHwpIsmEHA.3328@TK2MSFTNGP10.phx.gbl...
>I think you're off by 1 in the location, since the D indicates minus (a C
>would be plus, and F unsigned - but not valid in this case because the S in
>the pic indicates a signed value). My interpretation of the value is
>+189.22.
>
> You might want to pick up a good book on COBOL, along with the compiler
> reference for the version that produced your data file. COMP data types
> aren't consistent in storage across all compilers.
>
> --
> Michael D. Long
>
>
> "MPF" <abcd@senditon.com> wrote in message
> news:uSZpfurmEHA.2764@TK2MSFTNGP11.phx.gbl...
>> <similar message posted in .Net Framework & .languages.vb>
>>
>> In a file from a COBOL dump, which is in ASCII, one of the fields is
>> defined
>> as S9(9) V99 Value +0.
>> The value in this location is 0000018922D, which according to the author
>> of
>> the source, translates to 00000189224.
>>
>> I've imported the data into a table and am able to substring (re:
>> intrepret) everything except for the decimal datatypes, as noted above.
>> Is there a way to do this via T-SQL?
>>
>> Thanks,
>>
>> Morgan
>>
>
>
- Next message: Dan Guzman: "Re: COBOL file dump..."
- Previous message: Hari Prasad: "Re: table create information."
- In reply to: Michael D. Long: "Re: COBOL file dump..."
- Next in thread: Dan Guzman: "Re: COBOL file dump..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|