Re: COBOL file dump...
From: Michael D. Long (michael.d.long-nospam_at_comcast.net)
Date: 09/15/04
- Next message: Bernie Yaeger: "Re: Help with Stored Procedure"
- Previous message: oj: "Re: returnvalue from sp_executesql"
- In reply to: MPF: "COBOL file dump..."
- Next in thread: MPF: "Re: COBOL file dump..."
- Reply: MPF: "Re: COBOL file dump..."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 14 Sep 2004 21:20:15 -0400
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: Bernie Yaeger: "Re: Help with Stored Procedure"
- Previous message: oj: "Re: returnvalue from sp_executesql"
- In reply to: MPF: "COBOL file dump..."
- Next in thread: MPF: "Re: COBOL file dump..."
- Reply: MPF: "Re: COBOL file dump..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
