Home » RDBMS Server » Server Utilities » Help about Sql loader
Help about Sql loader [message #275632] Mon, 22 October 2007 02:43 Go to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
hi,

I have one doubt

This is my script
LOAD DATA
INFILE 'COSTCENTER.TXT'
REPLACE
INTO TABLE OMF_API_COSTCENTER
(CCN_CODE POSITION(1:30),
CCN_DESC POSITION(31:60),
CCN_LINE_OF_BUS_CD POSITION(61:90)"nvl(:ccn_line_of_bus_cd,NULL)",
CCN_LINE_OF_BUS_DESC POSITION(91:120),
CST_ID POSITION(121:135) "CSTCEN_SEQNUM.nextval"


After run this script in Unix environment, I got one error
"Expecting valid column specification, "," or ")", found end of file.


I want to insert the nulls whereever the no values in table

please help this query
Re: Help about Sql loader [message #275634 is a reply to message #275632] Mon, 22 October 2007 02:52 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Use, TRAILING NULLCOLS clause
Re: Help about Sql loader [message #275638 is a reply to message #275632] Mon, 22 October 2007 03:16 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And remove "nvl(:ccn_line_of_bus_cd,NULL)".

Regards
Michel
Previous Topic: CSSCAN
Next Topic: migrate data from forpro to oracle (merged)
Goto Forum:
  


Current Time: Sat Dec 10 20:26:36 CST 2016

Total time taken to generate the page: 0.03878 seconds