To change values in an existing transaction group, use this procedure:
exec sgw_modtrngrp tran_group, GROUP_LOGIN, GROUP_PWD, langrpc, langpwdlevel
where:
tran_group is the name of the transaction group.
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 client calling this procedure. This value must be in uppercase.
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_PWD of the client calling this procedure. This value must be in uppercase.
langrpc is the RPC name used to process SQL language requests. This is the name assigned to all language requests by users who use this transaction group.
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 be one of the following values:
none, which means, do not send login information to the transaction processing region.
user, which means, send the HOST_LOGIN and HOST_PWD.
group, which means, send the GROUP_LOGIN and GROUP_PWD defined here.
If the TGROUP1 transaction group langpwdlevel is currently set to user, this isql example sets it to group:
exec sgw_modtrngrp TGROUP1, JOE, MOE, AMD2, group
go
The GROUP_LOGIN and GROUP_PWD are now set to JOE and MOE, respectively. The language RPC remains AMD2, and the langpwdlevel is now group. If langpwdlevel is the only parameter you are changing the value of, you can enter this procedure as follows:
exec sgw_modtrnprp TGROUP1,,,,group
go
The commas serve as placeholders for the unchanged parameters.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
