Re: help

From: GHouck <hksys_at_teleport.com>
Date: Wed, 09 Jun 1999 14:13:18 -0700
Message-ID: <375ED8EE.7773@teleport.com>

Chen Li wrote:
>
> Hi, all
>
> how to use SQL statement in SQL Loader control file?
>
> Thanks,
> Li Chen

LOAD DATA
INFILE 'input.dat'
REPLACE
INTO TABLE mytable
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY "'" TRAILING NULLCOLS (
  pageno,
  lineno,
  mapno,
  pmtno,
  mapgrid,
  mntid,
  owner,
  guysize,
  renthgt,
  effdate "to_date(:effdate,'mm/yy')",
  cmnt
)

In this case, the SQL function 'to_date' is being used to convert the input 'mm/yy' to a date. Note the colon (:) in front of the column name within the statement.

Yours,

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Wed Jun 09 1999 - 16:13:18 CDT