hello all
i'm trying to do a bit of house cleaning on powerplay, hopefully getting rid of cubes on upfront that people no longer use and any users who have not signed in recently.
i'm sure theres a way to look at which users have been signing in using access manager in the security settings in...
I work for a housing association and I have report that takes a snapshot of all our properties and their status e.g. tenanted, empty with construction etc. The problem is I want to look at our performance over time and the table in our iSeries does not store this data time-wise, just what status...
I'm running an impromptu report which pulls information from different tables on our iSeries. everything's ok and the queries run really fast until i start to do anything with dates.
our system stores dates as numbers eg 20050908 and to find out if an order is overdue i have been using number...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.