Loading portable subfile data into Oracle using QTP

[Robert J.M. Edis]

Jayson

I would use QUIZ to produce a .DAT file that can be used by SQL Loader
instead of a portable subfile.  The portable subfile is a fixed length
record format and the fields will be padded.  Short of using TRUNCATE() on
every field when writing to the Oracle table, there is not easy way to do
what you want.

To create the .DAT file, first run a preprocess that creates the header
records used by SQL Loader then create the output using SET SUBFILE NAME
xxxxx NODICTIONARY.

I think SQL Loader will work with all Oracle RDBMS engines.  You didn't
specify which one you were using.

Just an idea.

Blue
PowerHouse consultant
Rhode Island, USA

Disclaimer:
The opinions and ideas expressed in this message are my own and have no
relationship to my current employer, Initial Technical Staffing, its client
CCI, or any of CCI's clients.



	-----Original Message-----
	From:	Jayson Garrett [SMTP:Garrett@mc.edu]
	Sent:	Wednesday, May 05, 1999 2:53 PM
	To:	powerh-l@lists.swau.edu
	Subject:	Loading portable subfile data into Oracle using QTP

	I'm creating a portable subfile using QTP 7.09E on MPE, transferring
that file to our HP9000, and using QTP 8.13D to load the portable subfile
data into an Oracle table.

	However, the data that gets loaded into Oracle has trailing spaces
attached to it, even though this is unnecessary and undesirable in a
relational database.

	What's the best means of ditching the trailing spaces? Is there some
way to tell QTP not to include those other than TRUNCing each field on the
way in?

	Thanks!

	=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

	Jayson T. Garrett, Mississippi College Computer Center
	P.O. Box 4026, Clinton, MS 39058
	601.925.3826   garrett@mc.edu   http://www.mc.edu/~garrett 

	"The human race is divided into two sharply differentiated and
	mutually antagonistic classes -- a small minority that plays with
	ideas and is capable of taking them in, and a vast majority that
	finds them painful, and is thus arrayed against them."
	    -- H.L. Mencken


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