Recent content by Patrice Perrot

  1. P

    Question How do i know its a valid directory and how i can know the handle belongs to a temp table

    FILE-INFO:FILE-NAME = cipDir . IF FILE-INFO:FULL-PATHNAME <> ? AND INDEX(FILE-INFO:FILE-TYPE, "D") > 0 THEN //The input directory is valid Else // The input directory is NOT valid
  2. P

    Question Ampersand befor open

    It rings me a bell when you use a browse in the UIB you could have {&OPEN-QUERY-BROWSE-2} Which is related to the browse browse-2 define several lines above in your code /* Definitions for BROWSE BROWSE-2 */ &Scoped-define FIELDS-IN-QUERY-BROWSE-2...
  3. P

    Concatenating Different Records

    You can also test if the new order find (order2 in the do while) is in the list of the previous order (cCombinedOrder). The Marco's N value is still interresting to avoid the error on 32K.
  4. P

    Concatenating Different Records

    Rob is correct. It could be interresting for you to use the Temp-table to avoid this side effect. have a look at the source code attached , I did not test it , but it could be a clue / starting point
  5. P

    Concatenating Different Records

    It is up yo you... It could be display or output, it depends of your needs
  6. P

    Concatenating Different Records

    Hi You could have a look at source code attached . I am not able to insert it in the post as code . Patrice
  7. P

    Concatenating Different Records

    Hi, You should store/record the cCombinedOrder and set it to "" after each "Do while " <code> DEFINE BUFFER order2 FOR order. DEFINE VARIABLE iOrderDetail as INTEGER INITIAL 0. DEFINE VARIABLE cCombinedOrder as CHAR INITIAL "". define temp-table tt No-undo field first-order as INTEGER...
  8. P

    Concatenating Different Records

    HI You have a bug In this line "FIND order2 NO-LOCK WHERE Order.Number = iOrderDetail NO-ERROR." You should have "FIND order2 NO-LOCK WHERE Order2.Number = iOrderDetail NO-ERROR. " Patrice
  9. P

    Question Import Data volume increase to 300,000 causing DB updates to almost halt after updating 38000 records - Progress 11.7 Windows client - Linux db server

    Hi I notice several potential performance issue on code like "for each ttcustomer where not ttcustomer.found" . Even if there is an index on the field found , the request will not use it = > Whole-Index. You should have "for each ttcustomer where ttcustomer.found = false" You could have a...
  10. P

    How Index Reads are More Than Table Reads

    You can also try this code , you will have no read on orderline but 100 on its index. <code>def var ii as int no-undo. def var iord as int no-undo. do ii = 1 to 100 : for each order no-lock where...
  11. P

    How Index Reads are More Than Table Reads

    The request stops to read the index and the records when the value of this index does not respect the value of the index you specify For example ; for each order where custnum = 10 no-lock , the process will stop to read the data when it find an index with custnum > 10 for each customer...
  12. P

    How Index Reads are More Than Table Reads

    Hi , It is OK that you read one index more than records on each part of your query (the last one , to show it does match your index key) 83 records on customer => 84 read on index 207 order + 83 request => 290 read on index 873 orderline + 207 request => 1080 read on index. If the read on...
  13. P

    Unable to start DB if -Mn*-Ma > 1024

    Hi I have some issue with high -n on older release of Progress when the "-shmsegsize " was too small. Could you try to start your db with the line below proserve sports -S 13000 -n 1606 -Mn 42 -Mpb 40 -Ma 32 -Mi 5 -shmsegsize 2G -minport 18500 -maxport 22000
  14. P

    Unable to start DB if -Mn*-Ma > 1024

    Hi , I have no issue with "-Mn 42 -Mpb 40 -Ma 40" . proserve dbnewdb -N TCP -S 4.... -n 1606 -Mn 42 -Mpb 40 -Ma 40 -Mi 5 OpenEdge Release 10.2B0830 as of Mon Feb 16 03:35:45 EST 2015 09:26:47 BROKER The startup of this database requires 70Mb of shared memory. Maximum segment size is...
  15. P

    Question Copy replication trigger assignments.

    Hi , Ron, i do not think this is your case (CDC was considered at length but it caused problems for us), but others could be interresting to know this If you are not avail on the record creates , instead of doing. Create newrecord. Buffer-copy sourcerecord to newrecord. You could do...
Top