OraFAQ Forum: Server Utilities » SQL Loader / Eliminate Trailing Last Record

Home » RDBMS Server » Server Utilities » SQL Loader / Eliminate Trailing Last Record

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

SQL Loader / Eliminate Trailing Last Record [message #157165]

Tue, 31 January 2006 12:58

Ganeshbabu Venkat
Messages: 17
Registered: March 2001

Junior Member

Want to know how to strip out the trailing row while using SQl loader scripts.

26182886132SMO
26182886132SMO
3200512200000009500000093

This is the file format. I need to eliminate the one that starts with the 3 the lengty string.will it be better to specify in the control file or the shell script. please explain with examples. or some code.

Report message to a moderator

Re: SQL Loader / Eliminate Trailing Last Record [message #157169 is a reply to message #157165]

Tue, 31 January 2006 13:15

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

In the controlfile use:

when (1) != '3'

after your INTO {table} line. This will ignore rows that have a '3' in position 1.

Report message to a moderator

Re: SQL Loader / Eliminate Trailing Last Record [message #157170 is a reply to message #157165]

Tue, 31 January 2006 13:24

Ganeshbabu Venkat
Messages: 17
Registered: March 2001

Junior Member

Thanks a lot it worked.

Report message to a moderator

Re: SQL Loader / Eliminate Trailing Last Record [message #157172 is a reply to message #157165]

Tue, 31 January 2006 13:30

Ganeshbabu Venkat
Messages: 17
Registered: March 2001

Junior Member

Are there performance issues involved with using the logical operator. Is there a way we can capture that in the unix file itself?

Report message to a moderator

Previous Topic:	problem in loading data from excel sheet
Next Topic:	Concatenate records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 04:05:32 CDT 2024