{"id":23,"date":"2014-04-25T15:37:56","date_gmt":"2014-04-25T15:37:56","guid":{"rendered":"http:\/\/127.0.0.60\/?p=23"},"modified":"2016-07-20T15:48:49","modified_gmt":"2016-07-20T15:48:49","slug":"the-hidden-jewels-of-dbu","status":"publish","type":"post","link":"https:\/\/i.dodbu.com\/index.php\/2014\/04\/25\/the-hidden-jewels-of-dbu\/","title":{"rendered":"The Hidden Jewels of DBU"},"content":{"rendered":"

\"diamond\"Another Easter holiday came and went, leaving behind great memories and pictures of family, friends and festivities. Of all of the day\u2019s activities, the most fun, of course, has always been the Easter Egg Hunt. When my girls were just little things, I\u2019d dress them all up and get them fired up for the neighborhood event. They\u2019d rush around the yard with all of the other kids, grabbing the eggs that were in full view. Meanwhile, if they would\u2019ve glanced down under the bush just in front of them, they could\u2019ve seen a bunch of hidden eggs nestled right under their feet. Of course, they only saw these gems after all the searching had come to a halt and only then, when I had pointed them out directly!<\/p>\n

It seems this also happens with some of the many features of DBU! Our customers jump right in and see the most obvious features offered by our database utility: edit the record, display logical files, position to this RRN, search for a specific value, display multiple records all at once, etc. Rush in and out, get the job done with DBU and go on your merry way. Yes, that is one of the brightest beauties of DBU. But what about some of the \u2018hidden jewels\u2019 offered within the database utility? Seriously, they are sitting right there at your fingertips, waiting to be utilized. Here goes a list of just a few of these gems:<\/p>\n

Access ANY record on your network.
\n\u201cWhat? You can access files on systems other than IBM i?\u201d, you ask in amazement. You bet! With DBU 10.0, remote access was added as part of the basic functionality of DBU. When DBU is installed, remote
\nsystems can be configured and managed for access. You can then \u2018DBU\u2019 the files that the \u201cUnix guys\u201d are working with as it resides on the OTHER box sitting in the corner. Soon, both the AS\/400 and Unix developers will be singing \u201ckumbaya\u201d in unison. (Listen close, as that doesn\u2019t happen very often!)<\/p>\n

Reactivate deleted records and be the hero of your department.
\nOftentimes, a record is deleted in error\u2026..or even multiple records. Did you know you can DBU the file and display deleted records, then reactivate them? There is even a flag to \u2018include deleted records\u2019 in
\nsearch criteria. Records can individually be reactivated using DBU. And if you have large amounts of records to reactivate, we also have another utility in our toolset to reactivate records en masse. it\u2019s called RDR \u2013 Reactivate Delete Records, pretty intuitive!<\/p>\n

Learn SQL while you use DBU!
\nDBU offers powerful search options for your files. It allows filtering and scanning records based on the SQL \u2018where\u2019 clause in addition to the more familiar DBU \u2018Define Search\u2019 function. Newbies to SQL can define the search then toggle to view how the same function is performed via an SQL statement.<\/p>\n

Another helpful feature for SQL developers is the ability to display a table or files associated \u201calias\u201d names (ie. long names) by pressing F18=Col Head\/Alias key on the DBU Field Selection selection screen. This capability is also available from the DBUFLD command.<\/p>\n

Create graphical database applications.
\nSometimes the IBM i is thought of as only a \u2018green screen\u2019 box. Not anymore! If you want to impress other departments with a quick and easy new interface, why not create a little DBU database application to be presented in graphical format? Now you can! Just utilitze DBU to create the app with the traditional \u2018green screen\u2019 interface, install DBU GUI on the users PC, pull up the DBU app via DBU GUI and save it as an icon for the user to access over & over again!<\/p>\n

These are just a few of the hidden gems waiting for you, if you\u2019d only delve a bit deeper into DBU. The more you work with DBU, the more you will get out of it. And there\u2019s even more features! I didn\u2019t even hit on more SQL options, monitoring and auditing features. Bright, beautiful gems just waiting to be uncovered by you!<\/p>\n","protected":false},"excerpt":{"rendered":"

Another Easter holiday came and went, leaving behind great memories and pictures of family, friends and festivities. Of all of the day\u2019s activities, the most fun, of course, has always […]<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"Layout":"","footnotes":""},"categories":[2],"tags":[],"class_list":["entry","author-shelli","post-23","post","type-post","status-publish","format-standard","category-blog"],"_links":{"self":[{"href":"https:\/\/i.dodbu.com\/index.php\/wp-json\/wp\/v2\/posts\/23","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i.dodbu.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i.dodbu.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i.dodbu.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/i.dodbu.com\/index.php\/wp-json\/wp\/v2\/comments?post=23"}],"version-history":[{"count":3,"href":"https:\/\/i.dodbu.com\/index.php\/wp-json\/wp\/v2\/posts\/23\/revisions"}],"predecessor-version":[{"id":27,"href":"https:\/\/i.dodbu.com\/index.php\/wp-json\/wp\/v2\/posts\/23\/revisions\/27"}],"wp:attachment":[{"href":"https:\/\/i.dodbu.com\/index.php\/wp-json\/wp\/v2\/media?parent=23"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i.dodbu.com\/index.php\/wp-json\/wp\/v2\/categories?post=23"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i.dodbu.com\/index.php\/wp-json\/wp\/v2\/tags?post=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}