sql

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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