Jan 15, 2013 · I'm struggeling with an if statement towards an OpenEdge database via ODBC. The query I have works like a charm, but Progress wants me to define the if statement …

Jun 22, 2018 · I have a linked server set up between sql 2008 and a Progress OpenEdge 10.1b server. How do I get the table schemas?

Jan 24, 2024 · Our primary database is an OpenEdge one, and we have a SQL database which we have to sync up with our OE one. We came up with a plan to set up staging tables for our …

Jul 13, 2020 · I'm using DBeaver to connect to Open-Edge 11 database which supports SQL functions. The functions used HERE don't work. Here is a single example and the result: …

SELECT distinct Table.column, { fn CONVERT(SUBSTRING(Table.ProblematicColumn, 1, 60), SQL_VARCHAR)} as test FROM PUB.Table WHERE ( Table.id IN ( SELECT Table.id FROM …

The following works with the sports2000 database and using sqlexp (rather than embedded sql at the procedure editor): select * from pub.order where orderdate < '1/1/1999' I also added a …

7 How can I get a limited number of records from the table in Progress OpenEdge database? Something like in SQL: SELECT TOP 100 * FROM MyTable The only ugly solution I can find …

Nov 13, 2009 · sql sql-like case-statement openedge progress-db edited Feb 3, 2012 at 13:17 Tom Bascom 14.1k 2 32 37

Aug 17, 2012 · The dbtool option is the best. It is designed for this. From proenv you should see something like this: proenv> dbtool s2k DATABASE TOOLS MENU - 10.2B ------------------------- …

May 30, 2018 · The Progress unknown value ? is what SQL calls NULL. Date fields can only contain valid dates or (if the field is not mandatory) the unknown value ?. Unlike other data …