Assorted questions about uploading a flat ascii text file ported from an IBM mainframe

From: george lewycky <gelewyc_at_nyct.com>
Date: 8 Feb 2002 09:23:07 -0800
Message-ID: <68aecc05.0202080923.5acd4628@posting.google.com>

Assorted questions about uploading a flat ascii text file ported from an IBM mainframe

1. What is the best/easiest method or utility for uploading the data to an Oracle database (running on Win NT). I&#8217;m hearing and finding out about more than I expected.

I&#8217;d appreciate hearing about past experiences, the pro&#8217;s and con&#8217;s, web sites, etc

I&#8217;ve been told a mixture of the following: UTL_File, SQL*PLUS, Discoverer, Export/Import, Migration Workbench (OTN), SQLLOADER, Oracle Bulk Loader

2. Parsing the fields (eg, comma or &#8220;,&#8221;). Which works best

create table customer

 ( authcust char(05) not null,
   name     char(25) not null,
   address1 char(25),
   address2 char(25),
   address3 char(25),
   address4 char(25),

   citycountry char(18),

   state    char(02),
   zip      char(05),
   phone    char(10),
   contact  char(25) ) 

 ;

Below is a sample of the flat file that I parsed with double colons and a comma since spaces and other characters exist.

"10066","ABC BUS MANUFACTURING ","1506 30TH STREET
","NORTHWES
"10068","ABC RAIL PRODUCTS CORP. ","11TH & WASHINGTON STREETS","
"10070","ABCO REFRIGERATION SUPPLY","49-70 31ST STREET ","
"10090","ABEE PRINTING CORP. ","305-1 KNICKERBOCKER AVE. ","
Thanks in Advance

George R Lewycky
NY City Transit Authority
Brooklyn NYC USA

gelewyc_at_nyct.com Received on Fri Feb 08 2002 - 11:23:07 CST