Author: (Dirk Kolbe)

There is not Sample for CLEANUPSTATE into Uniface Help! How it works? Can i delete any entrys for a session at once? Tanks


  1. Hello Dirk, if you hold a supported license, I would suggest you contact your local account manager for this the first place. Think he will be more than happy to assist you on that missing information. PLUS: At the bottom of the help-page "USYSSTAT" there is a hyperlink "Send feedback about this topic to Compuware". just ask for a list of operations with a commented documentation of the parameters. Please use it, in the past I found them very open to correct errors and other deficits just with the next uniface patch, so all the uniface customers will benefit from this improved documentation in the future. OK, all this will take some time before you get an answer. For immediate help, please find here what I have done for you: *** The search for CLEANUPSTATE only listed USYSSTAT where one gets not so much more but the name. On my quest, I followed hyperlinks from USYSSTAT and found "Using Default Temporary Tables to Maintain State" includes some code using the getState and setState. Searching for "deletestate" you may find the "Session fixation" help page with an example using the deleteState. My speculation for the "missing link" after spending some 15 minutes to answer your post because of the "bulk" nature in the narrative: ************************************************************ activate "USYSSTAT".cleanupState(vOldSessionId) ************************************************************ P.S. Beside the search feature of the ulibrary.chm i used some home-brewed ways to scan CHM, but my S.W.A.T. tools could not drain more info them the CHM content, so I assume there is no more info to be found.

    Author: ulrich-merkel (
  2. The default code in the Get State trigger of USPs and DSPs contains the following information on CLEANUPSTATE in comments. In other words, the date rather than the session ID is required as parameter. ; When using the State Manager Component: ; activate "USYSSTAT".CLEANUPSTATE(TimeStamp) ; operation CLEANUPSTATE ; params ; datetime TimeStamp : IN ; endparams ; When TimeStamp = '0' or 'empty' all occurrences will be removed. ; When you specify a particular 'datetime' all occurrences before 'datetime' will ; be removed. ; =======================================================================================

    Author: Barbara Douma (