Search results

Thanks chaps - really appreciate your time to answer the questions...

Thanks Tom, And one last question - I suspect that at some point in the future I'm going to come across an old system running on Progress 9 db. I assume the OE11 4GL dev license won't work here so what options do I have then?

Thanks - that's great information. In the past I've simply gone into the procedure editor (yes, on Windows) and run a .p file. Will I be able to do that with an OE11 4GL dev license against OE 10 and OE 11 dbs?

Hi all, I have some ABL procedures for the extraction of data from an OpenEdge database (generic code foreach through _file etc...). I need to be able to run the code against OpenEdge 10 and 11 databases. I need to be able to run the code against db files on their own as well as databases...

Thanks Cringer, So I'm talking OpenEdge 10.2 b and above. So how do I go about invoking SQL92? I'm more than comfortable with SQL so am keen to better understand what the pain will be?

Hi guys n girls, Is there a way to execute some SQL92 from within an ABL routine?

Thanks Tom.I agree it should be default. There's a lot of hoops I'll have to jump through to change the start up parameters of the app server. Do you know if one of the properties on the proxy connection object allows me to set this value for the life of the session? It sure would be useful...

Hi all, I have a proxy-genned class that uses the RANDOM() function. I would like to ensure the RANDOM() function returns different values on each execution and understand I would normally use a startup parameter RAND -2. Is it possible to pass this when instantiating the AppServer object (in...

Hi all, You know the binary dump files the data admin tool creates when it dumps an openedge/progress database? Well I want to create them programmatically from data from a third party system and then load them into an OpenEdge/Progress db using the data admin tool. Anyone got any ideas about...

Thanks for the "food for thought". I'll follow some of those ideas up...

Thanks for the reply tamhas, It is remote and a one off same machine type solution where I would prefer to avoid Sonic or the appserver. Would you mind giving further details of the socket approach? Or perhaps point me in the right direction as this is fairly new ground to me... Cheers, Drammy

Hi all, I have a situation where I am faced with rewriting/translating a particularly nasty piece of Progress 4GL into T-SQL or .net Before I undertake this task I would like to investigate means of exposing the existing function so that I execute it from VBScript or .net... Anyone got any...

Thanks Tom, This isn't for any particular OS. I would just like to know how to do it. My Clients use both Unix and Windows. Although, now I know how to do it on Unix.

Thanks Arshad, I'm not familiar with the cat command. Am I missing something?

Hi guys, I would like to have DBUTILs -tabnalys stats emailed automatically every morning. Can anyone advise how this can be done? Thanks, Drammy

I'll get on with checking it then. Yes, whole db. I've tested with one session and 3. Normally the process runs from a client over the network so reading and writing to and from separate disks and controllers. I've noticed no difference in running on the server than running over network from...

They all run Enterprise with a -spin setting of 5000 per processor (only for multiprocessor servers).

Well the actual process cycles through each table and outputs every record into a text file. Each table is output into a separate text file. Its a bit like the Progress utility to dump a tables data, however it manipulates the data into a more useable format for loading into 3rd party db...

Sorry Tom, that should have read "our" - sorry if it alarmed you, I can understand how it might have! Thanks for your continued assistance and I understand why it is important that your questions are answered, unfortunately I am unable to answer them as I am not in the technical support team...

Thanks Tom, HW resources of the 2 clients: Linux: 12 CPU cores, Xeon box with 16 Gig RAM, not sure on HD. The -B setting is 375000. Windows 2003: Not sure, not my client. But as a company we insist on good hardware, probably not as good as the box above though. The Linux box has two dbs on...