When a new data dictionary is created via m-Power, we utilize SQL to create a new database schema (sometimes called a data library) and populate it with the necessary tables to make a working data dictionary. If you are using m-Power to connect to an iSeries (AS400) database, most likely…

For customers who utilize m-Power over an AS/400 database, mrc recommends utilizing a JDBC username that is set to have a password that does not expire. However, certain organizations do not permit this option. When a password is nearing its expiration date, the AS/400 is designed to prompt the user…

With the new date/time enhancement in m-Power, dates and timestamps can be displayed in any format needed and every database can be queried much easier.  However, timestamps are defined at the dictionary level.  What happens if you need to only display/search on the date portion of a timestamp in one…

I noticed that a handful of users have been asking through our Hotline that they would like to be able to output to Excel, but also include the Record Selection Summary box at the top of the report. In their cases, it is quite helpful for them to be able…

It is well known that fields that are formatted as true dates can be easily compared and manipulated.  For instance, getting days between two dates is easy with the DAYS() function.  Also, it is easy to add or subtract a certain period of time with SQL.  More on date functions…