Search results

Thanks for replying Rob! Yes, we are using 11.4 but didn't notice anything relevant yet. I agree, that if this bugs impacts my application then i could use -nottdelay startup parameter. I wrote "Please Check" because i was wondering that version 11.3 and 11.4 both are using delay...

Thanks for replying Andre, Good to see that from 11.0 version temp-table are initiated only when we are actually using them. @ Tom, thanks for your inputs. As of now I understood the difference between Temp-Table/Work Table with respect to memory. There is one more relevant knowledge base...

Thanks for replying Greg! I agree, that we should always use NO-UNDO with variables and temp-tables. I agree, that when temp-tables increases more then specified size (defined in -Bt parameter) then it moves from memory to disk or vice-versa (depending on there actual existence). But where is...

@TheMadDBA, Thanks for your inputs on this!!! I will look into that again and probably get back to you with better understanding. Regards! Rajat.

@tamhas As per my understanding, temp-tables are database tables and stored in temp database that's why we could create index on them unlike work-tables which are stored in memory (please suggest). @TheMadDBA Sure, I would look into that again. I am just curious to know that if both of the...

@tamhas I am not much aware of these parameters settings. i will go through the relevant docs. what i understand so far is: If we are only defining temp-table then should it be fetched from disk to memory? I think, If size of the temp-table is large then -Bt parameter then only progress moves...

Thanks for replying Greg, Tamhas, @Greg, I agree, If we aren't using no-undo with define temp-table then it will write notes (logs) to .BI file and unnecessary we are growing the size of .BI file. I agree, If we define temp-table BY-REFERENCE then instead of deep copying temp-table to called...

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

when we call .p program from another.p then ultimately we are switching control from calling procedure to called procedure. When control goes to called procedure then previous state of calling procedure is saved into stack memory. we aren't calling include files, we are including the file (or...

Hi Rasool, Instead of writing same type of code again and again, we create an include file with different parameters and use it whenever we want to. They are many types of procedures in progress like: Internal, external, super, persistent.. You can go through progress handbook "Prohand"...

Thanks for replying Tom! 1. If i am using can-do without where clause (like in my example #2) then nothing would go to client side for comparison purpose? so it doesn't make any difference if i replace it with lookup. 2. Based on above discussion, I think every where clause is checked that...

Thanks for replying Greg, TheMadDBA, In example #2, if i change can-do with lookup or something then does it make any difference (please suggest)? which one we should we choose ? Thanks & Regards! Rajat.

Hello Everyone, hope you are doing good. :) As per earlier discussion, I have been using lookup/index instead of CAN-DO function and conveyed this message to my colleagues but they won’t understand that much and seeking more description/proofs regarding the same. 1. As already mentioned that...

I agree, MadDBA. I have described that because anandknr said that: "Strangely, I couldn't find a single (user added) table with have Primary as false". Thanks & Regards! Rajat.

If we don't create primary index on any table (we should always create at least one primary index per table) then progress automatically create primary index of recid's and index data structure contains all recid's (row identifiers). Thanks & Regards! Rajat.

Thanks Stefan, i was looking for the same. :)

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

Yes, i will double check that (as suggested) before making any changes. One more thing that i asked earlier is, why we are creating one index to contain n number of fields. I think we do that when we want to treat multiple fields (4 in our case) as a composite primary key index. Please suggest...

Yes, i was also thinking to add c-num in the existing where clause and i will double check if i could replace FIND LAST with FIND FIRST. Thanks & Regards! Rajat.