Re: DB2 sort to Oracle?

From: <michael_bialik_at_my-deja.com>
Date: Tue, 30 Nov 1999 21:36:46 GMT
Message-ID: <821g1e$376$1@nnrp1.deja.com>

Hi.

Are you dealing with DB2/mainfraim VS Oracle/Unix ?

Michael.

In article <3843CE73.993B984B_at_ncsu.edu>, David Plotner <david_plotner_at_ncsu.edu> wrote:
> We need to set up a validation program (using powerbuilder) to compare
> the data in an Oracle db to that in a DB2 db. We have one problem.
They
> seem to use different language sets, which result in different
priority
> of the "order by" sequence. What I mean is on db does numbers, then
> letters, and the other does letters, then numbers. I thought we could
> use an NLSSORT, but need to know the language set to use to make the
> Oracle select comparable to the DB2 sort. Any suggestions?
>
> TIA,
>
> David P
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 30 1999 - 15:36:46 CST