To change values in an existing transaction group:
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 the 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 – do not send login information to the transaction processing region.
user – send the HOST_LOGIN and HOST_PWD.
group – 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 value you are changing, enter:
exec sgw_modtrnprp TGROUP1,,,,group
go
The commas serve as placeholders for the unchanged parameters.