A $64k ? (UNIX commands on NT)

From: Brian P. Mac Lean <brian.maclean_at_sendero.fiserv.com>
Date: 1997/10/14
Message-ID: <34439E77.2B3973D3@sendero.fiserv.com>#1/1

--------------59B974EC142ED31D179B8BF9
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

I need to convert a file from EBCDIC to ASCII and then use it as input to SQL*Loader using as little disk space as possible. On UNIX machines this can be accomplished easily using “dd” to do the character conversion and a FIFO pipe to handle the I/O. An example:

$ mknod fifo_pipe p
$ dd if=/dev/rmt/0 of=fifo_pipe conv=ascii &
$ sqlldr userid=foo/bar data=fifo_pipe control=foobar.ctl

What is the NT solution, or is there none?

                           \\|//
                           (0-0)
           +---------oOO----(_)---------------+


           | Brian P. Mac Lean                |

           | Senior Oracle DBA                |

           | brian.maclean_at_goodnet.com        |

           | brian.maclean_at_sendero.fiserv.com |

           +----------------------oOO---------+
                          |__|__|
                           || ||
                          ooO Ooo

--------------59B974EC142ED31D179B8BF9

Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit

<HTML>
<TT>I need to convert a file from EBCDIC to ASCII and then use it as input to SQL*Loader using as little disk space as possible.  On UNIX machines this can be accomplished easily using “dd” to do the character conversion and a FIFO pipe to handle the I/O.  An example:</TT><TT></TT>

<P><TT>$ mknod fifo_pipe p</TT>
<BR><TT>$ dd if=/dev/rmt/0 of=fifo_pipe conv=ascii &amp;</TT>
<BR><TT>$ sqlldr userid=foo/bar data=fifo_pipe control=foobar.ctl</TT><TT></TT>

<TT>What is the NT solution, or is there none?</TT><TT></TT>

<BR><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +----------------------oOO---------+</TT>

--------------59B974EC142ED31D179B8BF9-- Received on Tue Oct 14 1997 - 00:00:00 CDT