Search results

Dengit! You mean I didn't get to try it and find out for myself ;-) Thanks for the info!

Sorry, I typoed DELETE big-table should be DELETE buf-4-big-table. And thanks for the sample solutions!

We are running 10.2B and are prepping for a migrations. As a part of that we are purging a large number of records. The way the purge currently goes is: DEF VAR min-id AS INT NO-UNDO. DEF VAR max-id AS INT NO-UNDO. DEF VAR num-records AS INT INITIAL 0 NO-UNDO. DEF VAR trans-active AS INT...

Thanks for all the good info and advice! It will help for sure. Borrowing / renting a faster box sounds really appealing since we'll able to a dry run.

We are planning on migrating an OE 10.2B database from AIX to RH Linux. But have very little time at our disposal. All the tables is still in the schema area. I'm looking for ideas on how to speed things up and split it up if possible. Does it make sense to grab the data files from the source...

Hello, I'm curious to know if there is any significant performance cost to running proutil -C dbanalys against a database that's otherwise busy running mostly reports off hours. TIA for any input.

Solved, It seems the problem was not with the druiver after all. But rather how the linked server was created in this version of SQL Server. I was not able to make it accept username/password in the provider string. Once I used the security tab and filled in remote user name and password on...

Hello, Trying to create linked OE 10.2B databases in SQL server 2005 64 bit running on Windows 2003. We are using the Open Edge 10.2B 64 bit 5.30.00.98 ODBC driver by DataDirect? I'm able to successfully create and test the connection for the ODBC data source against the Open Edge database...

I have heard rumors but not yet seen anything. Does anyone have any info?

Has anyone been able to get the true 64 bit driver yet?

10.2A supports it. But after some thought we will probably not use it ;-)

Is that how it's done? It sounds like a whole lot of extra work that it seems like proxygen should take care of :-(. Does anyone know why. This must be a really common situation. I.e. what am I missing here?

How do you create a web service that returns parent-child joined database records : Customer->Order, Order->LineItems, or Customer->Order->Lineitems? I.e. what would the ABL code look like that I would feed to proxygen? It seemed like a DATASET would solve this but I'm getting an error when I...

They did a good job of confusing me. Thanks for straightening things out!

Pheew, found it. Don't know if I'm taking it out of context or what. From the OE Dev ABL handbook 10.1B, sec 19-2, Using Dynamic Queries and Buffers: "It’s important to note that these dynamic features are not meant to replace all the static statements in earlier versions of ABL (Advanced...

Tom, Thanks for the extensive answer. Now I must for my own sanity dig up the section in the ABL manual where they were talking about static queries w dynamice WHEREs vs completely dynamic queries. Basically I just want to allow query access to a set table through a web service and allow the...

Dammit, I though 17 was the root ;) Tom, I'm not sure I'm following: " If you cannot do it at all with a static query then how can you compare performance?" Follow up question: So the QUERY-PREPARE method is the way to do it, (dynamic WHERE), even for static queries?

Hello, I know the table I need to query in advance but not the fields. So I read the ABL pgming books about dynamic queries. In essence they say that you'll take a performance hit by using dynamic queries, of course. But, if you can get away with having just the where clause dynamic it will not...

Thanks, Great Info!

Yeah, Who would not want to use probkup? Thanks everybody for the clarification!