Copyright: COPYRIGHT FUJITSU LIMITED. 1992-1996


Selection of [file name].
Specification of [file name].

The file name by which information is set is specified.The file of the current can be selected by clicking the [reference]button.If the specified file does not exist,the file is newly made.


Selection of [server information].

Setting of [server information].

Necessary information for server of the object to which connection is established by the CONNECT sentence in the COBOL source program is set in the [server information]group box.


[Server name](Indispensable,specified item.)

The name of server which establishes connection by the CONNECT sentence is specified.Please specify the server name specified in the following place.

•	Server name specified for CONNECT sentence.(When connection is established by CONNECT sentence of server name specification.)

•	Server name specified for default connection information on ODBC information file.(When connection is established by CONNECT sentence of DEFAULT specification.)

When the server name has already been defined in the ODBC information file,it is possible to select from the list of the server name.(When information file is made with ODBC informational set tool.)

Attention.

The server name specified for here is a name to deal with the CONNECT sentence and the data source uniquely.Please note no name of the machine where an actual data base exists.


[Data source name](Indispensable,specified item.)

The name of the data source accessed by the specified server name is specified.When the data source has already been defined,it is possible to select from the list in the data source.(The data source has defined with the ODBC control panel.)

The data source can be defined by using the [ODBC]control panel of the control panel in the Windows system.


[Comment](Item to witch specification can be omitted.)

The comment on the specified server name is described.


[Access mode]

The access mode of the data source is specified.

Only reading.

It is specified to access only for reading.

Reading / Writing.

It is specified that reading and writing access possible.

If the access mode is not specified,treats only as reading.(When ODBC information file is updated.)Moreover,treats for new server only as reading.


[COMMIT mode]

The COMMIT mode of the data source is specified.(Movement of transaction.)

Manual.

The operation of SQL is fixed by describing the COMMIT sentence or ROLLBACK sentence in the COBOL source program.

Auto.

The operation of each SQL sentence is fixed without any relation to the description of the COBOL source program.

Attention.

When the auto is specified,the data base cannot be returned to the state of the former by the ROLLBACK sentence because the processing is reflected in the data base when the SQL sentence was executed.Therefore,the specification of the manual is recommended and does.However,movement to specification might be different because of the ODBC driver who processes the data source.


Setting of [default connection information].

Information necessary to establish connection to the [default connection information]group box when DEFAULT was described in the CONNECT sentence in the COBOL source program is set.


[Server name]

The server name of the object by which default connection is established is specified.In the system,server information is retrieved based on this server name and connection will be established to the data source name defined by server information at the COBOL run time.

Attention.

The server name specified here must specify the one which has already been defined as server information.


[User ID]

User ID to operate the data source defined in server information on the specified server name is specified.


[Password]

The password of user ID who operates the data source defined in server information on the specified server name is specified.

Attention.

The password will be displayed by asterisk (*)for security when inputs.Please note input enough.

Supplementation.

The password encodes for security and is stored in the information file.


SQL ODBC

ODBC informational set tool.

Outline of function.

ODBC informational set tool makes or updates the content of the ODBC information file.

Information for which the system is chiefly necessary to establish connection between client and server is set at the COBOL run time and the content is classified into the ODBC information file as follows.

•	Server information.

•	default connection information.

Moreover,the operation method of each item on this tool and the explanation concerning the content of input are described below.

Operation explanation.


Setting of information.

The method of setting information in ODBC informational set tool is explained.

Server informational set part explanation.

Default connection informational set part explanation.


Informational individual set part explanation.

Server informational set part explanation.

A set part of server information is explained.

Setting of [server information].

[Server name](Indispensable,specified item.)

[Data source name](Indispensable,specified item.)

[Comment](Item to witch specification can be omitted.)

[Access mode]

[COMMIT mode]


Default connection informational set part explanation.

A set part of Default connection information is explained.

Setting of [default connection information].

[Server name]

[User ID]

[Password]


Operation explanation.

The method of operating each function is explained.

Setting of file name.

Setting of information.