Search results

  1. TomBascom

    Getting details from AI Files

    You might find this helpful: Session: Inside The OpenEdge RDBMS: After-Image Log Records And Their Uses Speaker: Gus Bjorklund Excerpt: In this talk we will open the bonnet on the topic of After-Image Journaling and Recovery Log Records (aka “Notes”). We will describe what they are, what they...
  2. TomBascom

    better way to delete 5millions rows

    One potentially valid reason to delete data is that retaining records beyond your required legal responsibility may expose you to a requirement to produce those records in legal proceedings. If your company has a record retention policy for that reason then you should certainly follow that...
  3. TomBascom

    better way to delete 5millions rows

    NO! YOU DO NOT WANT TO USE THE -i PARAMETER! That is suicidal when updating a production database. If *anything* goes wrong - like the error below, you are in an UNRECOVERABLE state if you used -i. You might also want to post a bit more than "delete where" as a code snippet. Having said that...
  4. TomBascom

    Question How Pass Stream As Parameter

    The stream isn't shared among sessions so "deadly embrace" really doesn't come into play. More likely is that if you have multiple sessions writing to a single log file you will get "blended" log content. IOW lines that are overwriting and interspersing one another. Especially if you open your...
  5. TomBascom

    Question Performance question on a tool library

    Indeed I can. I was amused. And chastised.
  6. TomBascom

    Question Performance question on a tool library

    Bigger fish to fry in the code purity campaign?
  7. TomBascom

    Question Performance question on a tool library

    Also... your title says "performance question"... but if you are asking something about performance I am failing to see it.
  8. TomBascom

    Question Performance question on a tool library

    I'm kind of old-school so I still create my libraries as persistent procedures that set themselves to be session super procedures, i.e. session:add-super-procedure( this-procedure ). when they are instantiated. I have recently decided to take steps to explicitly ensure that only one copy of...
  9. TomBascom

    Question Electronic signature

    First you need to define your requirements. “It” is just a little vague…
  10. TomBascom

    Question The open database table is full

    I think that you should probably be talking to Gilles @ Riverside to determine how to configure PCT for your purpose.
  11. TomBascom

    Question The open database table is full

    Have you increased -h yet?
  12. TomBascom

    Report Builder error - character field no longer in table

    That sounds like you have corrupted data feeding that drop down. Unfortunately I know nothing about Report Builder and how it is configured so that's about all that I can say.
  13. TomBascom

    Report Builder error - character field no longer in table

    The field name really starts with "?"?
  14. TomBascom

    Site registration seems to be broken

    You’d have thought wrong
  15. TomBascom

    Site registration seems to be broken

    I did. He has no magic key either.
  16. TomBascom

    What Is Meaning Here Order 20 And Order 30

    As TheMadDBA points out above- it will also impact the order of fields in EXPORT and IMPORT statements.
  17. TomBascom

    Site registration seems to be broken

    Got a reply: > I no longer actively monitor this email address, chris.kelleher@me.com
  18. TomBascom

    Site registration seems to be broken

    Until just now I did not have that email in my contacts. I have now sent a note to him.
  19. TomBascom

    Site registration seems to be broken

    I am told that site registration is not working. FWIW -- I, personally, have no ability to do anything about that. I also lack a means of contacting the site owner. The best that I can do is to post this and hope that he sees it.
  20. TomBascom

    What Is Meaning Here Order 20 And Order 30

    ORDER is logical, and can be changed, POSITION is physical and cannot be changed.
Back
Top