Importing data from a text file...

[Edis, Bob]

G'day Chris
 
I would not use QTP to load an ASCII file into an Oracle RDBMS table.
Instead use SQL*Loader, assuming you are not interested in the full data
integrity checking that QTP has.  SQL*Loader is FAR more efficient in doing
bulk data loads into Oracle databases.
 
Regards,
Blue

-----Original Message-----
From: Gassett, Chris [mailto:Gassett@aavid.com]
Sent: Thursday, February 22, 2001 9:33 AM
To: 'powerh-l@sphere.swau.edu'
Subject: Importing data from a text file...


I need to update one of our Oracle tables with a flat text file.  This is
what I did:
 
;* Step 1 sets up my dictionary
cancel clear
set default
set verify errors
access suppliers
set subfile name AVL keep
report summary supplierno
go
 
;* Step 2
I issue a UNIX command to strip any funky characters from the text file and
replace the data in the subfile with the data from the text file.
tr -d '\12' < avl.txt > AVL.sf
 
Ex. of the avl.txt file.  There are 300+ records that will need to be
imported:
000001
00024
000345
692345
 
This works great, except that the fields are variable in width and those
that are narrower are filled in with zero characters, which I don't want
when I import.
 
>From the subfile I would import that data into the database with a qtp.
Anyone have any other ideas or suggestions?  Is there an easier way?
 
 
PowerHouse 8.13

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.