CONNECT TO SERVER statement for the metadata utility

The metadata utility uses the information in this statement to connect to a query processor and update the content of a metadata catalog.

The CONNECT TO SERVER statement uses the following syntax:

Read syntax diagramSkip visual syntax diagramCONNECT TO SERVERdatasource-nameconnection-URLUSERIDuser-IDPASSWORDpassword;

Parameters

datasource-name
A 1- to 16-character native identifier that names the query processor (data source) to connect to in the Classic data server identified by connection-URL. datasource-name is used until it is explicitly changed by another CONNECT TO SERVER statement or until the metadata utility terminates.
connection-URL
A native identifier that provides information used to connect to a Classic data server. The URL must be delimited and match the connection information of an active TCP/IP connection handler in the Classic data server.
USERID user-ID
This optional clause specifies the user ID for connecting to the Classic data server. The default value is the TSO user ID associated with the metadata utility job. The user ID is a 1- to 7-character short-native identifier.
PASSWORD password
This clause is required when the Classic data server has the SAF exit active. password provides authentication information when the connection with the Classic data server is established. By default, the connection is established without a password.

If the PASSWORD clause is specified, the password is either a 16-byte or 64-byte hexadecimal string. The hexadecimal string needs to be generated by using the password generator utility on z/OS®.