Hi all, I'm looking for some help with writing batch file to call an SQL Query on Linux Red Hat with Progress 10.1 OE. I've struggled to find anything on the forum, but like so many questions, there could be all sorts of keywords, so I hope I'm not duplicating anything.
Basically, we currently run SX.enterprise (I think it used to be Trend, but I'm sure this is a wider question) version 5.6.063, which (I believe) runs on Progress 9.1c or 9.1e. We use Version One DBForms to convert the spool files to readable documents. We are about to install version 5.7.060 (Which runs on Open Edge 10.1) in a test environment, and there is some document related functionality that won't be migrated. Version One advise me that I can call a batch file to run an SQL query.
I guess my questions are:
Basically, we currently run SX.enterprise (I think it used to be Trend, but I'm sure this is a wider question) version 5.6.063, which (I believe) runs on Progress 9.1c or 9.1e. We use Version One DBForms to convert the spool files to readable documents. We are about to install version 5.7.060 (Which runs on Open Edge 10.1) in a test environment, and there is some document related functionality that won't be migrated. Version One advise me that I can call a batch file to run an SQL query.
I guess my questions are:
- Do I need any additional software?
- Would I need to configure anything on Red Hat?
- Would I use normal SQL-92 syntax?
- How would I connect to the database?