RTI_FIX_USERS function
Summary
Starting with OpenInsight 10.2.2, an application's list of users will be associated with the database ID (DBID) rather than the application ID (APPID). Under most circumstances, the appid and dbid are the same, but in certain cases of inherited applications this change may result in a loss of, or wrong selection of, users being available for logging in to the application.
RTI_FIX_USERS is a utility that can be run in SYSPROG to either change an application's DBID, or change the users associated with an application. It is a "one time" fix per application, if needed.
Description
rslt = RTI_FIX_USERS(method{, appid})
Parameters
The RTI_FIX_USERS function has the following parameters.
| Parameter | Description |
|---|---|
| method | Specifies the action to take. Values are null (returns an @FM delimited list of the available methods), 1 (returns a list of any applications that may have problems), 2 (fixes the application definition), or 3 (fixes the list of users). |
| appid | For methods 2 and 3, this specifies the name of the application on which you wish to operate. |
Returns
For method 1, returns an @FM delimited list of applications that have different dbids from their appids.
For method 2, returns a success message if the dbid has been successfully changed to the name of the application, or an error message.
For method 3, returns a success message if the users previously associated with the appid have been changed to the dbid, or a (possibly @FM delimited) list of errors.
See Also
Example
problem_accounts = RTI_FIX_USERS(1) ;* returns list of accounts that may have issues * Changes the DBID of the specified application to be the APPID (if it was a different DBID previously) * For example, if the DBID of MYAPP was PARENTAPP, after running this command the DBID of MYAPP will be MYAPP rslts = RTI_FIX_USERS(2, "MYAPP") * Changes the users previously associated with the application's APPID to be associated with the DBID instead * For example, if the dbid of OTHERAPP is PARENTAPP, and there are users USER1, USER2, and USER3 defined, * user records OTHERAPP*USER1, OTHERAPP*USER2, and OTHERAPP*USER3 * will be changed to PARENTAPP*USER1, PARENTAPP*USER2, and PARENTAPP*USER3 rslts = RTI_FIX_USERS(3, "OTHERAPP")