W
- WRKLICINF shows all of the versions we've installed over the years. Can I remove the old V7R0, V8R0 and V9R0 lines from the system or do they need to stay there?
Once you remove/delete the old DBU libraries, the WRKLICINF listings will be removed by the system. ... - We are having an issue with going from single to multi record view with F21. It seems to be deactivated. Is there a setup that controls single/multi viewing of records?
We have had reports of losing the functonality of the F21 key on the PC due to the installation of other software on the PC. ... - We are migrating from JDE World to E1. How do we enable the EnterpriseOne plug-in on DBU 10?
You can prompt the DBU command and the last parameter for PeopleSoft installation can be changed to WORLD or ONEWORLD. You can also use the command ... - What is a DBU application?
An application is a method of saving the DBU screens, files & fields the way a user has designed them. After bringing up a file, selecting ... - Why doesn't my search in DBU work?
QTEMP needs to be in your library list and the object QSYS/QPRCRTPG needs to be changed to have *Public and *Use authority. ... - When running the F15 Search function, is there any way to display ALL the results from that search?
If you specify *YES to the parameter ‘Output Results to File’ on the Search Screen (F15), all the records matching the search criteria will be ... - Will DBU work with flat files or System/36 files?
Yes, DDS is not required. The data will be presented in raw form. But you have various options: You can create an application over flat files ... - What is the maximum record length DBU can handle?
DBU has a maximum record length of 9,999. ... - When using the JDE enhanced version of DBU is it possible to switch to the non-JDE version to view my raw data?
Yes, if you would like to view your data without the JDE enhancements just turn the JDE enhancement off by performing the following: From a command ... - What databases can DBU/RDB access?
DB2 UDB 8.1 or greater, SQL Server, Oracle and MySQL. If you require a different database, send a request to our helpdesk at help@prodatacomputer.com. ... - Will DBU/RDB access DB2 on another IBM i?
DBU/RDB can not access another IBM i, only DB2 on a non-IBM i platform. ... - What are the system requirements in order to use DBU/RDB?
Requires i5/OS or OS/400 V5R4 or greater. DBU 7.0 or higher There must also be an I/P connection to the remote server. ... - Will a user profile with any special authority be needed to install and configure DBU/RDB?
To install DBU/RDB you must have at least *IOSYSCFG authority. ... - Will DBU/RDB software allow users to change or view objects they don't normally have authority to?
No. DBU/RDB cannot circumvent database authorities. ... - We are migrating from JDE World to E1. How do we enable the EnterpriseOne plug-in on DBU 10?
You can prompt the DBU command and the last parameter for PeopleSoft installation can be changed to WORLD or ONEWORLD. You can also use the command ... - When using the JDE enhanced version of DBU is it possible to switch to the non-JDE version to view my raw data?
Yes, if you would like to view your data without the JDE enhancements just turn the JDE enhancement off by performing the following: From a command ... - What databases can DBU/RDB access?
DB2 UDB 8.1 or greater, SQL Server, Oracle and MySQL. If you require a different database, send a request to our helpdesk at help@prodatacomputer.com. ... - Will DBU/RDB access DB2 on another IBM i?
DBU/RDB can not access another IBM i, only DB2 on a non-IBM i platform. ... - Will a user profile with any special authority be needed to install and configure DBU/RDB?
To install DBU/RDB you must have at least *IOSYSCFG authority. ... - Will DBU/RDB software allow users to change or view objects they don't normally have authority to?
No. DBU/RDB cannot circumvent database authorities. ... - What if I need a more comprehensive audit solution?
Just let us know! we work with many business partners that we can refer you to. Combining our tool and utilizing theirs may just be ... - Why is DBU Auditing important?
Regulatory compliance and internal controls have really become an issue for all companies. This was due to legislation passed (Sarbanes-Oxley, HIPPA, etc) after the Enron ... - Why is this better than earlier DBU audit tracking?
DBU Audit Plug-in goes beyond the base DBU audit tracking by storing the data in journals rather than spooled files. This simplifies the ability to ... - What is the DBU Audit Plug-in?
DBU Audit Plug-in is software that allows DBU users to track and monitor DBU changes or displays on any IBM i file. DBU Audit offers ... - What is an ISO image?
An ISO image (or .ISO file) is a computer file that is an exact copy of an existing file system. The ISO Image file contains ... - What are your disaster recovery procedures?
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 ... - What if my maintenance is not current?
Call 1-800-228-6318 and you will be re-invoiced for maintenance. You can pay online through our Pay Now page at http://dodbu.com/paynow.shtml, over the telephone with a ... - What does maintenance cover?
Annual maintenance covers all new releases, operating system changes, fixes, DBUPTF support, client portal access and the technical help line. ... - Will your products work with an IBM i/OS version upgrade?
All currently supported versions of our software are compatible with all IBM i OS and OS/400 above version V5R4. ProData is part of IBM’s Partners ... - What is the difference between the 'Conversion type' *ADVANCED and *BASIC when using CVTRPG?
The *BASIC option will just reformat the RPG source code to RPGIV source code format, it will make no other changes to your code. ... - What is DBUnifier?
A programmer’s utility which allows developers to dynamically create list programs one time and call them from any number of programs. F4 List programs create ... - What are the iSeries systems requirements to utilize DBUnifier?
OS/400 V4R2 & above. ... - Where is the source code for a DBUnifier application?
There is no source code produced when building a DBUnifier application. You can think of DBUnifier application like you would a Query Definition. The applications ... - Where do I go to see the PDF that was created. SPLF2PDF FILE(DNFTP01) JOB(694488/I259747/ACMSCREATE) SPLNBR(*LAST) TITLE('Example PDF Document') TODOC('/example.pdf')
The .pdf will be on the IFS in the directory ‘/’ and called example.pdf. You can access the IFS by using the command WRKLNK. You ... - We upgraded our system OS. The system serial number did not change and we did not change our LPAR configuration. How do we make DBU software functions correctly?
You will need to execute the command DBUSEC with the DBU software library in your library list, verify that your access codes are displayed and then ... - What are the IBM i/iSeries/AS400 systems requirements to utilize DBU?
DBU operates on IBM i systems at OS V5R4 or above. ... - When I update DBU, do I need to delete the existing DBU library?
No. DBU objects will be replaced without losing previous DBU settings (security settings, DBU apps, etc.). Note: Be sure no one is currently using DBU when updating. Before ... - What version and release date of DBU do I have?
Execute the command DBUSEC or Display the data area (command DSPDTAARA DBUREL) and the version and the release date will be displayed. If you are using DBU ... - When using the RDBIMPORT command, what is the maximum field size for the STM keyword?
Using RDBIMPORT command, the maximum field size is for the STM keyword is 5000. ... - What can we do if we have problems connecting to the Remote Database?
You can contact our Technical Support team using email at help@prodatacomputer.com or contact us by phone using 1.800.228.6318 and option 2 for Technical Support. ... - What are the terminology differences when working with SQL vs. the IBM i environment?
Here are some of the terms used in each environment: SQL IBM i database system schema library, journal, view table physical file view logical file index keyed logical file row record column field log journal ... - What are the IBM i systems requirements to utilize SQLPRO?
SQL/PRO operates on IBM i systems at OS V5R4 or above. ... - Will SQL/Pro run in batch, or how do I select the execution environment?
You are able to run your SQL statement either interactively or in batch, depending upon how you have set it. To set the execution environment, ... - What is SQL Audit?
SQL Audit is software that allows users of SQL/Pro or IBM’s SQL/400 to journal and monitor SQL changes on any IBM i file. If changes ... - Why is SQL Auditing important?
We basically created this tool for a programmer to be confident with executing SQL. The resulting data reported thru SQL Audit Menu helps them to ... - What transfer protocol is utilized when executing DBUPTF?
TCP socket connection is utilized and a fully encryted packet of the DBU update is transferred with DBUPTF. ... - What files are eligible for retrieving deleted records?
All files except for the following: A file that has been reorganized since the records were deleted. A file that was created with “Reuse Deleted Records = ... - What is the RDR trial time?
RDR trial will continually retrieve only the first 25 records and place those records in a secondary file for you to evaluate. A permanent access ... - Where can I find documentation for RDB Connect software?
Documentation is available from our website under the Support tab or at the following link http://www.dodbu.com/documentation/RDB_Connect.pdf. ... - What are the requirements to configure an RDB Connect connection?
Each database may have particular requirements that will need to be discussed with the Remote Database Administrator, we would recommend that you review the documentation ...
