Re: SQL*Loader

LT> I want to know if a data file contains data of LONG or ROW type,
LT> can I still use SQL*LOADER to upload the file to database? If
LT> yes, how I can specify the length in the control file?

I use fix length layouts to SQL*Load mainframe data. Here's a UNIX SQL*Loader control file I use:

LOAD DATA
INFILE '$FILE' "fix 245"
INSERT
INTO TABLE BS2_Plan
(

  dbkey1                 position(001:004) raw(4),
  dbkey2                 position(005:008) raw(4),
  plan_code              position(009:011) ,
  name                   position(012:051) ,
  .. etc. ...
  wait_period            position(244:245) ,

• RM 1.31 3337 *