Recent content by Drammy

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