Search results

Thanks for replying MadDBA! :) I tried many example there and found that, whenever i use first index "leading component" in where clause then it will use proper indexing (checked xref output). For ex: These are the four fields of table c-data those are part of one index c-index (with same...

Thanks Tom, MadDBA, I have found WHOLE-INDEX issue with FIND LAST statement (that we discussed yesterday) but I didn't understand that why we are creating one index for n number of fields? For ex: I have one table c-data having 25 fields and one index c-index. Index c-index contains 5 fields...

Thanks Tom, MadDBA, for your mentorship on this! I will check the code again and may get back to you on this. Thanks & Regards! Rajat.

Tom, I will check for c-data.num that, is it a leading index component or not but if it's not then, should we change the sequence of the indexes or list in the index definition(could we do that?) or we can use USE-INDEX or what else we can do? MadDBA, I will do the timing stuff (as suggested)...

Thanks for replying Tom, Sorry i didn't understand that c-data.num should be "leading component on an index" does leading component means primary index or what?. If it is not then probably i need to add that field into indexing structure? Please suggest. Thanks & Regards! Rajat.

MadDBA, As i could remember, there was one FIND before run abc.p statement for updating the counter of table c-data (same table used to store records in abc.p). it looks like: FIND c-data WHERE c-data.num = i-num no-lock. /*i-num coming from file*/ IF AVAILABLE c-data then i-counter =...

Thanks for replying MadDBA! The main objective of the program is interfacing file and apart from parsing an input file and creating records in the database, i didn't find anything specific (i will look into that again). Writing data in a single transaction vs Writing the same data in n number...

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

Thanks for replying Tom, Tamhas, I think replacing shared variables with static class is a tremendous approach but if we face memory concern of static class (locked into memory until the session terminates) then is it worth to use a simple class and create new instances everywhere (I think this...

Hello everyone, Thanks Tom, shared presentation was easy to understand and useful for me. :) You mentioned in the presentation that “include files are worst practices talk for another time”. Could we replace include files with static classes, if yes then how because a class can contain data...

Thanks for replying MadDBA! :) My concern regarding whole-index is slight different. Does whole-index really exist or does progress really use a data structure for whole index. if yes than what does whole-index data structure contains ( does they contain all RECID'S/ROWID'S of table) Why...

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

Thanks for replying Tamhas! If SP is just PP without handle then how it could be replace with shared variables/include files. I these questions are too basic to ask but I am really confused with SPs. :( Please suggest or share relevant example/ docs. Thanks! Rajat.

Hello everyone, thanks for clearing my doubts regarding PPs! I am trying to understand SPs and how to replace shared variables or include files with SPs but stuck with few basic doubts for which I am seeking your help. I have been reading about super procedures but unable to understand the...

Thanks Tom, this is what I was looking for! :) Thanks Tamhas, MadDBA, for your cooperation on this. What I was missing there is run statement in a.p (that Tom has added) “run other.p”. I was thinking that once I make main.p as persistent (initially by a.p and get the handle) then I could...

Other.p only wants to access the handle which is being defined as shared global (in a.p) for accessing IPs of main.p. 1. Here, higher level program is a.p that starts the persistent procedure which is main.p and get the handle h1. 2. Then this handle h1 is being shared with lower level...

Thanks for replying! MadDBA, other.p is calling main.p same like a.p and want to access the IPs of main.p. Tamhas, main.p is the main procedure which is being run as persistent procedure, a.p and other.p are two different procedures who wants to access the IPs of main.p. Handle h1 is already...

Hello everyone, I have been trying different examples for clearing my concerns regarding persistent procedures and still stuck with few doubts. Here, procedure (a.p shown below) run main.p as persistent and creates one instance in memory and return value something to a.p (understood). A.P...

In one of my project, I did use 4 to 5 procedure files (.p programs) for different logic. So, I was suggested that instead of calling EPs from EPs, I should use include file (because of the same reason that I have mentioned). That’s why I thought that if calling EPs from EPs would cause any...

Tamhas, I agree that include files obscure code and IPs are very clear but isn't it time wastage (i think, please confirm) when one procedure (EP) switched to IP then content of EP (current information) is saved to call stack and later retrieved or we should think about this situation (switching...