Home » RDBMS Server » Server Utilities » sqlldr when
sqlldr when [message #266806] Tue, 11 September 2007 12:33 Go to next message
mjgerry3006
Messages: 4
Registered: September 2007
Location: albany,ny
Junior Member
shoudl be simple enough, but can not find

I only wish to load to a table if a specific column is NOT NULL

into table ....
when column is not null (no good)
not null (no good)
<> null (no good)

ideas please ?
Re: sqlldr when [message #266814 is a reply to message #266806] Tue, 11 September 2007 12:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I should say "use external table".

Regards
Michel
Re: sqlldr when [message #266816 is a reply to message #266814] Tue, 11 September 2007 12:59 Go to previous messageGo to next message
mjgerry3006
Messages: 4
Registered: September 2007
Location: albany,ny
Junior Member
Im missing something - its flat file now.
I want to integeragte one column, and if NOT Null, load a table(internal)

I error out with

"Expecting quoted string or hex identifier, found "NULL".
WHEN(NATIONAL_DRUG_CODE_E1856 = NULL)"

Seems to not recogize "NULL"
Re: sqlldr when [message #266818 is a reply to message #266806] Tue, 11 September 2007 13:05 Go to previous messageGo to next message
mjgerry3006
Messages: 4
Registered: September 2007
Location: albany,ny
Junior Member
I mean I could load to a staging table, then use sql to only load the rows that the column is populated in.
Re: sqlldr when [message #266824 is a reply to message #266818] Tue, 11 September 2007 13:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for external table in the documentation.

Regards
Michel
Re: sqlldr when [message #266837 is a reply to message #266806] Tue, 11 September 2007 14:17 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
If you want to use sqlldr, try

NATIONAL_DRUG_CODE_E1856 = blanks
Re: sqlldr when [message #267083 is a reply to message #266806] Wed, 12 September 2007 08:02 Go to previous message
mjgerry3006
Messages: 4
Registered: September 2007
Location: albany,ny
Junior Member
thanks, this works. I had done != ' ', but blanks is nicer
Previous Topic: EXP-00056 Oracle Error 6550 encountered
Next Topic: Importing a schema
Goto Forum:
  


Current Time: Sun Dec 04 10:35:14 CST 2016

Total time taken to generate the page: 0.05116 seconds