MX 3.x)

Starting, Configuring, and Managing MXCS

HP NonStop SQL/MX Connectivity Service Manual—640327-001

3-7

Starting MXCS Data Sources

Reconfiguring Character Sets

The default character set is determined at SQL/MX installation. ODBC applications

may reconfigure the character set for a data source by prefixing character literals in an

SQL statement. The text to be inserted into a Unicode column is prefixed with _UCS2

or N, with no spaces between the prefix and the character literal. For example:

N’Unicode_text’

_UCS2’Unicode_text’

N is used if the target column is defined as NCHAR and the default character set is

UCS2.

Starting MXCS Data Sources

Data sources configured with the automatic startup option are started when the MXCS

service is started. However, data sources configured with the manual startup option

must be started by using NSM/web and MACL. You must use a user ID with

OPERATOR permission to start a data source.

1. Using NSM/web, expand MXCS Services and click a service name.

2. Click the Data Source Status tab.

3. Select the data source to be started.

4. Click Start.

MXCS starts the data source and its associated MXCS servers.

The MXCS association server must be started before you can start a data source. To

determine if the association server is started, in the MXCS Services list, click the

service name and check the Status tab to see if the state of the association server is

STARTED.

To use MACL, see the SQL/MX Connectivity Service Administrative Command

Reference manual.

Stopping MXCS Data Sources

You must use a user ID that has OPERATOR permission to perform management

tasks.

1. Using NSM/web, click MXCS Services. A list of services displays in the left pane.

2. Click a service name.

3. Click the Data Source Status tab. The list of data sources appears in the right

pane.