RE: SQL Loader Load Problem

2001-12-19 Thread Ken Janusz

That's the book I have.  I have not found any other books totally for
SQL*Loader.

Ken

 -Original Message-
Sent:   Wednesday, December 19, 2001 8:16 AM
To: Multiple recipients of list ORACLE-L
Subject:    RE: SQL Loader Load Problem

Ken,
 Good to know that it worked.
 Not sure what books you referred to, but if you deal with SQL*Loader a lot,
then you may want to check out Jonathan Gennick's book titled 'Oracle
SQL*Loader : The Definitive Guide' by O'Reilly.  

 Regards.

- Kirti

-Original Message-
Sent: Wednesday, December 19, 2001 7:20 AM
To: Multiple recipients of list ORACLE-L


Kirti:

Another person recommended this approach and it worked very nicely.  To bad
it's not in the book.

Thanks much,

Ken


 -Original Message-
Sent:   Tuesday, December 18, 2001 10:20 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: SQL Loader Load Problem

Ken,
 If you are using 8i, then you can use the 'filler' fields. 
 In this case the control file would look something like below(considering
the fields are terminated by a comma and the table has columns a, b and c)

 load data
   infile 'myfile'
   into table mytable
   fields terminated by ','
 (a char,
  b char,
  f3 filler char, 
  f4 filler char, 
  f5 filler char, 
  f6 filler char, 
  
  f42 filler char,
  c char
 )

If you are not using 8i, then you can not avoid an intermediate table, or
use OS level tools to chop off the unwanted fields. 

HTH,

- Kirti 

-Original Message-
Sent: Tuesday, December 18, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L


I have an input file that is delimited and contains 43 fields of various
widths.  I need to load only 3 fields into a DB table of 3 columns.   2 of
the fields are at the beginning of the record and 1 is the very last field
in the record.  How can I load only these 3 cols and ignore the other 40
cols I don't need without having to use an intermediate table?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: SQL Loader Load Problem

2001-12-19 Thread Paula Wachtmeister


- Original Message -
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 19, 2001 11:30 AM


> With Oracle 7.3.4 you could use this method:
>
> LOAD DATA
> INFILE 'example.dat'
> BADFILE 'example.bad'
> insert
> INTO TABLE emp
> FIELDS TERMINATED BY ';'
> (empno POSITION(*),
>  ename POSITION(*),
>  job POSITION(*+2),
>  mgr POSITION(*))
>
> Here are the contents of data file example.dat
>
> 7782;CLARK;;;MANAGER;7839
>
>
> 125;Peter;;;258;
> - Original Message -
> From: Ken Janusz <[EMAIL PROTECTED]>
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Tuesday, December 18, 2001 7:15 PM
> Subject: SQL Loader Load Problem
>
>
> > I have an input file that is delimited and contains 43 fields of various
> > widths.  I need to load only 3 fields into a DB table of 3 columns.   2
of
> > the fields are at the beginning of the record and 1 is the very last
field
> > in the record.  How can I load only these 3 cols and ignore the other 40
> > cols I don't need without having to use an intermediate table?
> >
> > Thanks,
> > Ken Janusz, CPIM
> > Database Conversion Lead
> > Sufficient System, Inc.
> > Minneapolis, MN
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ken Janusz
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paula Wachtmeister
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: SQL Loader Load Problem

2001-12-19 Thread lhoska

page 121 'skipping fields you don't want to load' of g.gennick 'oracle
sql*loader' book.

-Original Message-
Sent: Wednesday, December 19, 2001 9:16 AM
To: Multiple recipients of list ORACLE-L


Ken,
 Good to know that it worked.
 Not sure what books you referred to, but if you deal with SQL*Loader a lot,
then you may want to check out Jonathan Gennick's book titled 'Oracle
SQL*Loader : The Definitive Guide' by O'Reilly.  

 Regards.

- Kirti

-Original Message-
Sent: Wednesday, December 19, 2001 7:20 AM
To: Multiple recipients of list ORACLE-L


Kirti:

Another person recommended this approach and it worked very nicely.  To bad
it's not in the book.

Thanks much,

Ken


 -Original Message-
Sent:   Tuesday, December 18, 2001 10:20 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL Loader Load Problem

Ken,
 If you are using 8i, then you can use the 'filler' fields. 
 In this case the control file would look something like below(considering
the fields are terminated by a comma and the table has columns a, b and c)

 load data
   infile 'myfile'
   into table mytable
   fields terminated by ','
 (a char,
  b char,
  f3 filler char, 
  f4 filler char, 
  f5 filler char, 
  f6 filler char, 
  
  f42 filler char,
  c char
 )

If you are not using 8i, then you can not avoid an intermediate table, or
use OS level tools to chop off the unwanted fields. 

HTH,

- Kirti 

-Original Message-
Sent: Tuesday, December 18, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L


