Skip to Main Content

SQLLDR : using TRIM on COMMENT column

Vicky007May 14 2020 — edited May 15 2020

HI ,

I would like to know how we can apply trim function in control file columns ?

Here the case is a-bit different where column name is special reserved keyword COMMENT.

We can use reserve word by using double quotes around while doing select or even while loading. eg. "COMMENT"

But while applying trim function , it is not working , any suggestion on this ? may be Data Issue ? how to load it as it is getting loaded in MYSQL but not in ORacle 19c

OPTIONS (SKIP=1)

load data

APPEND

into table example

fields terminated by ","

OPTIONALLY ENCLOSED BY '"'

TRAILING NULLCOLS

(

A1,

"COMMENT" "TRIM(:\"COMMENT\")",

FILE_ID  CONSTANT 0,

)

Any suggestions how we can apply trim on COMMENT ?

We do not have option to rename the column in this case as it is fixed already in all system layers.

I found the record in file are having very different things and thus it is not getting loaded due to it. Check last column, any suggestion how we can load it ?

A1,Comment

1,Funds transferred from xxxxxxxxxxxxxxxxxxxxxxxxxx Account FT20134DB8VPB48                                                                                                                                                                                                                                                                                                                                       

2,Funds transferred from xxxxxxxxxxxxxxxxxxxxxxx Account FT20134CPLKKC12                                                                                                                                                                                                                                                                                                                                    

3,Funds transferred from xxxxxxxxxxxxxxxxxxxx Account FT201344KMFXC30                                                                                                                                                                                                                                                                                                                                      

4,Funds transferred from ssssssssssssssssssssss Account FT201340X0T7C13                                                                                                                                                                                                                                                                                                                                    

Comments
Post Details
Added on May 14 2020
3 comments
76 views