Re: SQL Loader Questions

Greg Teets <teetshd_at_email.uc.edu> wrote in article <343a3903.315332657_at_news.ececs.uc.edu>...
> For others interested in these answers:
>
> I found the help file but I still need an answer to #1 and #2..
> Following is the info so far for those who might also like to know.
>
> On Sun, 05 Oct 1997 01:22:34 GMT, teetshd_at_email.uc.edu (Greg Teets)
> wrote:
>
> >Please help me with few SQL Loader questions using version 7.2 from
> >the command line.
> >
> >1. Can I put the command line in a script like in UNIX and call that
> >file from the command line rather than type in the parameters every
> >time?
> >
> >2. I'm using Personal Oracle7 demo disk from Oracle Unleashed. Can
> >you tell me where to find SQL Loader documentation in the help files?
>
> The help for SQLLoader is in \po7_win\db\dbhlp71\svuug.hlp
> Server Utility User's Guide
> >
> >3. In my table I have a NUMBER column with a length of 9 and dedimal
> >precision of 0. However, in my data file the number has commas in it.
> >Naturally, it's also a comma-delimited file <g>, How can I have my
> >SQL Loader control file process this column correctly?
> >
> >Thanks for your help
> >Greg Teets
> >Cincinnati, OH
>
>
Greg,
As a serious data converter I recommend you look at SQLMover which is a production or on-demand tool for DBAs or the DB knowledgeable that allows you to replicate automatically between any ODBC compliant datasource including Oracle, Text files, Ingres, Informix, DB2, all MS databases
including SQL
Server, Access and Excel. You need the Intersolv ODBC driver for Oracle. The Microsoft Text file 32-bit ODBC driver is downloadable from www.sqlmover.com.
SQLMover uses standard, simple or complex SQL Select statement in
one end and a INSERT, UPDATE, INSERT then UPDATE, UPDATE the INSERT or DELETE statement towards the destination database table. It has error control and logging facilities. Data conversion can be performed by using the SQL SELECT CONVERT option or by using string functions in the SELECT query, by using the built in Format Mask functions or by using triggers in the destination database. To evaluate until Oct.31 you can download from www.sqlmover.com (follow the download buttons) and use the evaluation key OSHKSHTD. The key allows you to transfer a limited number of rows per transfer/replication task and max. 5 tasks
can be defined.

For Data Mart Data Warehousing purposes you can choose to let SQLMover aggregate your data by using SELECT - GROUP BY. That is if you don´t want to transfer all details.
Peder Holst,
pederh_at_elektrosoft.se Received on Thu Oct 09 1997 - 00:00:00 CEST