Search results

  1. Rob Fitzpatrick

    OUTPUT STERAM WITH UNIQUE FILE NAME

    Hi Hassam, and welcome. :) You are alluding to problems (and perhaps error messages?) without stating explicitly what they are. A robust problem definition is essential for finding the appropriate solution. This will create a file with the name "cFileName". You want to output to VALUE(...
  2. Rob Fitzpatrick

    How to determine if a procedure was passed a file to standard input when run via the command line

    In that case, you should explore your error-handling options. Progress Documentation For starters, try adding NO-ERROR to your IMPORT, and check for errors via the ERROR-STATUS system handle before you proceed further.
  3. Rob Fitzpatrick

    How to determine if a procedure was passed a file to standard input when run via the command line

    It sounds like you want to conditionally read the contents of a file. But I'm not sure, as you are stating your chosen solution rather than the problem you are trying to solve. I didn't know this type of input was possible for an OpenEdge client. It's an interesting curiosity but I wouldn't...
  4. Rob Fitzpatrick

    Question What is the best way to connect mysql db from Openedge Application running on Linux Server?

    Depending on your release, you might be able to use DataServer for ODBC. However that is not a long-term solution as that product has been discontinued as of 11.6.
  5. Rob Fitzpatrick

    Question The server or the system has no more resources . Try a larger -n

    Ok, now the picture is becoming clearer. The -n 300 and -Mn 10 together determine the total number of database connections available: 312. The calculation is -n + -Mn + 2. This is all connections: primary broker, servers (up to 10), secondary brokers, remote clients, self-service clients...
  6. Rob Fitzpatrick

    Question The server or the system has no more resources . Try a larger -n

    This is error 748. It is not necessarily caused by -n being too low. There are lots of KB articles that describe how to diagnose this situation. "]Progress Customer Community Progress Customer Community Progress Customer Community Progress Customer Community Progress Customer Community Which...
  7. Rob Fitzpatrick

    Dynamic-Tables and static queries

    You rephrased it slightly without clearly explaining what is going on, which doesn't help my comprehension. Present tense. Future tense. I can't tell from this what your application looks like now or what you intend it to look like in the future. Maybe if you actually showed some code and...
  8. Rob Fitzpatrick

    Dynamic-Tables and static queries

    "The temp-table is in the database" doesn't make sense to me. Database tables are in the database. Temp-tables are client-side. Do you mean that data that you previously wrote to and read from a static temp-table will now reside in a database table? And that you are going to cache that...
  9. Rob Fitzpatrick

    Looking for books

    If you're hankering for a mix of DB internals and nostalgia, you might enjoy the venerable Engine Crew Monographs, while they're still available: Engine Crew Monographs
  10. Rob Fitzpatrick

    Looking for books

    I'm aware of those publications, though they are a bit before my time. The challenge with old documents/books is that, although they may have been well laid out and well written to cover the subject matter of their day, the platform has moved on. Yes, some fundamental aspects of ABL remain...
  11. Rob Fitzpatrick

    OpenEdge discontinued on AIX

    I believe it was just a numbers game. Every AIX migration I saw in the last several years was from AIX, not to AIX. Yes, lots of people have been on it for years and don't want to migrate. But ultimately this is a business decision. Every additional platform that a vendor supports increases...
  12. Rob Fitzpatrick

    ABL Dojo

    I've never heard any discussion of open-sourcing it. I wouldn't expect that to happen as long as the compiler is a commercial product. At a high level, the Dojo is a web-based ABL scratchpad connected to a DB. You can get more or less the same functionality with the scratchpad in PDSOE.
  13. Rob Fitzpatrick

    Add new variable database extent and give previous var extent a fixed size

    I didn't see a mention of Workgroup in this thread... And in my opinion, Workgroup RDBMS shouldn't be used for real application environments unless their DB size is trivial and add-ons are largely unneeded. I wouldn't call >28 GB trivial. I second that.
  14. Rob Fitzpatrick

    Locking Scope with External Procedures

    That is correct, though that is not how I would word it. I'm not an expert on such things but here is my understanding: What is being released directly by a RELEASE statement is the contents of a record buffer, not a record lock. Note the wording of the documentation that you quoted...
  15. Rob Fitzpatrick

    Add new variable database extent and give previous var extent a fixed size

    Yep. :) While you're down, it's a good time to think of anything else you may want to do that requires downtime, to avoid a later shutdown. E.g.: proutil dbname -C updateschema and updatevst, if you haven't done them since your last DLC install/service pack. Set...
  16. Rob Fitzpatrick

    Add new variable database extent and give previous var extent a fixed size

    Then that explains keeping your extents at no more than 2 GB! But with a modern (21st century) OS and OE 11, there is no reason not to have large file support enabled. You can do this the next time you shut down your database. proutil dbname -C enablelargefiles
  17. Rob Fitzpatrick

    Add new variable database extent and give previous var extent a fixed size

    If you have database feature 5 enabled, you have large file support: extents can grow up to 1 TB instead of 2 GB. E.g.: Database Features ID Feature Active Details ---- --------------------------------- ------ ------- 5 Large Files...
  18. Rob Fitzpatrick

    Add new variable database extent and give previous var extent a fixed size

    When asking questions about OpenEdge capabilities, it is important to say which release you are using. Yes. You can do this in OpenEdge 12.1+: Extend and mark variable-length extents as fixed—Database administrators can now extend and mark variable-length extents as fixed as well as create...
  19. Rob Fitzpatrick

    Rant about CDC/Pro2

    That's the dev version of Classic App Server. It includes the compiler.
  20. Rob Fitzpatrick

    Rant about CDC/Pro2

    I think the problems you have described above are symptoms of a larger issue: for the most part, Progress Software doesn't use OpenEdge. So they lack a vital internal feedback loop and the benefits it would bring to feature design and support. Unfortunately, this is the result of my point...
Top