Search results

Thank you so much for the quick response and for the solution. This worked perfectly!

Hello, I'm looking for some assistance on how to solve a looping issue with a query. I'm trying to create a list of all products, the total quantity in inventory for all warehouses, max invoice date and max PO receipt date regardless of which warehouse it occurred in. I'm creating a temp table...

I know this is an old post, but wanted to ask, is it possible to keep X number of archived log files via the conmgr.properties or if the only way to manage the archived log files was through a script like the one Tom Bascom provided in an earlier post on this thread?

When doing a buffer copy to create a new record do I need to exclude the rowpointer in the copy? example: create b-icsw. buffer-copy icsw except cono whse to b-icsw.

@Patrice Perrot the -H was the key to solving my issue. Thank you both for your help. I really appreciate it.

That's a good point, and no I did not, because the example of the command in the article I read did not include that. I will give that a shot and see if it works. What would be the format of that command? proenv> sqlexp -H <hostname> -db <dbname> -S <portnumber> -user admin -password #####...

Thanks Tom for your feedback. I'm not familiar with dbrpr but I will look into it. We have one extent that is much larger than the others so I probably need to determine what is being written there.

Thanks for the information @Rob Fitzpatrick . I was just curious to see if there were any recommendations or if a certain size, say over 100 GB was considered bad perhaps due to performance.

We are running Progress 11.7.3. I was wondering if Progress has a recommended max extent size. Does anyone happen to know? Many years ago it couldn't be over 2GB but then they gave us the ability to enable large files which allowed for larger extent sizes.

In the conmgr.properties I see a port and it says the type is sql. I tried using that port to connect to the DB using the sqlexp command in proenv and it failed to connect. I looked at the log file and below are the errors. Assuming that means I do not have the correct port, but I think it is...

Thank you @Rob Fitzpatrick for that information. I think I found the sql port in the conmgr.properties. I'll try running the command using that port and see if that solves my issue.

Using the data dictionary, I created a new ODBC user. I do not want this user to have access to all tables and only want the user to have read only access to a few tables. I've created the script with the tables I want to grant access on using the example found in article P55080 on the progress...

Thank you Rob for providing that example of how to query using the recid. I was able to find the information needed using your example.

I have a single record that is causing an ODBC query issue because the data is larger than the sqlwidth. I know I can use the dbtool command to correct it, but before doing so I'd like to review the record that is causing the issue to identify how it was created. I have the rowid but cannot...