Search results

Thanks - it all worked w.o. problems. I just ran it on the tables in question. I don't think it has ever been run. Didn't see much if any of a performance gain though.

I was more worried about any potential lasting ill effects. If that's not the case we should b e fine. Thanks for the heads up though - we are on 11.6. But on Redhat Linux / VMware. (Just as a side-note - we were on AIX before and ran into some bugs afftecting Progress that I think were specific...

OE 11.6 / RHEL 5.11 - A little bit nervous to try it. I'm worried about any potential negative side effects on ABL AFTER you run UPDATE STATISTICS. I'm aware it'll use lots of resources while you run it. But we are not 24/7 shop so I can find some down time.

Thanks - yea, that's what I want to do, trying to marry it together with sequelize in a node / express web service. I was trying to use node odbc but I just couldn't get the same performance on some of the queries as I got with ABL.

I would like to access, (guess I should say expose), our OE 11.6 database residing on RHEL 5.11 using, (should probably say through), a rest web service. We don't have Open Edge studio licensed. And before I embark on reading the 390 pg docs It'd be nice to know. The section mentions "tools...

Deng - all these years and I didn't know - Thanks for opening my eyes!

On OE 11.6, RHEL 5.11 in the procedure editor: Don't remember if/when I used index hins before. But I can't get it to work. SELECT Order.orderNum, Order.entDate, Order.entCode, Order.whsLoc, Order.totMerch FROM Order WITH (INDEX(updatedAtIdx)) WHERE...

Ooops - Yea, typoed the sql query example above. Adding the same criteria, cono = 1 does yield the same result as depicted though, which was what Intended to show. I was just trying following the example in the Progress KB: /* Works in OpenEdge 10.x and 11.x Replace "SomeTable...

Been trying to figure this one out for a a while w.o. success. What am I missing here? OE 11.X They say SELECT DISTINCT = BREAK BY & FIRST OF: Progress KB - What is an ABL equivalent for a SQL SELECT DISTINCT? BUT FOR EACH icsec NO-LOCK WHERE cono = 1 AND icsec.altprod = '33-835' BREAK...

We did the same upgrade a month ago. Initially we used the 10.2B ODBC drivers w.o. problems. We upgraded the drivers after a little while and everything went fine.

Thanks for the info. Swapping the order of the dates around or using the BETWEEN syntax didn't seem to have any effect. I will turn on logging and see if it provides any clues. I've previously been nervous about running UPDATE STATISTICS since I've heard about possible performance problems...

I'm querying an OE 10.2B database running on RHEL 5.11 over as a linked server odbc. Specifically a on a date range being part of a composite index. If I run this SQL query from the OE development on the server it finishes in a couple of seconds. However, if I run it from SQL management studio...

Apparently the ODBC driver does not support cancellation of queries. Just disconnecting the user worked fine here.

I started a query against a sql data server which I later cancelled. It looked like the cancellation was stuck, so I closed the session. Bad move it seems. Even though the session is gone, it looks like the query is still chugging on. And yes, it was a bad query as well. Is there a way to...

Thanks for the info!

Lowering the red by a factor of 20 made no difference to the time the backup took. It took a little bit less disk space but that difference is negligable in our environment.

LOL - just came across this thread and remembered that our backup script uses a 1/10 redundancy. We backup to SAN so I quickly bumped it to 1/200. But I'd like to keep it since we verify with crc check. I'm thinking the crc would be faster than the block to block verification, or? CJ, if I...

Thanks all for the info! Will go for 11.6

Thanks for responding! Not sure how the use got disconnected. His ssh session was gone but his login was still listed for each of the databases encompassing the system. [2016/11/10@09:55:41.235-0800] P-19600 T-2032285504 I ABL 354: (708) Userid is now dank. - LOGON ...

Progress 10.2B03 / RHEL 5.11 - yep I know both are antient. Webe upgrading to OE 11.3 in Dec but I can't wait that long. We have a situation where a SELF service user got disconnected and left a transaction with subsequent locks. Proshut disconnect doesn't let us finish him off. 1. His...