Home » RDBMS Server » Server Utilities » Issue in SQL loader control file (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit windows)
Issue in SQL loader control file [message #663405] Fri, 02 June 2017 03:08 Go to previous message
arpit0508
Messages: 6
Registered: June 2015
Location: Mumbai
Junior Member
Hi All,

LOAD DATA
APPEND
INTO TABLE SMD_INDEX_COMPOSITION_B3
WHEN index_ric_code = '.MCX'
FIELDS TERMINATED BY '|'
(
dummy FILLER,
index_ric_code "TRIM(:index_ric_code)",
ric_code "TRIM(:ric_code)",
constituent_name "TRIM(:constituent_name)",
ntpa_code "TRIM(:ntpa_code)",
business_date EXPRESSION "TO_DATE('##COB_DATE##','YYYYMMDD')",
run_id CONSTANT '##RUN_ID##'
)
INTO TABLE SMD_INDEX_COMPOSITION_B3
WHEN index_ric_code = '.FTMIB'
FIELDS TERMINATED BY '|'
(
dummy FILLER,
index_ric_code "TRIM(:index_ric_code)",
ric_code POSITION (1) "TRIM(:ric_code)",
constituent_name "TRIM(:constituent_name)",
ntpa_code "TRIM(:ntpa_code)",
business_date EXPRESSION "TO_DATE('##COB_DATE##','YYYYMMDD')",
run_id CONSTANT '##RUN_ID##'
)
~

I am trying to load the data from txt file into table. above mentioned control file is working fine with no error. But it loaded the data only for condition WHEN index_ric_code = '.MCX' not for index_ric_code = '.FTMIB'.if i mentioned index_ric_code = '.FTMIB' condition first then its loaded data for index_ric_code = '.FTMIB' condition. I want this control file should load the data for both the condition.
Could you please help me on this.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Export/Import Criteria
Next Topic: Schema Expired & Locked after import
Goto Forum:
  


Current Time: Fri Mar 29 00:19:26 CDT 2024