Using Progress 10.1B JDBC drivers:
URL: "jdbc:datadirect:openedge://100.10.10.100:20000;databaseName=myDatabase;schema=mySchema"
Driver JAR: openedge.jar
Driver Class: "com.ddtek.jdbc.openedge.OpenEdgeDriver"
With Java application, get the following error stack trace...
Can anyone provide an example on how to filter on a array column in SQL?
for example:
select "employee"
from "employee"
where "age[2]" > 40;
"age" would be an array column in the table "employee" and I wish to look at the third element.
Of course this SQL does not work but you get the idea...
Does Progress provide a means to determine what version of the database is currently being used?
For example:
SELECT @@version
FROM someTable;
I am on a remote client and do not have access to the database server. So I can not view any files on the server to determine the Progress database...
I have used many databases and can do
SELECT COUNT(DISTINCT col)) as colname
FROM mytable;
but having problems with Progress.
Question: How do you count distinct rows?
Also, what is the equivalent to the Oracle REPLACE command? (which search a string and replaces all occurances of a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.