Prev: tsql to change oracle pswd
Next: Wierd Performance Question- Please help!!
From: Mecn on 24 Dec 2009 10:39
Thanks all


"Tony Rogerson" <tonyrogerson(a)torver.net> wrote in message
news:1BAF8C81-3A65-492B-8885-3DDD4FA130FC(a)microsoft.com...
> Hi Mecn,
>
> You need to use SSIS (SQL Server Integration Services).
>
> This will help:
> http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/463cd34f-1c1e-441a-b262-0a4745f139e9
>
> Many thanks,
> Tony.
>
>
> "Mecn" <mecn(a)yahoo.com> wrote in message
> news:#2b5Pb#gKHA.1536(a)TK2MSFTNGP06.phx.gbl...
>> Hi,
>>
>> Anyone here knows how to read a flat file with Cobol comp-3 field from
>> sql
>> server.
>>
>> Thanks,
>>


From: Payson on 28 Dec 2009 12:29
> However, if the file originally came from an IBM
> mainframe (EBCDIC), some of the characters would have been translated
> to their ASCII equivalents in the download.  >

I thought about this some over the holiday. (I need a life :) ). I
probably didn't emphasize the problems caused by the EBCDIC to ASCII
translation as much as I should have.

Here is an example. In packed decimal, the number +500 would be
represented as x'500C'. The character x'50' in EBCDIC is the
ampersand ('&'). When this data is transliterated to ASCII, the &
character will become its ASCII equivilant - x'26'. Therefore, the
packed decimal number becomes x'260C' = +260.

I hope this makes sense. Moral - be careful with downloaded mainframe
data.

Payson

First  |  Prev  | 
Pages: 1 2
Prev: tsql to change oracle pswd
Next: Wierd Performance Question- Please help!!