Search results

Thank you all for your replies and advice. I'm out of the office for a few days, but when I return, will be reviewing all of your suggestions in detail and will let you know how things go. Thanks.

Also, here is the start of the db log file.

Thanks everyone. Will try to answer all questions that were asked of me. Also downloading Pro Top. I understand that 10.2B07 is old and unsupported. Within the next 6 months we will be upgrading to 11.x...there are a number of moving targets and our Progress upgrade is dependent on some other...

Hello-Over the past few months we've been experiencing some performance issues, so we've been reviewing all Progress, network, OS etc....settings trying to determine where the problem might be. We're on Progress 10.2B07, AIX 64 bit. We noticed that the -B (blocksindatabasebuffers) param was set...

Ahh...you are correct. Thank you...problem solved.

Correct...only add field. This is exactly what happened: First, I applied this .df: ADD FIELD "duetime" OF "pwfrfqqtehdr" AS character FORMAT "xx:xx" INITIAL "" LABEL "Due Time" POSITION 44 MAX-WIDTH 10 COLUMN-LABEL "Due Time" ORDER 430 . PSC cpstream=ISO8859-1 . 0000007244...

Hello-We are Progress 10.2B007 (will be upgrading this fall when the newest version of our ERP software is released). My understanding has been that we should be able to add new fields to existing tables while the database is online. We have done so many times in the past by loading a .df that...

Hi All-I am opening Internet Explorer from a Progress program (10.2B0709) using the following method: CREATE "InternetExplorer.Application" oExplorer. oExplorer:Visible = True. oExplorer:Navigate("www.testsite.com"). Is there a way I can get the IE Window to be on top of other windows when it...

Hello-We are on version 10.2B0709. We have type 2 storage areas. Database size is 350 GB. Database resides on an IBM AIX system. We have been told by two different Progress consultants that since we are on type 2 storage areas, we should not need to do dump and loads...that doing an index...

We do leave AI running during schema changes. For some reason I was under the impression they didn't roll to the DR. Good to know. What is best practice for applying structure changes?

Hello-We have a warm spare disaster recovery site. We sync our after image files to it and roll them forward via scripts. If we make schema changes to the source (production) db, what is the process for applying those changes to the target (DR) database? In the past we've always ran a backup of...

Hello-We've been using Trend/SX.enterprise for 15 years now. I should be able to help. Invue is just the telnet client that you're using...the manual for it won't explain how to use the Trend/Sx.e software. Do you know what version of Trend/SX.e you're on? The main login screen should show that...

We have found Infor to be extremely difficult to work with in general over the past few years. I don't have any experience with Axiar Deliver, but we chose to use Unform and it was very easy to implement and has been working great for us for over five years now. What kind of issues are you...

The smart viewer I am referring to is ADM1. Thanks.

Not really. First of all, I have to explain that the screen we are modifying is part of a menu that came with our ERP system. It's a smart viewer. Due to how the menu was set up by the software provider, we have to use a smart viewer for it to work with how the menu is set up. For each...

The goal is to replace 20 separate assign statements and 20 other repetitive pieces of code throughout the program. Current code is something like: if conditionA then then assign name1:Screen-value = "ABC". else if conditionB then assign name2:screen-value = "EFG". else if conditionC then...

Hello-A new programmer here asked me a question and I want to make sure there isn't a way to do this that I am missing. I know how to create dymanic queries...is it possible to create dynamic assign statements? Example (a very simple one...our real life scenario is more complex) A window has...

I posted this recently in the SQL forum and did not see any responses. Thought I'd cross post to development in case some of you on that forum have any thoughts. Thanks. Hello All-Our ERP system is SX.enterprise, version 6.0.060, running Progress version 10.2B04. We are in the process of...

Hello All-Our ERP system is SX.enterprise, version 6.0.060, running Progress version 10.2B04. We are in the process of designing a data warehouse and are investigating options for syncing the data in the Progress SX.enterprise database with the data warehouse SQL database. We came up with a high...

We have also been experimenting with the garbage collector parameter setting (I'm the one that started this thread). We did find two things that were playing a big part in the increase in memory usage: 1) Even though our system could run 64 bit Progress for several years now, the old version...