Progress
Language Reference


DBCOLLATION Function

Interfaces
OS
SpeedScript
All
All
Yes

Returns, as a character string, the name of the collating sequence for character set information contained in the database. This name corresponds to the definition of the collating sequence contained in the convmap.dat file, which usually resides in the $DLC directory. If any parameter is invalid, DBCOLLATION returns the unknown value (?).

SYNTAX

DBCOLLATION
  ( { integer-expression | logical-name | alias } ) 

integer-expression

The sequence number of a database the Progress session is connected to. For example, DBCOLLATION(1) returns information on the first database the Progress session is connected to, DBCOLLATION(2) returns information on the second database the Progress session is connected to, etc. If you specify a sequence number that does not correspond to a database the Progress session is connected to, the DBCOLLATION function returns the unknown value (?).

logical-name or alias

A character expression that specifies the database by its logical name or alias.

EXAMPLE

This procedure displays the logical name and collation of all connected databases.

r-dbcoll.p
DEFINE VARIABLE i AS INTEGER.
REPEAT i=1 TO NUM-DBS:
  DISPLAY LDBNAME(i) DBCOLLATION(i) FORMAT "x(19)".
END. 

NOTES

SEE ALSO

ALIAS Function, CONNECT Statement, CONNECTED Function, CREATE ALIAS Statement, CREATE DATABASE Statement, DATASERVERS Function, DBCODEPAGE Function, DBRESTRICTIONS Function, DBVERSION Function, DELETE ALIAS Statement, DISCONNECT Statement, FRAME-DB Function, LDBNAME Function, NUM-DBS Function, PDBNAME Function, SDBNAME Function


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095