To run sqlldr use below cmd at cmdprompt :
sqlldr userid = "db_user" control="CTRLFILENM" data="INFO_CALENDAR.DMP"  

u can remove infile entry from control file & can specify it above.(data = "datafilenm" as
mentioned above).
U can also move discardfile,discardmax entries  & place it above.(discardfile="FNM" 
discardmax=999)

-----Original Message-----
From: Antje.Sackwitz [mailto:Antje.Sackwitz@ppi.de]
Sent: Thursday, July 18, 2002 1:19 PM
To: Manoj, COSLTEMP-G
Cc: Antje.Sackwitz
Subject: Oracle-L, SQL-loader

Hi,
can you please have a look:
Is the top part the correct syntax for the controlfile? How do I call the
loader? I am just irritated by the manual.

LOAD DATA
INFILE 'INFO_CALENDAR.DMP'
DISCARDFILE 'INFO_CALENDAR.DSC'
DISCARDMAX = 999
REPLACE
CONTINUEIF THIS (1) = '*'
INTO TABLE info_calendar
(
  Date_int  	Postition(1:8)		int,
  Date_date 	Position(10:35)		date 'Mon dd yyyy hh:mi:ss'
"RTRIM(:Date_date,':000AM')",
  Weekday_int	Position(36:37)		smallint,
  Weekday_str	Position(39:48)		varchar(16),
  DayOfYear_int Position(50:51)		smallint,
  Week_int      Position(53:55)		smallint,
  Month_int     Position(57:59)		smallint,
  Month_str     Position(61:70)		varchar(16),
  Quarter_int   Position(72:73)		smallint,
  Year_int      Position(75:79)		smallint,
  YearOfWeek_int Position(81:85)	smallint
)

--------
just for information
20020101	Jan  1 2002 12:00:00:000AM	3	Tuesday	1	1
1	January	1	2002	2002
20020102	Jan  2 2002 12:00:00:000AM	4	Wednesday	2
1	1	January	1	2002	2002
table INFO_Calendar
(
  Date_int                      number        not null,
  Date_date                   date        not null,
  Weekday_int               number        not null,
  Weekday_str               varchar2(16)   not null,
  DayOfYear_int             number        not null,
  Week_int                    number        not null,
  Month_int                   number        not null,
  Month_str                   varchar2(16)   not null,
  Quarter_int                 number        not null,
  Year_int                     number        not null,
  YearOfWeek_int         number        not null
)

____________________________
  Antje Sackwitz
  ppi Media GmbH
  Deliusstraße 10
  D-24114 Kiel
  phone	+49 (0) 43 1-53 53-2 16
  fax     	+49 (0) 43 1-53 53-2 22
  email	mailto:antje.sackwitz@ppi.de
  web	www.ppi.de