Re: reading data files into a newly created table

You might want to consider using sybperl, Sybase extensions to Perl. It is quite flexible and easy to use. It can be obtained from several archive sites.

Bruce

Siqiao Li (sli_at_ascii.csc.lsu.edu) wrote:
: In article <jdennisCnr0vy.BBu_at_netcom.com> jdennis_at_netcom.com (John Dennis) writes:
: >I would suggest you look at SQL-Loader. It is fairly flexiable and
: >does *seem* to be able to handle you problem with a little rigging.
: >It advantage is it is *fairly* fast and maintainable.
: >
 

: Does SQL-Loader provide a flexible mapping mechanism too? e.g.

: In my source data, I have some free texts that need to be mapped.
 

: Died----> 1
: Dead----> 1
: He is dead-----> 1
: 13(in old database value) ------> 1

: What I am doing is first preprocess all source data into FREE FORMAT
: ascii files for each table. (" as the delimitor and , as the separator)
: The field number and order should be the same as the corresponding Oracle
: table.

: Any comments and suggestions on DATA TRANSFER from other databases
: to ORACLE? How about Sybase? As you might feel, my scheme is quite
: flexible(powerful) but not very efficient.
 

: ciao
 

: --SQL
: P.S. Please Cc: your mail to sli_at_biost.mskcc.org since I may not have
: time to read this group.

--
----------------------------------
Bruce H. Sielaff, Ph.D.
Laboratory Medicine and Pathology
University of Minnesota

<bsielaff_at_tahiti.umhc.umn.edu>
----------------------------------