database

Hello, so a customer of ours, has QAD 2013 Standard Edition. Their system is gradually slowing down, and because of that, i did some investigation. So i found out that the rule of thumb is -B parameter should be 10-15% of database size. Customer's database is 230GB now, and their buffer size was...

Hello All, I want to implement a good database policy and integrity while making any database changes in our application. For this, I am looking for a template that must capture all the important information/steps for any DB changes requested by my fellow teammates. Can somebody point any...

I created database and some apps for it (windows apps) - when I load my database trought AppBuilder everything is working just fine, my apps are working and everything else, but that's not what's bothering me. Is there any possibile way to start my database over shortcut or .bat file or...

Hi everyone, I am facing a problem that has left me a little stumped. Any help or insight will be very helpful. A table called Staples in TestV1 schema was loaded in Oracle, MSSQL and Openedge. There is a customer bug stating that a SQL query to extract a table's data in Openedge 11.1 is...

**Below is my samplecode to read data from xml file and write to temp-table "tttemp" and display a child "mainsub" and its sub-child nodes.** DEFINE VARIABLE hDoc AS HANDLE NO-UNDO. DEFINE VARIABLE hroot AS HANDLE NO-UNDO. DEFINE VARIABLE hmainsub AS HANDLE...

when i was run proutil command for idxbuild , i get an error . proenv>proutil master -C idxbuild all OpenEdge Release 11.6.4 as of Mon Oct 23 11:21:54 EDT 2017 Use "-cpinternal UTF-8" with idxbuild only with a UTF-8 database. (8557) Index rebuild did not complete successfully i wrote Article...

Does anyone know if it is possible to get the duration that a record have been locked for via a program? I know it is possible to get a transaction duration using virtual system table _trans. But this does not help me because share-locks don't generate a transaction. Our software supplier...

Hi, I am looking for a method to implements transaction management (as in the DO TRANSACTION block keyword) in many programs. I need to do this because there some table lock wait issue on some programs. I have already found some technics to implements the locking, for example this kind of code...

I have a client in Houston that has an immediate need for someone with experience supporting Infor SX Enterprise and Progress databases. Any coding/customization experience is a plus but at this point I want to talk to anyone interested in a fulltime job focused on SX.e with a great company...

Hi, I would like to know if there is a way to log automatically database record creation (the way as we already have for some -clientlog -logentrytypes startup parameters). I know it is possible with Temp-table (Progress KB - Is there a LOG-ENTRY-TYPE to log TEMP-TABLE statistics?) but for...

Hi, recently we change our databases to a new server but the startup and the queries are extremely slow, even tho the hardware is better than before. We lack knowledge about databases, we manage our clients services and remote connection as well as other services but we do not know about...

I 'm looking for people with experience of data protector Data Protector is a plugin to write Progress backup directly to TSM . All I can find is the supplier documentation

we have issue data inconsistency when using buffer-copy from phisics table to temp-table via AppServer. The record that retrieved from appserver sometimes missing value. Example: we have 1 table named "transsales" consist of 4 fields : transno confirmby confirmdate confirmtime. if we display...