0

Hi

My one applicaton using sqlldr utility to load data in database from flat text file. Now there are change in table name. I open this .ctl file in text pad and made changes but its not working. I am providing flat file name and other file name as a parameter. Following are to content of .ctl file. Please help me how to change .ctl content and in which i do that ?

Content of .ctl file
------------------------------------------------------------
Load DATA

APPEND INTO TABLE PDT_ADMIN.PDT_SO8_LOADER
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(
TN
, CUST_CODE
, ORDER_NUMBER
, STATUS
, COMPLETION_DATE DATE "yyyymmdd"
, IRESH
, ORESH
, RESH
, IAECN_CODE
, IAECN_NUM
, OAECN_CODE
, OAECN_NUM
, AECN_CODE
, AECN_NUM
, LN
, OLN
, CENT
, BTN
, BTN_CC
, YYMM
, APP_DATE DATE "yyyymmdd"
, TARIFF_STATE
, DENIAL_ORDER
, SA
, OSA
, ORIG_USOC_COUNT
, USOC_COUNT
, USOC_STRING_LEN
, USOCS char(2000)
, ZDEL char(1)
, POST_DATE DATE "yyyymmdd"
, OBTN
, OBTN_CC
, OTN
, OTN_CC
)
---------------------------------------------------------------------

when i use file with previous table name its working but after change it showing error, suggest me which utility i will use to write this .ctl file and how?

welcome all your valuable advice.
Thnx in advance

2
Contributors
3
Replies
5
Views
6 Years
Discussion Span
Last Post by Momerath
0

Does the table your are trying to fill exist? Do all the column name/types match? What error are you getting?

0

Hi,
Column name are matching, i am using sqlldr in another c# program, there are showing error code is 1, when i use default (previous) table its working, both table (new and exitsting) is same only name are diferent.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.