Search results

I thing if we are calling internal/external procedures only for code readability and not using the advantage of transaction/buffer scope (in internal procedure) then we should use include files instead for calling procedures(to save switching time). Thanks! Rajat.

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! Tom, As suggested, I tried passing parameter to procedure file (.p file) through Shell Script(.sh file) and received this error. ERROR: _progress NOT FOUND. TheMadDBA, I have checked the concerned link (suggested by you), but didn't find anything...

I think you should check REPLACE function. Initially, you have to fetch the string along with delimiter used, manipulate that according to your requirement (use REPLACE function) and than use it in temp-table or wherever you want. Thanks & Regards! Rajat.

Thanks for replying TheMadDBA, Cecil, TheMadDBA, I have been searching for relevant documents or API but didn't find anything related. could you please share any link or document that i should refer regarding the same. Cecil, Sorry, but i don't know how to connect with Gary Clink and share the...

Thanks for replying Rob, TheMadDBA, Rob, 1.Does exclusive-lock can exist even if transaction completed?. 2. Regarding your second point on RELEASE statement, Here i don't know how to differentiate between client side and server side lock/record buffer. TheMadDBA, Sure, i will give another read...

Hello Everyone, Hope you all are well. I have further questions on Transaction and Release statement: Is it true that lock on the table could exist even if the transaction is being completed?. I tired many scenarios for achieving that, but found that once transaction is completed then the...

Thanks for replying Tom! I will give it a try and may get back to you on this. Thanks & Regards! Rajat.

Thanks for replying Rob! Actually in our local shop, whenever we don’t need any program (.p or .i or .v ) from roundtable than we have to follow few steps manually like: 1. Move the program into a different folder (specific folder for deleted objects) 2. Delete the content of the program 3...

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

Thanks Tom, Rob, These attachments are important and interesting for me. :) Thanks & Regards! Rajat.

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

Thanks for replying Tom! It’s difficult for me to understand the difference between sub transactions and nesting of transaction that could cause WARNING-TRANSACTION error message. For Ex: REPEAT: /* DATABASE UPDATE */ REPEAT: /* DATABASE UPDATE */ END. END. According to...

Tom, thanks for replying and creating new thread for this. By this post, I could understand the existence of transactions in memory and in disk as well. I have a few concern regarding the same: 1. I know, if transaction is too large (millions of records updated in a single transaction) then...

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

Thanks for replying Mad DBA, Sorry its in word doc (.doc) format. Actually concurrently i was writing at two different forums so, by mistake i wrote .txt there. i know .txt is a simple plain text without any formatting. By the way, thanks for your suggestion. Thanks & Regards! Rajat.

Hello Everyone, Depending on Tom said above, i further discussed in my local shop and finally we have concluded that we should take whole string URL in a single scrollable line instead of breaking the URL message into multiple lines. we did that successfully by using PUT UNFORMATTED and...

Thanks for replaying Dude! So you want to say that the scope of FOR EACH block is available outside the block but it doesn't contain record in the buffer. If yes, then there should be no harm to use weak scope buffer or what is the use of this reference. Please suggest. Do we have other blocks...

Thanks Tom, Larry, for your mentorship on this. I will search for the document type and related stuff and may get back to you on this. Thanks & Regards! Rajat.