Search results

  1. T

    JDBC drivers for Progress -- not working...

    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...
  2. T

    Select element from Progress array column

    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...
  3. T

    Tuning Progress SQL

    Can someone point me in the direction of documentation on tuning Progress SQL statements? I have a slow running query. Cheers! :cool:
  4. T

    SQL to get Progress database version

    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...
  5. T

    REGEXP_LIKE in Progress SQL

    Oracle has a function called REGEXP_LIKE -- 'regular expression like'. Does Progress have such a function or something similar? Cheers
  6. T

    SQL COUNT in Progress

    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...
Top