Recent content by Rajat Sharma

Correct Tom :) But if we reached (80%) Type-1 area limit and we don't have downtime window for next 2-3 weeks than i think we should better do TABLEMOVE online for all the tables having size from 0-600MB. Regards,

If table size is less then 1 GB then you can do tablemove otherwise you should do dump/load. Regards,

Thanks Tom and Rob, for the clarification!!!

Thanks for the replies! I am fine with OpenEdge replication and agree that we have to use -S for making it enable. I have few related quires: If database is started with -S parameter than can a user remotely access the application with Shared memory. Is there any benefit of using TCP/IP...

Thanks for the replies! As we are able to access application remotely without -S parameter via accessing the shared memory (through Appserver) then why should we use -S at all because working with shared memory is faster than TCP/IP connection (with -S) and TCP/IP may cause some network issues...

Yes along with the site replication. can we add ports with these databases. I hope it won't interrupt current running user application. Can you please describe this a bit “In that case the database is started without network capabilities and can only be accessed via shared memory from...

Thanks for your reply RHD! So for replication or for ai-rollforward, we need to stop this database and start it again with -S parameter. Is my understanding correct? Regards, Rajat

Hello Team, Progress Version : 11.6 QAD: 2016 EE There is no -S parameter defined in database startup script and there is no such .pf file that contains these parameters. We found below entry in DB log files: (4262) Service Name (-S): 0 We need DB ports for setting repl.properties file...

Thanks for your response Tom!! As suggested, I have been trying to coordinate with some Unix experts, those could help me in setting print queues. Regards, Rajat.

Hi All, Hope you are doing well!! I want to do printing stuff with UNIX environment from Progress 4GL. I have gone through and tried some code (mentioned below) regarding this but getting some queue error. OUTPUT TO VALUE("Test file path"). PUT "Print Example". UNIX silent lp -dlwmis...

Thanks RHD, shared link was really helpful for me. As of now, I understood the working of “readhandler” method and SMTP commands used under this this method (referred shared SMTP example). Under SET-READ-RESPONSE-PROCEDURE method (mentioned below) we are specifying that Readhandler should get...

Hi All, hope you are doing well !!! I want to implement mailing in progress by using user interface screen (progress GUI) and with batch process as well. Neither I want to use outlook object nor UNIX utilities (like sendmail for this). I think for achieving this requirement I can use progress...

Thanks Tom, I understood the basic use of THROUGH keyword with OUTPUT statement. Regards, Rajat.

Hello All, hope you all are well. :) I want to know the usage of through with output statement. I have gone through its help but didn’t understand much regarding the same. If we have something like: OUTPUT STREAM strMail THROUGH VALUE("/usr/lib/sendmail -bm –f abc@gmail.com -t " +...

Hi everyone, hope you all are well. :) Every time I write query, I am curious to know that on how many records progress creates bracket (In index entries data structure). Apparently, it’s important to know because number of records get bracted could be different from retrieved. Is there any...