Recent content by rrojo7229

Hi, How can I give permissions to an specific user to disconnect users? User cronman cannot disconnect user caroline. (2258) Thanks indeed. Kind regards, rrojo7229

Hi, We work with a Third software,so our development it is quite limited. We have around 20 branches where it runs Batch programs at night. But if someone leaves the screen opened in a Maintenance screen ,that could lock the table. So, at night the Batch program fails for...

Hi, Someone has idea how can I run a program which connects several databases but they do have different Metta-Schemma. I mean, the databases are in different versions, so it is asking for recompilation. I tried to run in Source Code just without any compilation but still giving the...

Hi, Is there some way to startup more servers increasing -Mn parameter (-n parameter) but "Online"? I saying that thing because the DB can not be shutdown to take the new values for Startup parameters, during the day at rushing times. Progress 9.1E - RedHat Linux 3 Kind Regards,

Hi, No, this table is not a separate area, it is in the same area where all the tables are: "Schema Area". Kind regards,

Hi, Could you tell me please, which is the quickest way to blow up a table which has around 64 million records? - Delete table or make a delete by record - (using for each) with -i (Crash Recovery option DISABLED) in the proserve? Regards,

Now I added a score for this issue. Regards,

Hi Andrew, That works great.... You have saved a coleague from Ireland, Dublin... Thank you very much... Good Stuff. Kind regards,

Hi , Could you give a help how can I do that using Dinamic Queries? I know that should work for "where" clausule but Does it works for different indexes, too? 1) FOR EACH sltran WHERE sltran.co-code = ledger.co-code AND sltran.ledger-code = ledger.ledger-code AND sltran.doc-date GE...

Hi, Could you to guide me how can I built a code but applying variable values to &GLOBAL-DEFINE? As far I understood &GLOBAL-DEFINE works in a Static concept but why this peace of code works? /*** Works OK *****/ def var yvar as int . def var zvar as int. def var vdepo as int. def var...

Hi Casper, Thank you for your quickly reply. Actually, when the last BI variable got the Limit LINUX Size it was written these ERROR MESSAGES at log: 00:52:05 SYSTEM ERROR: Attempted to exceed maximum size on file /archive/bifiles/package.b3. (9452) 00:52:05 ** Insufficient disk space...

Hi, Please, could you give a tip? Database is not starting UP...despite is not writing any ERROR message at database.lg. The BI reached the limit last night and this morning the DB was shutdown and was added new BI Files. But now when we try Startup the DB - keep hanging up in...

Hi Tom, I am trying to improve the speed for idxbuild and my last turn was adding "-i" to try minimize the writing notes in the BI's, but this way below it was not show any alert message like "-i - no integrity" or something like that. Am I making something wrong? proutil package -C...

Hi Tom, It is posted here the results for dbrpr and idxbuild but neither did not show any problem. proutil package -C idxbuild ALL -TB 24 -TM 32 -B 1000 -SG 64 1940 indexes rebuilt Index rebuild complete. 0 error(s) encountered. (1644) proutil package -C dbrpr < dbrpr.inp >...

Hi Tom, Thanks for your quickly reply. It is not Code Page wrong issue, this problem has started after some Energy Failure at the branch where is this Database. The lg file has been shown this ERROR messages: SYSTEM ERROR: bfposto: position timestamp - 233013 - doesn't match the...