OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » SQLLOADER

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQLLOADER [message #71222]

Thu, 26 September 2002 04:39

Sherrie Hobbs
Messages: 3
Registered: September 2002

Junior Member

I am having a problem loading data from fixed length data file to Oracle table using SQLLOAD. In the data file there are blanks in the date column sometime. I have try decode, but none of the dates are populated in the field. In the Oracle table the field data type is date. Have anyone encounted this problem before.

Report message to a moderator

Re: SQLLOADER [message #71223 is a reply to message #71222]

Thu, 26 September 2002 06:05

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

u can use NVL function.

Report message to a moderator

Re: SQLLOADER [message #71225 is a reply to message #71222]

Thu, 26 September 2002 06:59

Sherrie Hobbs
Messages: 3
Registered: September 2002

Junior Member

When I use NVL I got this message
Record 16: Rejected - Error on table ASW_INVOICE_HEADER, column CASH_DISCOUNT1_DUE_DT.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Report message to a moderator

Re: SQLLOADER [message #71227 is a reply to message #71225]

Thu, 26 September 2002 07:12

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

try something like this

fields terminated by ','
optionally enclosed by '"'
trailing nullcols
(
shared_member nullif shared_member= "(null)",
bdbudg nullif bdbudg ="(null)",
idc1 nullif idc1="(null)",
idc2 nullif idc2="(null)",
idc3 nullif idc3="(null)"

Report message to a moderator

Re: SQLLOADER [message #71475 is a reply to message #71222]

Fri, 08 November 2002 11:13

Koos Post
Messages: 2
Registered: November 2002

Junior Member

Hello guys and girls, please help me.

I'm just beginning with oracle, being confronted with
the following problem making the ctl.file.

The database contains � table with one single field, let say, why not, money : datatype number(8,2).

The input file is variable of length, contains the
delimiter &#124, for example :

54123.45
34.20|

it's in the input file regarded as dec(8,2); the unload-specification from an informix-database.

how to make the field specification ?

money integer ?
money dec(8,2) ?
maybe with zones ?

I've tried several things, but it didnt work out.
So, if you have a good suggestion, mail me.

The last question : do you know a website with fabulous
information about sql Loader ? please give it to me.

Well, that's it.
I want to excuse me for my poor knowledge, as i said before, i'm no pro, not at all. Just beginning,

with friendly regards from the netherlands,

Koos

Report message to a moderator

Previous Topic:	Help me!!!
Next Topic:	field description

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 09:00:20 CDT 2024