ATTACH

Description

Establishes a logical connection from Open ClientConnect to Mainframe Client Connect and, ultimately, to a target DBMS using the SNA or TCP/IP link.

Syntax

Syntax varies with the programming language.

Parameters

The ATTACH command uses values from these SPAREA fields:

• SPSERVER (see “SPSERVER”) specifies the name of an entry in the Open ClientConnect router/server table.

• SPUSERID (see “SPUSERID”) specifies the user ID required to access the target database.

• SPPWD (see “SPPWD”) specifies the password required to access the target database.

• SPATTACH (see “SPATTACH”) specifies Attachment file name, for backward compatibility to MDI.

Examples

COBOL II

MOVE 'SPDB2N1' TO SPSERVER.
 MOVE 'JWILS32' TO SPUSERID.
 MOVE '3LTB2AP' TO SPPWD.
 CALL 'ATTACH' USING SPAREA.

Usage

During the attach process, Open ClientConnect establishes an APPC conversation with Mainframe Client Connect, which in turn, establishes a conversation with the target DBMS, using a LAN protocol.

Before it calls the ATTACH command, the CSA must:

• Provide a router/server name

• Move the user ID and password to the SPAREA

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF