1. K

    Question Progress Data Migration

    Hello everyone. I'm new at progress. We have a Progress app that was already used at my workplace. It's not currently used. Data in that Progress needs to be moved to PostgreSQL or another database. I can access the single query on Progress Application, but I don't know how to list all datas or...
  2. T

    INSERT INTO with multiple rows without Select?

    I just got this error: Normaly in SQL you can do INSERT INTO (columns_list) VALUES (values for row1), (values for row2) ... I looked up the docs and theres the possiblity to insert rows from a subselect or something. Is there no way to just put 2 rows with one statement...
  3. T

    Answered Progress JDBC Implementation (limit connection count)

    Hello Community, im using the jdbc to query data from Progress db via sql. The documentation states that there is a parameter for maxPooledStatements. I've run some tests and found ot that this property does not limit the pooled connections or statements. Currently im programming a client-side...
  4. T

    Answered Transaction Isolation Level not working

    Hello Progress Community, im currently using progress 12.2 running on Linux Ubuntu 20.04.3 LTS (Focal Fossa) and access it via JDBC and ABL-Sessions. (Promon screenshot showing the connections) So i did the following test: 1) Open a transaction via JDBC, change a Record via SQL `UPDATE` and...
  5. J

    Extremly slow using Progress and SQL-Database

    Stamford has made a product called CCM that has been developed for 10 years (current version: OE 11.6). Data resides in two SQL databases (Microsoft) and one DB2 database. The application works mainly against the database "CCM-SQL". The front-end (.html) code is written in progress code /...
  6. N

    ODBC connection causing DBI file grow

    Hi everyone It happened today that while connecting to the database and querying tables on our progress server the .dbi several files were created. Each of them was about 3GB large and because of it we nearly ran out of space. Is there any way to prevent these file growth (i.e to not be larger...
  7. B

    How to find out if record is locked

    Hello community, by a PHP Application i want to update a dataset inside a Progress-Table, that is working generally. But it is possible to work on the same dataset inside our EPR-System that locks the dataset. Now when i want to update the dataset this i get this error. SQL error...
  8. S

    Update records in Progress DB using SSIS

    Hello, I have a Progress DB as an ODBC source which i export data from to allow transformation and then import into a SQL DB. I would like to import cleansed data back into my Progress DB (update is most important but insert/delete could be useful too) Does anyone have experience of doing...
  9. J

    Create / Edit SQL Statements

    What is the "best" (that should 'start something') editor for Progress SQL - Data Administrator Console, TOAD, AQT, SSMS or ???
  10. J

    !!! Sx.e Job Opportunity !!! Houston, Tx

    I have a client in Houston that has an immediate need for someone with experience supporting Infor SX Enterprise and Progress databases. Any coding/customization experience is a plus but at this point I want to talk to anyone interested in a fulltime job focused on SX.e with a great company...
  11. davidaichele

    Finding Non-alphanumeric Values

    Without the ability to leverage regular expressions in a SQL query within Progress... does anyone know how I can write a where clause that will identify non-alphanumeric values?
  12. J

    Materialized Views In Progress

    Hi, Is it possible to create materialized views in progress openedge. if it is possible, how can we create it. please suggest me. thanks.
  13. J

    Too Many Values Specified (7531) Error

    Hi, we are getting this error while we running below query in progress11 through odbc tester tool. Error :-[DataDirect][Odbc Progress openedge wire protocal driver][openedge]Too many Values Specified (7531) Query : select SUBSTRING(g."Account#",(((select sum(ss.Seg_Len) from hrdb.ab_cd_Def ss...
  14. J

    Mutiple Database Connect Using Proenv Command Prompt In Progress 9.1e

    Hi, We can connect sql explorer through proenv cmd prompt in progress, for single database by using below syntax sqlexp –char –S port –H hostname –db database –user username –password pwd. but, how can we connect mutiple databases in sqlexplorer of Progress 9.1e. ? Actually i need to write...
  15. D

    Export of split image(varbinary(max)) from Progress to Sql

    Please excuse my ignorance in regards to nomenclature here, I am brand new to Progress. I need to pull some data from a progress database (Openedge 10.2) in which the table is storing Binary image files and move it into a SQL . The files are split off into multiple chuncks. From what I have...
  16. J


    Hi, what is UPDATE TABLE STATISTICS , INDEX STATISTICS AND COLUMN STATISTICS. ? what is the use of these statistics? thanks, Jeeva
  17. M

    SQL Function IFNULL

    Hi to all of you. I need an help about SQL Function IFNULL I need to test if a date is NULL, if not i need to obatin that date in the field, otherwise i need to put a dummy date.. Ex. IFNULL (prezzi.duc , '2000-01-01') I write from Italy , is it correct to put '2000-01-01' to have...