I have an input file that is delimited and contains 43 fields of various
widths.  I need to load only 3 fields into a DB table of 3 columns.   2 of
the fields are at the beginning of the record and 1 is the very last field
in the record.  How can I load only these 3 cols and ignore the other 40
cols I don't need without having to use an intermediate table?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: SQL Loader Load Problem

2001-12-19 Thread Deshpande, Kirti

Ken,
 Good to know that it worked.
 Not sure what books you referred to, but if you deal with SQL*Loader a lot,
then you may want to check out Jonathan Gennick's book titled 'Oracle
SQL*Loader : The Definitive Guide' by O'Reilly.  

 Regards.

- Kirti

-Original Message-
Sent: Wednesday, December 19, 2001 7:20 AM
To: Multiple recipients of list ORACLE-L


Kirti:

Another person recommended this approach and it worked very nicely.  To bad
it's not in the book.

Thanks much,

Ken


 -Original Message-
Sent:   Tuesday, December 18, 2001 10:20 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: SQL Loader Load Problem

Ken,
 If you are using 8i, then you can use the 'filler' fields. 
 In this case the control file would look something like below(considering
the fields are terminated by a comma and the table has columns a, b and c)

 load data
   infile 'myfile'
   into table mytable
   fields terminated by ','
 (a char,
  b char,
  f3 filler char, 
  f4 filler char, 
  f5 filler char, 
  f6 filler char, 
  
  f42 filler char,
  c char
 )

If you are not using 8i, then you can not avoid an intermediate table, or
use OS level tools to chop off the unwanted fields. 

HTH,

- Kirti 

-Original Message-
Sent: Tuesday, December 18, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L


I have an input file that is delimited and contains 43 fields of various
widths.  I need to load only 3 fields into a DB table of 3 columns.   2 of
the fields are at the beginning of the record and 1 is the very last field
in the record.  How can I load only these 3 cols and ignore the other 40
cols I don't need without having to use an intermediate table?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: SQL Loader Load Problem

2001-12-19 Thread Ken Janusz

Kirti:

Another person recommended this approach and it worked very nicely.  To bad
it's not in the book.

Thanks much,

Ken


 -Original Message-
Sent:   Tuesday, December 18, 2001 10:20 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: SQL Loader Load Problem

Ken,
 If you are using 8i, then you can use the 'filler' fields. 
 In this case the control file would look something like below(considering
the fields are terminated by a comma and the table has columns a, b and c)

 load data
   infile 'myfile'
   into table mytable
   fields terminated by ','
 (a char,
  b char,
  f3 filler char, 
  f4 filler char, 
  f5 filler char, 
  f6 filler char, 
  
  f42 filler char,
  c char
 )

If you are not using 8i, then you can not avoid an intermediate table, or
use OS level tools to chop off the unwanted fields. 

HTH,

- Kirti 

-Original Message-
Sent: Tuesday, December 18, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L


I have an input file that is delimited and contains 43 fields of various
widths.  I need to load only 3 fields into a DB table of 3 columns.   2 of
the fields are at the beginning of the record and 1 is the very last field
in the record.  How can I load only these 3 cols and ignore the other 40
cols I don't need without having to use an intermediate table?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: SQL Loader Load Problem

2001-12-18 Thread Deshpande, Kirti

Ken,
 If you are using 8i, then you can use the 'filler' fields. 
 In this case the control file would look something like below(considering
the fields are terminated by a comma and the table has columns a, b and c)

 load data
   infile 'myfile'
   into table mytable
   fields terminated by ','
 (a char,
  b char,
  f3 filler char, 
  f4 filler char, 
  f5 filler char, 
  f6 filler char, 
  
  f42 filler char,
  c char
 )

If you are not using 8i, then you can not avoid an intermediate table, or
use OS level tools to chop off the unwanted fields. 

HTH,

- Kirti 

-Original Message-
Sent: Tuesday, December 18, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L


I have an input file that is delimited and contains 43 fields of various
widths.  I need to load only 3 fields into a DB table of 3 columns.   2 of
the fields are at the beginning of the record and 1 is the very last field
in the record.  How can I load only these 3 cols and ignore the other 40
cols I don't need without having to use an intermediate table?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



SQL Loader Load Problem

2001-12-18 Thread Ken Janusz

I have an input file that is delimited and contains 43 fields of various
widths.  I need to load only 3 fields into a DB table of 3 columns.   2 of
the fields are at the beginning of the record and 1 is the very last field
in the record.  How can I load only these 3 cols and ignore the other 40
cols I don't need without having to use an intermediate table?

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



SQL Loader Load Problem

2001-12-18 Thread Ken Janusz

I have a data file of 11 fields to load into a table of 8 columns.  I only
have to load 3 of the input fields.  How do I handle the extra input fields?
I cannot use the DB table column for filler more than once.  Can I just
ignore the input fields I don't have to load?  I am using "trailing nulls"
and options direct=true.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).