Need help with sqlloader 1

[rogers42]

Hi Folks,

Snippet of my ctl file looks as follows

...
PINGABLE CHAR "DECODE('0', 'NON PINGABLE',
'1', 'PINGABLE',
'UNKNOWN')",
....

This particular field is defined as follows in my table

PINGABLE VARCHAR2(15)

While the data is loaded sucessfully, the PINGABLE column is blank.

I have also tried loading the data without using the DECODE function and it works fine.

Can somebody spot anything that I might have missed.

Thanks in advance

rogers42

 

[rogers42]

Hi,

I figured out the problem. The correct syntax is as follows

....
PINGABLE CHAR "DECODEPINGABLE, '0', 'NON PINGABLE',
'1', 'PINGABLE',
'UNKNOWN')",
....

Thanks

rogers42

 

[SantaMufasa]

Rogers,

In addition to figuring out the problem on your own, because of your posting your findings, it made this thread very valuable. (Amazing how important a colon can be, huh! <grin>)

As a result, you deserve a

.

Cheers,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
A fo ben, bid bont.

 

[SantaMufasa]

...not that the colon was the only thing missing...The presence of the colon reminds subsequent readers that they must use the colon (signalling a bind-variable reference) when referencing columns as function arguments in SQL*Loader.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
A fo ben, bid bont.