Using CONSTANT in Sql*Loader Control File

From: <wangliying_at_my-dejanews.com>
Date: Fri, 04 Sep 1998 01:18:24 GMT
Message-ID: <6snf51$v80$1_at_nnrp1.dejanews.com>

I am having troulbe to specify a CONSTANT in my Sql*Loader control file. The end result is that twice as many records were loaded. For every other record in the table, there would be a dummy record which contains nothing but the CONSTANT '31-May-98". Can somebody help. Thanks. Cindy

OPTIONS (BINDSIZE=128000, ERRORS=1000000) LOAD DATA INFILE 'sys:\enlp9805.txt' BADFILE 'sys:\hifreq1.bad' APPEND DISCARDFILE 'sys:\hifreq1.dsc' INTO TABLE TABLE_1 ( TIME_SLICE constant

'31-May-98',  SSN		position(1:9),	SEX  position(47:47),  NAME  
  position(10:36),  ENL_MGT_COMMUNITY		  position(50:53),

PRES_RATE_CODE_PG position(60:60)
"decode(:pres_rate_code_pg,'7','1','6','2','J','8','A','9',' ')", ADSD_ADBD
position(177:182), EAOS position(195:200)
"decode(decode(substr(:eaos,1,2),'00',1,'01',1,'20',1,0),1,'20','19') ||
:eaos", ONBOARD_PARENT_UIC position(234:238), ONBOARD_ACTUAL_UIC position(239:243), ONBOARD_ACTY_NAME position(717:732), ONBOARD_SS

position(247:247),  LOSS_CODE		      position(751:753),  LOSS_DATE  
		position(754:757) )

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 04 1998 - 03:18:24 CEST