To define a new transaction group, use this procedure (replace the italicized parameters as shown):
exec sgw_addtrngrp tran_group, GROUP_LOGIN GROUP_PWD, langrpc, langpwdlevel
where:
tran_group is the name of the transaction group. Length: maximum of eight characters.
GROUP_LOGIN is the alternate transaction processing region login that member transactions can use. When langpwdlevel is set to group, the GROUP_LOGIN overrides the HOST_LOGIN of the user calling this procedure. This value must be in uppercase. Null is valid. Length: maximum of eight characters.
GROUP_PWD is the alternate transaction processing region password that member transactions can use. When langpwdlevel is set to group, this password overrides the HOST_LOGIN of the user calling this procedure. This value must be in uppercase. Null is valid for TRS LU62 only. Length: maximum of eight characters.
langrpc is the RPC name used to process SQL language requests. This is the name assigned to all language requests by users of this transaction group. Null is valid. Length: maximum of thirty characters.
langpwdlevel is the source of the transaction processing region login information for language RPCs. It indicates whether transaction processing region login ID and password should be passed to the transaction processing region with this transaction request, and if so, whether the user’s HOST_LOGIN or the transaction group’s GROUP_LOGIN information should be used. This parameter can have one of the following values:
none – do not send login information to the transaction processing region.
user – send the user’s HOST_LOGIN and HOST_PWD.
group – send the GROUP_LOGIN and GROUP_PWD defined here.
This example creates the transaction group named TGROUP1:
exec sgw_addtrngrp TGROUP1,,,AMD2,user
go
This example gives the TGROUP1 transaction group the following characteristics:
It does not use group logins or passwords.
It uses the AMD2 language RPC.
It forwards the HOST_LOGIN and HOST_PWD information of the users assigned to this group (in the sgw_addlog procedure) to the transaction processing region.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
