Search results

  1. G

    Why Find schema trigger will execute before session trigger?

    I want understand what is the reason behind in case of find Normally triggers will execute first session and schema level for create,delete,assign,write except find trigger on same table In case of find trigger first schema and session will execute can you please explain or give example is...
  2. G

    Why Find schema trigger will execute before session trigger?

    Hi, Can any one explain Why Find schema trigger will execute before session trigger? if find trigger defined in schema and session level.
  3. G

    Example of IN super for procedure and function

    inproc internal procedure is there in main.p and sub.p programs, after added sub.p as a super-procedure in main.p. in this case how to use IN SUPER Keyword ? please explain ? /* main.p */ define var hdl as handle. run sub.p persistent set hdl. this-procedure:add-super-procedure(hdl). run...
  4. G

    Example of IN super for procedure and function

    Hi, cane any one give me example of IN SUPER for internal procedures and functions, how to use
  5. G

    Share-lock Significance

    Thanks for your answer. i hope you explained for batch jobs ryt. if it is possible can you provide with one sample example program to understand clearly.
  6. G

    Share-lock Significance

    Hi, Can any one tell me what is the significance of Share-lock and give me some example where it is used?
  7. G

    for each will behave like free reference?

    Thanks for reply.
  8. G

    for each will behave like free reference?

    @Cringer you are correct. but my question is in that code it is raising the buffer scope and transaction scope in procedure level due to update statement, its behaving like free reference. so can we say for each also behaving like free reference in such situations?
  9. G

    for each will behave like free reference?

    Hi, i am able to see procedure level buffer scope and transaction scope in below code for each customer exclusive-lock: end. update name. can any one explain can we say for each also free reference in some situations like in above scenario. ...\Practise\scope.p 09/13/2019...
  10. G

    Transaction is active or not in application level

    Thanks Rob for explanation, if some one ask should i say transaction is not active still transaction function return true in application level until unless changes on the database level.
  11. G

    Transaction is active or not in application level

    Hi, Help me regarding my doubt. transaction is active or not in below block query? for each customer exclusive-lock: ---<no update or assign statements> end. when i checked with "transaction" keyword inside block its saying as "yes", but _Trans (VST) table "_Trans-state" showing as nothing...
Top