Collation equivalence

Hello everyone,
I have a SQL 7 server and I am trying to find the equivalent collation in
SQL Server 2000. Output of sp_helpsort on the SQL 7:
Unicode data sorting
Locale ID = 33280
case sensitive
Sort Order Description
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 50, bin_iso_1
Binary Sort Order for the ISO 8859-1 (Latin 1) Character Set
Anyone knows where I can find out this information?
Thank you all!
--
Sasan Saidi
MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
Senior DBA
My guess is Latin1_General_BIN
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sasan Saidi" <SasanSaidi@.discussions.microsoft.com> wrote in message
news:5E7997A5-5CF2-4CB0-A5B3-A62765F687A2@.microsoft.com...
> Hello everyone,
> I have a SQL 7 server and I am trying to find the equivalent collation in
> SQL Server 2000. Output of sp_helpsort on the SQL 7:
> Unicode data sorting
> --
> Locale ID = 33280
> case sensitive
>
> Sort Order Description
> Character Set = 1, iso_1
> ISO 8859-1 (Latin-1) - Western European 8-bit character set.
> Sort Order = 50, bin_iso_1
> Binary Sort Order for the ISO 8859-1 (Latin 1) Character Set
> Anyone knows where I can find out this information?
> Thank you all!
> --
> --
> Sasan Saidi
> MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
> Senior DBA

Collation equivalence

Hello everyone,
I have a SQL 7 server and I am trying to find the equivalent collation in
SQL Server 2000. Output of sp_helpsort on the SQL 7:
Unicode data sorting
--
Locale ID = 33280
case sensitive
Sort Order Description
---
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 50, bin_iso_1
Binary Sort Order for the ISO 8859-1 (Latin 1) Character Set
Anyone knows where I can find out this information?
Thank you all!
--
Sasan Saidi
MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
Senior DBAMy guess is Latin1_General_BIN
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sasan Saidi" <SasanSaidi@.discussions.microsoft.com> wrote in message
news:5E7997A5-5CF2-4CB0-A5B3-A62765F687A2@.microsoft.com...
> Hello everyone,
> I have a SQL 7 server and I am trying to find the equivalent collation in
> SQL Server 2000. Output of sp_helpsort on the SQL 7:
> Unicode data sorting
> --
> Locale ID = 33280
> case sensitive
>
> Sort Order Description
> ---
> Character Set = 1, iso_1
> ISO 8859-1 (Latin-1) - Western European 8-bit character set.
> Sort Order = 50, bin_iso_1
> Binary Sort Order for the ISO 8859-1 (Latin 1) Character Set
> Anyone knows where I can find out this information?
> Thank you all!
> --
> --
> Sasan Saidi
> MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
> Senior DBA

Collation equivalence

Hello everyone,
I have a SQL 7 server and I am trying to find the equivalent collation in
SQL Server 2000. Output of sp_helpsort on the SQL 7:
Unicode data sorting
--
Locale ID = 33280
case sensitive
Sort Order Description
---
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 50, bin_iso_1
Binary Sort Order for the ISO 8859-1 (Latin 1) Character Set
Anyone knows where I can find out this information?
Thank you all!
--
--
Sasan Saidi
MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
Senior DBAMy guess is Latin1_General_BIN
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sasan Saidi" <SasanSaidi@.discussions.microsoft.com> wrote in message
news:5E7997A5-5CF2-4CB0-A5B3-A62765F687A2@.microsoft.com...
> Hello everyone,
> I have a SQL 7 server and I am trying to find the equivalent collation in
> SQL Server 2000. Output of sp_helpsort on the SQL 7:
> Unicode data sorting
> --
> Locale ID = 33280
> case sensitive
>
> Sort Order Description
> ---
> Character Set = 1, iso_1
> ISO 8859-1 (Latin-1) - Western European 8-bit character set.
> Sort Order = 50, bin_iso_1
> Binary Sort Order for the ISO 8859-1 (Latin 1) Character Set
> Anyone knows where I can find out this information?
> Thank you all!
> --
> --
> Sasan Saidi
> MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
> Senior DBA

COBOL program output "text" file for SQL Server to read?

Hello
When a COBOL program outputs a "text" file how can SQL Server read that text
file?winlin,
You can import it a number of ways. Read about BCP or BULK INSERT and its
format files. I am assuming that you will need to give some instruction via
the format file about how to parse the "text" file.
Or you may insert it into a staging table with a format something like:
CREATE TABLE CobolStaging
(LineOfCobolText NVARCHAR(1000))
Further, I am assuming that every line is in the same format, so that it can
be viewed as a row in a table. But if that is not the case, then the
reading in is more complex since it would probably be row order dependent
how to interpret the data. (E.g. header rows and detail rows. In that
case, use a table like:
CREATE TABLE CobolStaging
(LineNum INT IDENTITY(1,1)
LineOfCobolText NVARCHAR(1000))
You will need a format file to teach it to skip over the LineNum column when
importing.
After you have read and experimented with BCP you will probably have some
new questions.
RLF
"winlin" <winlin@.verizon.com> wrote in message
news:40E16360-C774-43A6-B4A9-B1B7B5FC4F2B@.microsoft.com...
> Hello
> When a COBOL program outputs a "text" file how can SQL Server read that
> text
> file?

ClusterDistance value

Can somebody please define the result of the ClusterDistance() function for me. BOL and MSDN are vague about what the output means and I am getting some cases that have a value of zero and sometimes there are more than one per cluster.

Thanks in advance,

Dan Meyers

I believe the clusterdistance() is simply 1-clusterprobability(). Are you saying you are getting more that one "0" value of cluster distance for different clusters on a single case?|||No. I am getting more than one case per cluster that has a ClusterDistance() value of "0".|||That's ok - it's an issue if you get more than one cluster per case with a ClusterDistance() of 0. Imagine if you have two identical cases - it would make sense that they have the same ClusterDistance(), would it not?|||

It does make sense. I just wanted to make sure that I was understanding everything correctly and I was not sure because the documentation is a bit vague in its definition of the function.

Thanks Jamie.