Search results

Hi George I am using this type of function where I can select the user and the "activity" (Lock, access ,read on table index or lob) I want to analyze . Each time the ativity of a user is above the threshold between Tx and Tx+1 (0.005 sec between them), I record its full call-satck (Tx and...

Hi Ron, So -- it all looks good except that it seems that sometimes (when index changes are involved) a re-index would be needed, and (I suppose) that means taking the system down (albeit for a fairly short period). => Idxactivate could be used to avoid the downtime. I have a question that...

Which user are you using to run 'grant select, update, insert,delete on PUB."' + _file._file-name + '" to ~"dario" ' This user should be allow to do it (like Sysprogress) Patrice

Hi The error message seems to be on the FIND FIRST darwin.cupbackconv . You can add a no-error on it to avoid the message.

If you like adventure, complexity (not too much) , ... you could have a look at Nectar's breakout session at the last PUG on Online Dump-load . (The ZERO downtime Production Dump and load - PUG Challenge) It will allow you to: - Dump-Load on line - Change your RPB for each table - have small...

Sorry, I do not think it will work... The backup will restore each records in its current block number (it does not eliminate the empty blocks) You will have the same number of blocks in each areas (even if you could use different extent size or number ). If you run an idxbuild you will lost...

If you enable the Audit Feature , you will probably have to increase the -L .

Hi I don't see the Audit-field in your xml. Patrice

format "->,>>>,>>9.99999"

totally agree with Tom and Rob

Hi Tom, They have to specify the -S XXXX to connect one of the broker If they specify "-S fbbj92-srv " for the 4GL connections and " -S fbbj92-srvsql " for the SQL connections , there is no mixed .

I think it could work without the "-ServerType" (to avoid the "warning") , you always specify the good "-S " for your connection so they will be done on the good dedicated broker. "-S fbbj92-srv " for the 4GL connections and " -S fbbj92-srvsql " for the SQL connections ,

Hi, I thought that on a "for each no-lock : create . ... end.", the transaction is "by default" for an iteration of the for each (1 record by transaction). If I am correct, to have a lock table overflow in this case , 3 options : 1/ the "for each" is fired in a transaction 2/ there is a...

You can use largefile with a size limit if you specify v + size, Example below is a limit of 2Gb for a variable BI b . v 2048000

Hi It seems that excel round the value with a precision of 4 degits. So you could try MESSAGE chExcel:Range("C5"):VALUE SKIP LENGTH(chExcel:Range("C5"):VALUE) SKIp Round(Decimal(chExcel:Range("C5"):VALUE) , 4 ) VIEW-AS ALERT-BOX. Patrice

Hi, I assume this is the same as this post in the community ? https://community.progress.com/s/question/0D54Q0000ADfP36SQF/define-trigger-for-all-tables JP (João Pinto ?) , could you confirm ? If yes there is more information on what is expected. Patrice

You can also assign it directly in the buffer-copy create b-icsw. buffer-copy icsw to b-icsw Assign b-icsw.uniq_id = New-Uniq_id b-icsw.cono = XXXXX...

Do you specify the -H value on the sqlexp (the linux DB Server name)?

Hi , trying to connect to a linux DB from a Windows computer => Error establishing socket to host and port: localhost:#####. Reason: Connection refused: connect Do you specify the -H value on the sqlexp (the linux DB name)? Patrice

Hi, Have you set a particular word-rules for your DB ? There is the parameter -ttwrdrul which sepcify the word-rules for the temp-table in your session . Patrice