RE: SQL Loader Question

From: Zanen van, J (Jacob) <Jacob.van.Zanen_at_rabobank.com>
Date: Tue, 25 Sep 2007 08:27:19 +1000
Message-ID: <49AD3377867B8A46A6B58C1551D4B55C01A7F827@rabobank.com>

SQL*Loader and external tables rely on the same technology as far as I am aware.

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_at_vanzanen.com> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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
______________________________________________________________

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 24 2007 - 17:27:19 CDT