H
- How do I configure DBU RDB?
DBURDBCFG is the command that will get you to the screen to setup connections. Here is the link to the documentation on it http://www.dodbu.com/documentation/DBUDoc.pdf and ... - How do I use the Shift Column and Shift Text scrollers in DBU?
Your mouse can be used within DBU to activate a drop down Menu from the Menu Bar, Select an option from a drop down Menu ... - How do I remove a previous DBU library off of my system after I have installed the current DBU software?
Check to make sure all of your applications (DBUAPP *ALL) and your users (DBUAUT) have been copied for you from the previous DBU library to ... - How do I key data in lower case?
To set the Upper/Lower Case flag, DBU the file. Hit F4 for field list, then F10. This will show the upper/lower flag and allow you ... - How can DBU be made available for disaster site testing?
ProData provides Disaster Recovery (DR) codes 2 times within a 12 month period at no charge if maintenance is current on your licensed box. Download and ... - How can I use the DBU command without adding the DBU library to my library list?
First use this command: CRTDUPOBJ OBJ(DBU) FROMLIB(DBUxx) OBJTYPE(*CMD) TOLIB(QGPL) Then use this command: CHGCMD CMD(QGPL/DBU) *CURLIB(DBUxx) NOTE: DBUxx – xx refers to the version of DBU eg. ... - How can I determine how much interactive resources DBU will use?
Interactive resource utilization by DBU is difficult to determine. It depends on factors beyond our scope (such as file size, number of logical files, number of ... - How is the access to 'WORLD' or 'ONEWORLD' determined?
The DBU command has a parameter (JDE installation) to indicate how the JDE enhancement is to be used. *NONE – DBU ignores the JDE dictionary and ... - How will DBU/RDB connect to another database?
DBU/RDB connects to the remote system via a standard I/P connection. ... - How do you install DBU/RDB?
Simply install DBU and select the DBU/RDB option. ... - How do we start DBU RDB?
STRSBS SBS(DBURDBSBS). ... - How do I switch to type in lowercase?
The quickest way to achieve this is to type 'low' in the control field. To switch back to uppercase type 'up'. ... - How is the access to 'WORLD' or 'ONEWORLD' determined?
The DBU command has a parameter (JDE installation) to indicate how the JDE enhancement is to be used. *NONE – DBU ignores the JDE dictionary and ... - How do I configure DBU RDB?
DBURDBCFG is the command that will get you to the screen to setup connections. Here is the link to the documentation on it http://www.dodbu.com/documentation/DBUDoc.pdf and ... - How will DBU/RDB connect to another database?
DBU/RDB connects to the remote system via a standard I/P connection. ... - How do you install DBU/RDB?
Simply install DBU and select the DBU/RDB option. ... - How do I secure my DBU Audit journals?
Change the owner of the objects in library DBUAUD to QSECOFR or a level high enough to prevent unauthorized users from accessing them and *EXCLUDE ... - How is this different than IBM’s journaling function?
DBU Audit journals only those modifications made via DBU. IBM journals everything, which can cause information overload, making it difficult to isolate specific records you ... - How does DBU Audit help IT departments?
DBU Auditing is a great product for all companies. All IT departments manage, modify and display information in databases. Regulatory compliance and internal controls go ... - How can I get a trial of your products?
To receive a trial of our products or to update to the current version you can: 1. Visit our product download page at http://www.DoDBU.com/download.shtml to download ... - How can I obtain an Emergency Access Code for your products?
Fill out our online form at http://www.DoDBU.com/emergency.shtml and we will email you a temporary code. We will then contact you within 2 business days to ... - How do you load DBUnifier from the cd-rom?
Place the cd-rom in AS/400 Drive & execute the command LODRUN *opt. ... - How do you execute DBUnifier?
ADDLIBLE dbunifier Execute the command ‘WRKDBUAPP’ The interface is similar to WRKQRY on the iSeries and walks you thru the file, field and window size selections for ... - How do you integrate DBUnifier application into your existing systems?
There are sample applications that show you how to integrate DBUnifier applications into your existing system. These examples can be found in the source file ... - How do you only process a subset of data from a DB2/400 file?
By using the QRYSLT parameter, when launching a DBUnifier Application, you can limit the data in a DB2/400 file that is processed. The QRYSLT parameter ... - How can I get the latest release/version of DBU?
If you already have a license of DBU (current version) on your system, you can use the DBUPTF command. DBUPTF is only available to update to ... - How do I install the green screen version from the downloaded file?
Executing the downloaded file automatically installs the green-screen version. ... - How do I install the green-screen version to multiple IBM i/iSeries/AS400 machines?
Run the installation program once for each machine. Enter the IP address for the target IBM i/iSeries/AS400 machine. ... - How can we update our DBU software?
To update DBU, you can do one of three things: download the latest version from our download page use the command DBUPTF (DBU 7.0 and later) to ... - How can I get the latest product upgrade?
Download from our web site Email our sales department & we will email it to you. Call us at 1-800-228-6318 and we will mail it to you. ... - How do I obtain the Serial Number or Model Number of our system?
Serial number: at the command line enter DSPSYSVAL (cmd 4) value = QSRLNBR. Model number: at the command line enter DSPSYSVAL (cmd 4) value = QMODEL. ... - How do I check what version of RDB Connect I have loaded?
On a command line type in RDBSEC. This will show the version and release date of RDB Connect you are running. ... - How do I install SQL from the downloaded file?
Locate the executable, and double click to begin installing SQL. ... - How do I start SQL once it has been installed?
Make sure that you have added the library SQLPRO to your library list. To start SQL/PRO, enter STRPDSQL at the command line. ... - How many characters can a query contain?
SQL/Pro now supports developing queries up to 32,750 characters in length. ... - How do I select the output device?
You have the ability to select an output device of either display, printer or database file. This is performed by selecting option 1 from the ... - How can I view my previously executed SQL statements?
You can review the history by selecting option 5 of the Services Menu (F13). This will give you a summary listing of SQL/PRO statements, ... - How do I save a query?
You can create a Saved Query from any SQL statement you have on the SQL/PRO Statement Entry screen. Go to the Services menu (F13) and ... - How do I run a saved query?
You can run a saved query either in batch or interactively. Option 9 runs it interactively and 8 runs it in batch. You can also ... - How do I delete a query?
You can delete a Saved Query with option 4 from the service menu (F13). You will be presented with a screen to confirm the deletion. ... - How do I print a saved query?
You can print a Saved Query with option 6 from the service menu (F13). ... - How do I move my saved queries to another AS/400?
Save the physical files SQL4LSQ and SQL4LHQ from the SQL/PRO product library (i.e. PDSQL30) and restore them into the product library on the new box. ... - How do I download SQL Audit?
Visit our downloads page. There are two options to download SQL Audit. A. If you are a current SQL/Pro customer, download the latest version of ... - How do I execute SQL Audit?
If your system journaling is on, the command SQLAUDMN displays the SQL Audit menu and the documentation will step you thru the product. If you need ... - How is SQL Auditing accomplished?
SQL Audit either uses the system journals(if journaling is implemented on your system) or thru commands where SQL Audit stores the data in journals which ... - How does SQL Audit help IT Departments?
SQL Auditing is a great product for all companies. All IT departments manage, modify and display information in databases. Regulatory compliance and internal controls go ... - How is this different than IBM's Journaling function?
When using the commands provided, SQL Audit journals only those modifications made via SQL/Pro or IBM’s SQL/400. IBM journals everything, which can cause information overload, ...
