Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> DB2 sort to Oracle?
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 Received on Tue Nov 30 1999 - 07:17:39 CST