Search results

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...

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...

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...

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...

Hi everyone, hope you all are well. :) I have been trying to conclude that is it possible to check index on a dynamic query like we have XREF for static queries? Please suggest. Regards, Rajat.

Hello everyone, hope you are doing well. :) I was in a discussion of temp-table loading and deleting problem with respect to memory. I am explaining the discussed problem and the example which I have tried regarding the same: Problem: One temp-table (for ex: abc) is having around 60000...

Hello everyone, hope you are doing well!! I want to retrieve all the data from two different files (abc & abc1 in our example) at the same time. If I do something like that (please refer below code for this) then I could get only first line from both of the files and if I surround input from...

Hello everyone, hope you all are well!! I have a little confusion with FIND LAST/FIRST statement. I think, indexes are stored in ascending order if we define them as “A” otherwise in descending order with “D” (please suggest). So basically FIND LAST and FIRST will search (index or table search)...

Hello everyone, i am stuck in a problem of long transaction: For interfacing a fie (with comma separated delimiter) we were fetching each line one by one (in a repeat loop) and storing the variables (fetched from file) into database table (with create statement) in a different .p program (.p...

Hello everyone, hope you all are well :) Please consider few of my concerns regarding indexes: 1. When we don’t define an index on the table than a default primary index is created on the table (checked), but what does this index or data structure (that index use) contains. When I tried to...

Hello everyone, hope you all are well! :) It’s difficult for me to visualize the complete picture of persistent/super procedures. I read relevant past threads and docs but still have few doubts. · If I run an external procedure as persistent then an instance of that procedure is created in...

Hi everyone, hope you all are well! I have couple of question regarding temp-tables. I know these are very basic questions for this forum, for that i did go through “PROHAND” and few other docs that I have but couldn’t conclude anything regarding the same. 1. We have been working with...

Hello everyone, hope you all are well! I posted this thread five days back in Roundtable TSMS but didn’t get any reply. I think this thread is relevant to Development as well so placing it here also(please suggest). Actually, I want to create a script for Roundtable (RTB) that contains...

Hello everyone, hope you all are well ! :) Actually, I want to create a script for Roundtable (RTB) that contains combination of UNIX commands and progress 4GL code ( where 4GL code and commands are interrelated). We are using “gvi” editor for scripting purpose. Initially I have been thinking...

Hello everyone, hope you all are doing well. :) Initially I have no idea regarding how transaction works in progress but now I started working and playing with them, I have few queries regarding transaction: 1. In FOR EACH loop, each iteration comes as an individual transaction. So for second...

Hello Everyone, hope you all are doing well. :) I am stuck in a problem of long URL string. What I did: I wanted to display complete URL message and the size of URL string is 260 chars. I wanted to display that in doc print and we could display maximum 80 chars in a single line, for that I...

What is the difference between the reference of a table and availability of a table? For ex: FOR EACH customer: END. IF customer.name = “something” THEN MESSAGE “something”. Compiler will allow me to compile this code without any error or I could reference the table customer outside the...

Hello Everyone, hope you all are well. :) I have few queries related to buffer: 1. As per my understanding each DB table has its default buffer with the same name, then why to create buffer with the same name as table name, apparently it works the same as default buffer. please suggest. 2. We...

Hi Everyone, Hope you all are doing well. I found some scenarios where CAN-DO function doesn't work the same way as it supposed to be(with special symbols). Somewhere i saw that CAN-DO is too old in progress programming and it is designed as a Security Function so instead of using CAN-DO we...