Search results

  1. P

    Buffer with no-lock

    Hi All, hope you are doing well ! I know the use of Strong Scope with Exclusive-Lock but what should we do in case of find statements with no-lock. Example below: 1. Result is Yes. define variable lCheck as logical no-undo. if lCheck then do: find first table no-lock no-error. end. message...
  2. P

    How to Query Longchar

    Hello Guys, hope you all are doing well. I have a Longchar variable that contains JSON data of 4 fields. I want to write a query and compare these longchar variable values with DB table/fields. For Example: My Longchar variable contains below json data, I want to compare these JSON key : value...
  3. P

    ROWID on Dynamic Table

    Hello Guys, hope you all are doing well. Please suggest how can we use dynamic table name or a variable having table name in ROWID function. I am extracting table name from a string and need to get it's ROWID. Regards,
  4. P

    Table Name - Trigger Procedure

    Hello Guys, hope you all are doing well. My question is very basic but I am not getting any lead on this. I want to know the Table Name in trigger procedure and don't want to hardcode this. Requirement: Need to implement a generic program for trigger procedures of all tables. If I hardcode...
  5. P

    Table Data Records

    Hello Guys, hope you all are doing well. Could you please suggest how to do WRITE-JSON from a dynamic temp-table? CREATE TEMP-TABLE hTemp. hTemp:ADD-FIELDS-FROM(hBuffer,_field._field-name). hTemp:TEMP-TABLE-PREPARE("ttDelete"). hDefault = hTemp:DEFAULT-BUFFER-HANDLE...
  6. P

    Dump of Deleted Records

    Hello Guys, hope you all are doing well. We need to dump all deleted records into a file (can't do changes in existing programs). We don't have CDC (change tables) and any other tool for this. We need to implement a solution for this. Please suggest what could be the best way to do so...
  7. P

    How Index Reads are More Than Table Reads

    Hi All, hope you all are well! I am trying to check table and index reads/writes for my queries by using "-tablerangesize, -indexrangesize" db startup parameters but index reads are displaying more then table reads. Below is one small example: def var icust as int no-undo...
  8. P

    SSSSSSSSSSSSSSSS

    SSSSSSSSSSSSSSSSSSSS
  9. P

    Comparison Among All Data Replication Methods

    Hi All, I want to understand which data replication method is more economical to implement. Below are couple of methods (AFAIK):- 1. Pro2 Pros - Real Time replication Cons - Paid Tool, big cost to company for each license 2. CDC Pros - Real Time replication Cons -...
  10. P

    FOR EACH Vs FOR FIRST in Record Scoping

    Hello Guys, hope you all are well. I was surprised to see that For First behaves different from For each. Each iteration of For each is a transaction (in X lock) and after end of For Each, record scope is not available. But with For First, scope is available and lock is downgraded to Shared...
  11. P

    Field Information From Tracking Table

    Hello Team, hope you guys are doing well !!! I want to fetch field level information from _cdc-tracking-table that which field is being changed by using _Field-Map field. I tried writing code for this but getting useful information. Please help me here if you have some idea regarding this...
  12. P

    Log Manager - All Handles are Documented or NOT

    Dear All, We have n number of dynamic objects in progress and almost all (except persistent) can be handled by widget pool. I want to ask you guys, does all these dynamic handles are well documented in Log-Manager as well so that if required then we can walk-through the logs and mark an object...
  13. P

    Auditing Tables Are Not Getting Updated

    Hello All, Hope you all are Well !!! I have added auditing area’s and enabled auditing for sports database. I added policy form Audit policy maintenance (Appbuilder) and policy is active as well. I have exported policy XML file and attached here for reference. Customer table and it's fields...
  14. P

    New Database

    Hello All, hope you all are well!!! I have created new database and trying to access it's features from OpenEdge Explorer but unable to do so and getting message as Cannot connect. Below is screen shot for your reference, please suggest how to resolve this. Regards,
  15. P

    Change Data Capture

    Hello Guys, Hope you all are going well!!! I am working on change data capture functionality (version 11.7 and above) and able to do the basic setup with tracking, policy and cdc_table-name tables. In CDC documentation, it’s been mentioned that “Multi-threading” is available in CDC when it’s...
  16. P

    Question Called Program Name

    Dear All, hope you all are doing well :) This post is regarding creator external procedure (.P) of dynamic handles. We have multiple types of dynamic handles in progress and we can get its creator name with the help of INSTANTIATING-PROCEDURE attribute but only when creator .P is there in...
  17. P

    Unable to Display Dynamic Object Names

    Dear All, By using handle, I am trying to find the name of PSEUDO-WIDGET, FRAME, TEXT and FIELD-GROUP type dynamic handles. I am able to get the handle type by using "Handle-name: TYPE" but not able to get name of these dynamic objects. I am trying to get the name of these objects by using...
  18. P

    Multiple Scripts - Issue

    Dear All, I am trying to run multiple UNIX scripts (.sh files) via INPUT THROUGH in Progress program (.P). Below code gets called multiple times and with updated full path of shell script in Script-file. INPUT THROUGH (Script-file) NO-ECHO. IMPORT file-name. INPUT CLOSE. I am able to run...
  19. P

    Tracking of All Handles – Memory Level

    Hello All, I am trying to catch all dynamic objects (handles) in server memory (UNIX), memory walkthrough. I thought to create one script to list all handles (Progress) available in memory and depending on certain condition, delete that handle. I created one small dynamic query program and I...
  20. P

    Dynamic Query

    Hello All, I have two databases and I want to compare table by table and records by records on the basis of unique index/key only and later I have to record the changes found. I know it can be done by using some dynamic query only (have very less idea of that), I tried to create dynamic query...
Top