OraFAQ Forum: Server Utilities » EBCDIC and the WHEN clause

Home » RDBMS Server » Server Utilities » EBCDIC and the WHEN clause

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

EBCDIC and the WHEN clause [message #69629]

Sun, 10 February 2002 12:03

Andrea
Messages: 15
Registered: February 2002

Junior Member

Hi

I am loading an EBCDIC file into a table.

Everything is ok until I try to use a WHEN clause to add only certain rows. All rows fail the clause yet I know at least 1 should load.

Can anyone shed any light on this?

Andrea

Report message to a moderator

Re: EBCDIC and the WHEN clause [message #69678 is a reply to message #69629]

Fri, 15 February 2002 08:41

Grant
Messages: 578
Registered: January 2002

Senior Member

Show your load script.

Report message to a moderator

Re: EBCDIC and the WHEN clause [message #69684 is a reply to message #69629]

Sun, 17 February 2002 09:14

Andrea
Messages: 15
Registered: February 2002

Junior Member

The load script was part of the original TAR. But here it is again!

LOAD DATA CHARACTERSET WE8EBCDIC500
INFILE Iak842.ebc "fix 234"
REPLACE
INTO TABLE temp_call_header
WHEN (1:20)= '000000000000'
(
HEADER_ID POSITION(1:20) CHAR,
DESTINATION_SYS POSITION(21:25) CHAR,
DESTINATION_SITE POSITION(26:28) CHAR,
SOURCE_SYS POSITION(29:33) CHAR
)

Report message to a moderator

Re: EBCDIC and the WHEN clause [message #69696 is a reply to message #69629]

Tue, 19 February 2002 10:50

Grant
Messages: 578
Registered: January 2002

Senior Member

Sorry to take so long. SQLLOADER can only take character strings in the WHEN clause. A workaround would be to load all the data then delete what you don't want or load a temp table with all the records then insert to the target table with a select statement.

Report message to a moderator

Re: EBCDIC and the WHEN clause [message #70765 is a reply to message #69629]

Sun, 21 July 2002 22:29

Rangarajan
Messages: 4
Registered: October 2001

Junior Member

Dear sir,

I have doubt that if i use when clasue in sqlloader
then .. error in when clause then in which file the
error will be store

Report message to a moderator

Previous Topic:	How to Exclude Just One Table but take the FULL DB BACKUP using Exp/Imp in Oracle8i ?
Next Topic:	help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 15:46:49 CST 2025