Month: December 2023

​Scalar Functions
Scalar Functions for String handling (UPPER, LOWER, TRIM, SUBSTR, TRANSLATE, LOCATE)
Solving Problems:
Sorting Character Columns (case insensitive – UPPER/LOWER)
Determining rows with invalid numeric characters in a character field (TRANSLATE)
Converting or Replacing invalid characters (for example due to a wrong CCSID – TRANSLATE, REPLACE)
Left-/Right adjusting texts (TRIM, SPACE, REPEAT, RIGHT, LPAD, RPAD)
Splitting Columns (FirstName, LastName separated by a comma – SUBSTR, LOCATE)
Pitfalls when calculating with Integer Values/Columns (especially when dividing integer numbers)
Rounding Functions
ROUND – Rounding to decimal positions, rounding to 100, 1000 etc.
CEILING/FLOOR Rounding up or down to the next integer.
Example: Packing pallets – 20 Boxes on a pallet – for 102 Boxes 6 pallets and not 5 are needed
Converting between Data Types (CAST)
Date & Time Calculation
Date/Time/Timestamps 3 different data types
Converting numeric Date/Time values into real date (and vice versa)
How to convert a date like Monday 11-SEP-23 19:43 into a real timestamp?
Adding time units (Days, Hours, …) to Dates/Times/Timestamps
Adding/subtracting the same number of months may not return the start date
Subtracting two date/time values:
Why is the result ‘2023-09-10’ – ‘2023-08-08’ 102?
How to get the difference in Minutes or Days?
Date/Time Functions: DayName, Week_ISO, Last_Day, First_Day, Next_Day
Dimension Table Read More 

​Precisely Supports IBM i Systems, Expands AWS Mainframe …  Database Trends and Applications Read More 

​An exclusive webinar for Infor XA, LX and System 21 users.Inpower 23 logoFresh from presenting at this year’s inPOWER conference in Milwaukee, our ERP testing experts Carl Andrews and John McKillop hosted a webinar designed for users of Infor XA, LX, and System 21.No one looks forward to updating. We take a look at the potential impact of updates and how testing end-to-end across your entire tech landscape can make upgrading easier while ensuring business continuity.Find out how easy it is to make sure everything works as expected after every update, learn best practices and hear successful customer stories.https://originalsoftware.com/applications/infor/ Read More 

​Following the overwhelming response to our presentation at the M3 UA conference in Amsterdam, we invite you to join our Infor testing experts Carl Andrews, Michael Mochao and Tim Bower on this webinar specifically designed for users of Infor M3 and CloudSuite.You need your tech stack to work as expected after every software update, whether an Infor monthly service release, a half-year feature release or an update from an integrated application.In this session, we go further than before and guide you through exactly how to plan and execute your testing strategy. Understand how testing end-to-end across your entire tech landscape can make upgrading easier while ensuring business continuity. Learn best practices and hear successful customer stories.If you are looking to reduce the stress of releases, this is a must-watch.https://originalsoftware.com/applications/infor/ Read More 

​We couldn’t extract the content of this article. Here is the URL so you can access it:https://techchannel.com/SMB/12/2023/techtalk-smb-apis Read More