If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: SQL Loader

Originally posted by micnash This is a copy of my control file.
.....
FABBKTP_TRANS_DATE POSITION(0011:0020) CHAR "TO_DATE(TRIM(:FABBKTP_TRANS_DATE),‘DD-MON-YY’)",
.....

From your data that you send in another message it is obvious that the field :FABBKTP_TRANS_DATE in the text file is on positions 11 through 19. With this in mind and according to the date format you specified in your control file it is strange why you specified positions 11 through 20 for that field in jour ctl, isn't it. Can you change the above line into: