Search results

  1. erickroco9611

    Changing the FORMAT of a field causes CRC Error?

    Hi... I got a doubt. Is there any CRC Error only if I change the FORMAT in a FIELD in the Database Schema? I would like to extent the length of some CHARACTER FORMAT, but I wouldn't like to shutdown my Database only to do this. Well... Maybe is a clumsy question, but maybe it can prevent a...
  2. erickroco9611

    What does it mean "Dead Transaction"? How to avoid?

    Hi again... I don´t know if this post would be better in DBA or Development, but I'm a developer so... I was looking for some issues in my database with PROMON and I found that some Transactions has a flag as "DEAD". The law (Progress) said: "When the "Tran State" is DEAD it signifies the...
  3. erickroco9611

    Using NO-PREFETCH improve performance?

    Well... I´ve developed some programs that works among them in diferent servers, even separated for a long distance (Diferent States). I use this only for transport (I know that there´re others ways like Plain File or XML)... anyway!! I use this for transport information across the Company´s...
  4. erickroco9611

    How is BEST PRACTICE in a FOR EACH sentence?

    Which is BEST PRACTICE...!!?? for each po where po.whs-code = "10" and po.cust-no >= 1000 and po.cust-no <= 9999 and po.dt-cancel = ? no-lock: .... [PROCESS]... end. OR for each po where po.whs-code = "10" and po.cust-no >= 1000 and po.cust-no <= 9999 no-lock...
  5. erickroco9611

    Index question

    Thank You very much Tom... The example was very "CLUMSY" as you can see... but you really solve that question... Now... You tell the Compiler Selects the best INDEX isn´t it? I have a question for you... Which is BEST PRACTICE...!!?? for each po where po.whs-code = "10" and...
Top