Search results

I do consider those two data structures as part of the fragment, as they are not pre-allocated. There is one each per fragment. I was referring to the RM header, the four-byte structure between the block header and the row directory, which is a fixed part of the block overhead.

In the past, I had some very security-conscious customers in the financial services sector who refused to provide root access for anything, including the installation of OpenEdge. They were told it couldn't be done and they fought tooth and nail, insisting we escalate to Progress. I have been...

I've heard there is an AI plug-in for PDSOE, but it's just a wrapper for ChatGPT. It doesn't matter to me as I've given up on PDSOE in favour of VS Code.

For record block overhead, we should also add four bytes for the RM header. This brings up the larger question of rules of thumb. What's the right way to tune X in all cases? In a few lucky cases, we have an answer, e.g. -omsize should be at least the record count of _StorageObject. In most...

These considerations don't matter for existing areas, as RPB cannot change. It only matters when thinking about new areas: added areas, or areas recreated via dump and load. So I don't bother with the "16 or" as no new Type 1 areas should be created. I use 65 in this calculation rather than...

Prior to OE 12.5, the maximum extent size was 2 GB, unless the Large File Support feature was enabled, which made the maximum size 1 TB. This feature was exclusive to the Enterprise RDBMS license. In OE 12.6+, Large File Support is enabled in all databases, regardless of license type. So you...

It would be helpful to know your current OpenEdge release, your database OS platform, and something about your storage hardware. It would also be helpful to know something about your database size, sizes of the largest tables, and your available window of downtime to complete your upgrade and...

Look on the bright side, you aren't supporting 10.1B. ;)

I'm not sure what you mean by this. What is faster than what? Can you provide an example of what you mean?

Once you change all of the var ... statements to define variable ... statements, it will compile in 12.2.

I understand the business need. But it still sounds like you have a lot of audit data in your production database. And that is not a best practice. Virtually all of your audit data, except the most recent data from the current day, should be archived/deleted from production. Your auditors...

Database backup and restore (probkup and prorest) acts on the entire database. You cannot deselect areas or objects. It is possible to create a copy of a database by dump and load of schema, data, and metadata. This gives you granular control of which objects get dumped from the source...

You can't. There is no option for a partial database restore.

Often when people upgrade to 12.8, they focus on what they must do: upgrade the database, recompile source, migrate from WebSpeed/App Server to PASOE, etc. But after they execute that bare minimum set of tasks, they are essentially left with a 12.8 installation that is configured and used as if...

You might want to read this thread about upgrading across a major-version boundary. https://www.progresstalk.com/threads/does-anyone-have-a-demo-of-progress-database-migration.183440/ The question in that thread was about going from 10.x to 11.x, but it is similar in principle to go from...

A mapped drive is just a drive letter assigned (per user, as you said) to a UNC path. Can you not access the files using the UNC path rather than the mapped drive?

Hate to be a nag, but CODE tags are like this: [ code ] // your code goes here [/ code ] Remove the spaces before and after the word "code" in the start and end tags. You can use the Preview button in the top right corner of the post editor to see the effect of the tags before you post your...

For the sake of people you want to read and review your code, please enclose code in [ code ] tags and indent appropriately. E.g.: for each tray no-lock where tf-own = l-cus and tf-type >= l-type1 and tf-type <= l-type2...

Do you mean you are migrating away from using Epicor and OpenEdge, or do you mean that you are moving away from 10.2A to a modern release like 12.8? Do you have a specific issue? Do you need some one-time help? Are you looking for an ongoing support relationship? Can you provide some details...

I misspoke. The second query has a range match on act-date and an equality match on inv-control. The compiler selected the index ACT-DATE-PART-LINE, whose components are act-date, act-time, etc. As the WHERE clause has a range match on the first index component, act-date, it can only bracket...