Progress OpenEdge – Using UNION

progress-database

I am attempting to union together 2 queries in progress DB
Unfortunately, this is returning me a syntax error.
Are union queries unsupported in progress DB?

     SELECT 0, 'All'
     UNION ALL
     SELECT custcode, custname
     FROM pub.pv_customer

Best Answer

That may depend on what version of OpenEdge you are querying. Reasonably modern releases do support UNION:

https://www.progress.com/docs/default-source/openedge/progress-openedge-sql-compliance-to-core-sql-2011.pdf?sfvrsn=0

(this applies to OpenEdge 11.5 and above)

Related Solutions

Select statement is locking a record

If dirty reads is not an issue in this scenario, you could try the table hint readuncommitted or nolock..

pub.name n WITH(NOLOCK)

join pub.[family-guardian] fg WITH(NOLOCK)

Reasons for incremental backup on Progress OpenEdge

Time for the backup to run is a reason for doing incremental backup on Progress. My backup is running fast enough that I did not need to use this function and I'm still doing only full backups.

It also depends on your requirements. For example, if you have heavy financial transactions and you want to keep a backup every hour or something like that, you would need to do incremental (or real time).

But unless you have something forcing you to do incremental, I would do full backup, I find that easier to restore.

In terms of performance impact, if you have a fast disk array, I haven't seen much impact of doing a backup even during moderately heavy usage. Obviously it depends also on the size of your system. I'm talking about a 37Gb DB.

Best Answer

Related Solutions

Select statement is locking a record

Reasons for incremental backup on Progress OpenEdge

Related Question