TomBascom's latest activity
-
TomBascom replied to the thread Question How much RAM does my database and processes use?.This: Says that of the 540,674 buffers (the value of -B) that were allocated 4,665 have never been used. If this data was gathered... -
TomBascom replied to the thread Relocate Extend Online.You cannot, however, do this online (as suggested in the thread title). The database must be shutdown.
-
TomBascom reacted to Ashwani Mishra's post in the thread Java client for Progress 9.1e AppServer with
Like.
Using ProxyGen (Progress Tool to generate proxies file from Progress .r code for Java / .Net OpenClient) you can achieve this. (Below... -
TomBascom replied to the thread Progress9.1e Prowin32.exe is not releasing memory.Perhaps you could consider sharing an example of some code that exhibits the undesirable behavior?
-
TomBascom replied to the thread How to Query Longchar.As Stefan says, you cannot do the comparison in a WHERE clause. So you will need to do it like this: for each tableWithACLOBField...
-
Why could you not write:
-
TomBascom replied to the thread table count does not change after importing records.There are a couple of vaguely positive benefits: 1) The backup for the main database is smaller. (But your total backup size remains...
-
TomBascom replied to the thread table count does not change after importing records.These archive, purge, and reload on demand schemes are almost always a complete waste of time and effort. 1) The schema will probably...
-
TomBascom replied to the thread table count does not change after importing records.Sorry, but I cannot accurately guess why your code doesn't work when you don't post what you are actually doing.
-
TomBascom replied to the thread table count does not change after importing records.There are two obvious problems in the code as shared. The requirements narrative says that the exported records are to be deleted. But...
-
TomBascom replied to the thread table count does not change after importing records.Just guessing again but the logic behind purge, archive, and reload on demand is often driven by a belief that keeping “too much” old...
-
TomBascom reacted to Rob Fitzpatrick's post in the thread table count does not change after importing records with Like.
I understand that the user might want the data later. That explains why you want the data. It does not explain why you are choosing to...
-
TomBascom reacted to Rob Fitzpatrick's post in the thread table count does not change after importing records with Like.
Another possibility that these totals are both correct. For example, if you had another 100 records where cono=888 and they got deleted...
-
TomBascom reacted to Rob Fitzpatrick's post in the thread table count does not change after importing records with Like.
What is the point of deleting and then reloading the records? Why not just leave them in place? And have you thought about how you...
-
TomBascom replied to the thread table count does not change after importing records.I see a lot of SQL. My first guess is that you neglected to "commit work;". My second guess is that you are ignoring an error message...