Loading portable subfile data into Oracle using QTP

[Jayson Garrett]

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.