i forgot to mention that i did look in to manual

> -----Original Message-----
> From: Ghadge,Sameer 
> Sent: Tuesday, February 05, 2002 1:41 PM
> To:   'Multiple recipients of list ORACLE-L'
> Subject:      how to Loading data file (SQL LOADER)
> 
> Hi all,
> Just think some how i have foll. file(I have a data file coming from
> VAX/VMS machine,on unix machine ,but i currently want soln for WIN2000)
> 
> HDR 280120022044
> SELL031128012002ESP00000000050000000000001712311ESP28A
> SELL055728012002EUR00000000002000000000011534557EUR28A
> SELL015728012002USD00000000000500000000003289157USD28A
> SELL005328012002USD00000000001000000000006579053USD28A
> SELL046428012002EUR00000000006000000000034602464EUR28A
> TRL 000137
> Record structure
> Record Size:        54 Bytes
> -- Record Contents --
>     Item                                 Type            Size  Occ  Offset
>     IMX-HEADER-RECORD                    CHARACTER         54            0
>     .IMX-HEADER-TYPE                     CHARACTER          4            0
>     .PROCESS-DATE                        CHARACTER         12            4
>    _IMX-DETAIL-RECORD                    CHARACTER         54            0
>     .IMX-DETAIL-TYPE                     CHARACTER          4            0
>     .SHOP-NUMBER                         CHARACTER          4            4
>     .TRANSACTION-DATE                    CHARACTER          8            8
>     .CURRENCY-CODE                       CHARACTER          3           16
>     Item                                 Type            Size  Occ  Offset
>     .IMX-CURRENCY-VALUE                  ZONED UNSIGNED    13           19
>     .IMX-STERLING-EQUIVALENT             ZONED UNSIGNED    13           32
>     .REFERENCE-NUMBER                    CHARACTER          9           45
>    _IMX-TRAILER-RECORD                   CHARACTER         54            0
>     .IMX-TRAILER-TYPE                    CHARACTER          4            0
>     .IMX-RECORD-COUNT                    ZONED UNSIGNED     6            4
> 
> 
> 
> How do I load this using SQLoader (is it possible)
> ya u all must be thinking ,i m loading flat file in a table and not
> applying RDBMS (normalization) concepts.
> but that the way i have to do,(now don't ask why? we'll discuss off the
> list)
> 
> so my table struct is as foll.
> Name                            Null?    Type
> ------------------------------- -------- ----
> IMX_REC_TYPE                          NOT NULL VARCHAR2(4)
> SHOP_NO                                       VARCHAR2(4)
> TRANSACTION_DATE                      DATE
> CURRENCY_CODE                   VARCHAR2(3)
> IMX_CURRENCY_VALUE          NUMBER(13)
> IMX_STERLING_EQUIVALENT   NUMBER(13)
> REFERENCE_NUMBER            VARCHAR2(9)
> PROCESS_DATE                     DATE
> IMX_RECORD_COUNT              NUMBER(6)
> IMX_REC_NO                           NUMBER(6)
> 
> any help is appreciated
> using oracle 8.1.6 on win2000
> Thx
> Sameer
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ghadge,Sameer
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Reply via email to