Search results

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

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

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

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

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

Hi all, Our developers at work have developed a routine that extracts all data from all tables to text files. The routine does some data manipulation such as replacing the Progress null char (?) with blank string. In my initial tests I was finding output speeds upwards from 7,000 rows per...

Hi all, Apologies if I have posted in the wrong forum. I have a .r file that I need to run in batch mode. Currently it throws errors to the screen. I have no means of changing this but was wondering if there is a startup parameter I can use to stop the messages appearing on screen and log...

Hi all, I need to update the SQL Field widths whilst users are connected to the database. Am I safe to run dbtool (option 2) whilst users are connected to a V10 database? Thanks, Drammy

Hi all, I would like to migrate an OpenEdge 10.0b database to SQL Server every night using the Migration tool within Data Administrator. Thing is I would like to automate the process. Is there any way of running this app by passing parameters via a batch file and suppressing any messages...

Hi guys, I am new to the forums so; hello everyone. I have created a Linked Server in SQL 2005 linking to an Openedge 10.0B database. I am having to do a query like: SELECT [ENTITY-INT-CODE], [NAME], [ENTITY-TYPE-CODE] FROM BUGFIX..pub.Entity WHERE...