Oracle-L: Re: Try Again: Loading Data with "Return" key from SQL Loader

From: <Jared.Still_at_radisys.com>
Date: Mon, 07 Apr 2003 15:38:49 -0800
Message-ID: <F001.0057C725.20030407153849@fatcity.com>

see:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch07.htm#1006472

WLSH <wlsh1961_at_yahoo.com>
Sent by: root_at_fatcity.com
04/07/2003 09:33 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Try Again: Loading Data with "Return" key from SQL Loader - is it possible

WLSH <wlsh1961_at_yahoo.com> wrote:
Date: Mon, 7 Apr 2003 08:10:18 -0700 (PDT) To: ORACLE-L_at_fatcity.com

Hello, List:
I'm doing a load from SQL loader to DB Table. One field of data
(SERV_LONG_DESC) contains "RETURN" data. Is it possible to load it into
table? I'm not sure if SQL Loader can load from different lines. If not, any other options I can do this ?
The pure SERV_LONG_DESC field alone will be like:
(( REQUESTOR_NAME= Janet Abell

   REQUESTOR_PHONE_NUMBER= 215.234.9852
   FROM_ASSET_ID= CSC272002
  hERE IS A COMMENT
   MANUFACTURER= DELL
   MODEL_NUMBER= DELLATLP
   NEEDED_DATE=
   NEEDED_TIME=

   FROM_USER_NAME= Mary Abbott
   FROM_ASSET_DESCRIPTION_TEXT= Default system type
   FROM_FACILITY= DV-Y5-Y5
   FROM_LOCATION= DV-Y5-Y5-22-NA-Unkno

   REQUESTING_DEPARTMENT= DEPT
   PROGRAM_NAME=
   CATALOG_ID=
   SR_DESCRIPTION_TEXT= SURPLUS THIS ASSET    SR_COMMENTS_TEXT=DO THE PREFIELD ))
A complete one record will be like:
{"AA3861111","2342123","RC","AA","LGA", "01", "FRONT OFFC","20010101". "011100","REQUESTOR_NAME= Janet Abell

   REQUESTOR_PHONE_NUMBER= 215.234.9852
   FROM_ASSET_ID= CSC272002
  hERE IS A COMMENT
   MANUFACTURER= DELL
   MODEL_NUMBER= DELLATLP
   NEEDED_DATE=
   NEEDED_TIME=

   FROM_USER_NAME= Mary Abbott
   FROM_ASSET_DESCRIPTION_TEXT= Default system type
   FROM_FACILITY= DV-Y5-Y5
   FROM_LOCATION= DV-Y5-Y5-22-NA-Unkno

   REQUESTING_DEPARTMENT= DEPT
   PROGRAM_NAME=
   CATALOG_ID=
   SR_DESCRIPTION_TEXT= SURPLUS THIS ASSET    SR_COMMENTS_TEXT=DO THE PREFIELD"}
My current control file:

LOAD DATA
INFILE AHD_BILLING.DAT
REPLACE
INTO TABLE C_AHD_FEED
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'   TRAILING NULLCOLS
      ( TICKET_NUM position (*+1) char,
ASSET_NUM NULLIF ASSET_NUM = BLANKS,
ADJUSTMENT_IND CONSTANT 'N',
BILL_FLAG CONSTANT 'N',
DIVISION,
PLANT ,
BUILDING,
FLOOR ,
AREA ,
SERV_START_DATE "to_date(:SERV_START_DATE||:SERV_START_TIME,'yyyymmdd HH24:MI:SS')",
SERV_START_TIME,
SERV_LONG_DESC TERMINATED BY '}' OPTIONALLY ENCLOSED BY '"'       )

Thanks a lot for any idea!
Steven

Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Mon Apr 07 2003 - 18:38:49 CDT

Re: Try Again: Loading Data with "Return" key from SQL Loader - is it