RE: SQL Loader Question
- From: "Zanen van, J (Jacob)" <Jacob.van.Zanen@xxxxxxxxxxxx>
- To: <gba.oraclel@xxxxxxxxx>, "Jack van Zanen" <jack@xxxxxxxxxxxx>
- Date: Tue, 25 Sep 2007 08:27:19 +1000
SQL*Loader and external tables rely on the same technology as far as I
am aware.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of GBA-DBA
Sent: Tuesday, 25 September 2007 6:10 AM
To: Jack van Zanen
Cc: Oracle Discussion List
Subject: Re: SQL Loader Question
Hi Jack,
I'm using 10g R2. I'm loading the table using PL/SQL but the standard
here is SQL Loader for these tasks and they want it that way.
Regards,
GBA
On 9/24/07, Jack van Zanen <jack@xxxxxxxxxxxx> wrote:
Hi
You mention no Oracle version but....
How about make it an external table and take it from there?
Jack
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of GBA-DBA
Sent: Tuesday, 25 September 2007 3:23 AM
To: Oracle Discussion List
Subject: SQL Loader Question
Hi List,
I need to load a cobol file with a record structure (a portion
of it) like this:
10 MV-TPR-BILL-AMT-REC-TO-DATE PIC S9(07)V99.
10 MV-TPR-BILL-NH-DIAG-DESC PIC X(30).
10 MV-TPR-BILL-DRUG-CODE-DESC REDEFINES
MV-TPR-BILL-NH-DIAG-DESC PIC X(30).
10 MV-TPR-BILL-NH-TOTAL-COST PIC S9(5)V99.
10 MV-TPR-BILL-2ND-NOTICE-DATE PIC X(8).
10 MV-TPR-BILL-WRITE-OFF-DATE PIC X(8).
10 MV-TPR-BILL-RESPONSE-INFO OCCURS 3 TIMES.
20 MV-TPR-DATE-OF-RESPONSE PIC X(8).
20 MV-TPR-RESP-ACTION-CODE PIC X(02).
20 MV-TPR-RESP-EXPLN-CODE.
30 RESPONSE-OVERIDE-CODE PIC X.
30 FILLER PIC X.
20 MV-TPR-RESP-AMT-PAID PIC S9(5)V99.
20 MV-TPR-COST-CNT-ACCT-CODE PIC X(5).
20 FILLER PIC X(09).
10 MV-TPR-BILL-RCD-CNTR PIC 99.
10 MV-TPR-BILL-PAYT-DATA OCCURS 1 TO 50 TIMES
DEPENDING ON MV-TPR-BILL-RCD-CNTR.
20 FILLER PIC X(109).
20 MV-TPR-BILL-HIST-REC-INDCATOR PIC X.
20 FILLER PIC X(08).
20 MV-TPR-BILL-SVC-CD PIC X(01).
20 MV-TPR-BILL-BILL-CD PIC X(03).
The fields outside the occurs sections should go to table 1, the
fields inside the occurs 3 section should go to table 2 and the fields
inside the occurs 1 to 50 section should go to table 3.
Once the data is loaded the data should be like this: For each
record in table 1 I should have 1 to 3 records in table 2 and 1 to 50
records in table 3.
Is there any way to do this with SQL Loader??
--
Regards
GBA
--
Regards
GBA
______________________________________________________________
This email, including any attachments, may be confidential or privileged, and
is sent for the personal attention of the intended recipient. If you have
received this email in error, please delete it immediately. The views
expressed are not necessarily those of the Rabobank Group. The Group is not
liable for the effects of any virus which may be contained in this email.
If this email contains marketing material and you do not wish to receive such
material by email in future, please reply to this email and place the words
"Remove My Details - Electronic Messages" in the Subject Header.
The Rabobank Group
Australia: 1800 025 484
New Zealand: 0800 500 933
______________________________________________________________
Other related posts:
