Search results

  1. Stefan

    Error Error 8030

    You are connecting to an AppService called twlappsrv on server dsc-aix-dev and then showing the propath of an AppServer called icfrepos? You need to get to server dsc-aix-dev, look at the propath in the ubroker.properties on that machine and then compare the sources on that machine with your...
  2. Stefan

    Question [SOLVED] SQL Date conversion questions - find first day of month

    The first day of a month is equal to the last day of the previous month plus one.
  3. Stefan

    Question Rename Symix Syteline forum to Infor Syteline?

    Disclaimer: this is all based on google searches and no experience with Syteline. Since Symix was already called Frontstep in 2002 when Frontstep was acquired by Mapics and Mapics was acquired by Infor in 2005, isn't it time to rename the Symix Syteline forum to Infor Syteline?
  4. Stefan

    Question Transactions and Record Scope.

    Your test does not show the relevance of queue1 and queue2, so I can only: define buffer buorder for order. do for buorder: find first buorder where buorder.orderdate < 1/1/2023 exclusive-lock. end. // cannot even reference buorder -> it cannot be available...
  5. Stefan

    Question Transactions and Record Scope.

    My eyes! :) The string functions are not necessary and both available and locked are functions that do not need brackets. {&p} "A)queue1 AVL:" avail queue1 " LKD:" locked queue1 skip...
  6. Stefan

    Question WRITE-XML ignores format given to Dataset fields

    If the specification is specifying a number with leading zeroes, then it is not a number (in the sense of XML) but a character.
  7. Stefan

    Protop SQL activity - Rec Lck

    I'll just let the knowledge base do the talking: Progress KB - Transaction Isolation Level: Proper Syntax and Definitions SQL access is very different from native access: - any triggers you have defined on your database will also not fire - index selection is different (cost based) (see...
  8. Stefan

    Protop SQL activity - Rec Lck

    See the (default) isolation level on your ODBC data source. This can be: 0 - read uncommitted 1 - read committed 2 - repeatable read 3 - serializble 0 is the only level that does not attempt to lock anything. 1 is the default, this will attempt to lock a record to see if it has been committed...
  9. Stefan

    log4j Vulnerability

    Additionally, the earlier properties / variables do not completely mitigate the issue (see Log4j – Apache Log4j Security Vulnerabilities). As stated, you should delete the problematic JndiLookup.class: zip -q -d log4j-core-*.jar org/apache/logging/log4j/core/lookup/JndiLookup.class
  10. Stefan

    How to store a GUID in a Progress database ?

    Not sure what OP's requirement was, but in a world filled with guids identifying objects, it makes sense to use the identifier as a key. For example, the SAML claim from Azure Active Directory will only provide the groups a user is a member of as guids (when not backed by a synched n on-premise...
  11. Stefan

    How to store a GUID in a Progress database ?

    Dragging up an old thread. Is character still the preferred data type for storing a uuid? Pro: easy, visible and a single field Con: spending 256 bits to store 128 bits. Since a uuid is 128 bits it could also be stored as a pair of int64s. Pro: 128 bits used to store 128 bits. Con: you...
  12. Stefan

    barcode 128

    So you downloaded the printer manual, went to chapter 6, looked up the control codes for how to print a barcode 128 and did not understand them?
  13. Stefan

    barcode 128

    When you want to print control codes, you need to use the control option.
  14. Stefan

    Question What is the most efficient algorithm for reversing a character string

    https://getproofed.com/writing-tips/grammar-tips-must-have-or-must-of/
  15. Stefan

    Question What is the most efficient algorithm for reversing a character string

    With some low level unrolled loop inspiration, I present rev5, more than two times faster than rev2! You're bound to have certain types of strings that need to be reversed, so you can handle those sweet spot lengths with an unrolled loop: function rev5 returns character ( i_c as char )...
  16. Stefan

    _proapsv process linked to the unlinked DBI- (deleted) file in Red Hat Linux

    proGetStack can help identify what that process is doing.
  17. Stefan

    READ-XMLSCHEMA and nested multi-level datasets

    Nice. I think you are running into the note section of read-xml-schema: So you will need to define / model the ProDataSet yourself.
  18. Stefan

    webspeed incoming json to temp-table

    I find that it generally helps to first model a dataset that will produce the json that you are going to be consuming: def var lcjson as longchar. define temp-table tt serialize-name 'SFItemRequest' field cust as char serialize-name 'customerNumber' field items as char serialize-name...
  19. Stefan

    Question Scratchpad Selective Amnesia

    Cool, I didn't even know that the ABL scratchpad had tabs. The lack of basic editor functionality like CTRL+F made me forget about the ABL scratchpad a long time ago. I just checked, in 12.2.5 it is still dysfunctional. Little scripts belong in source control as far as I'm concerned, anything...
  20. Stefan

    Question Progress (Schema Holder) SQL connection

    There are various knowledge base / documentation articles on DataServer performance. There are also various improvements in later OpenEdge releases for server side joins (also for DataServer).
Back
Top