|
Home > Archive > Data Storage > May 2004 > EBCDIC- sql server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
EBCDIC- sql server
|
|
| Americhicken 2004-05-30, 11:11 am |
| Hi,
I will ask this question once and then I will shoot myself.
I have the IMB EBCDIC tapes.
Using NovaXchange, I read each tape and dump it to disk on windows 2000.
Nova xchange uses these tpu files which I will never understand. The tpu
files convert packed this into ascii that or something
Instead of using TPU files, cant' i take these raw dump files on disk, and
import them into SQL with the DTS?
Thanks
| |
| Americhicken 2004-05-30, 11:11 am |
| Now how could this be a question that is too difficult for anyone to answer?
"Americhicken" <Americhicken@nstoekr_td.com> wrote in message
news:8dWdnZ8vjNnpFQfdRVn-gQ@comcast.com...
> Hi,
>
> I will ask this question once and then I will shoot myself.
>
> I have the IMB EBCDIC tapes.
> Using NovaXchange, I read each tape and dump it to disk on windows 2000.
>
> Nova xchange uses these tpu files which I will never understand. The tpu
> files convert packed this into ascii that or something
>
> Instead of using TPU files, cant' i take these raw dump files on disk, and
> import them into SQL with the DTS?
>
> Thanks
>
>
>
>
>
| |
| Jochen Kaiser 2004-05-30, 11:11 am |
| Americhicken,
[vbcol=seagreen]
<snip, never used nova....>[vbcol=seagreen]
===
First off - I don't know what you mean by TPU.
If you know the file format (offset e.g. file structure) you
can convert the files to ascii (or use them directly if DTS allows
this), use the structure map and pump them in a database.
(Be wary there are different EBCDIC codepages)
If you don't kow the structure you'll have to "reverse engineer" the
structure. If the files involve some level of normalisation you would
require a decent ETL tool like Informatica PowerCenter or Ascential
Datastage to do the normalisation for you. However this should only
happen when you're accessing Host files like VSAM or similar.
HTH,
Jochen
|
|
|
|
|