New connection
New IBM DB2 connection
Description The connection to IBM DB2 enables users to create, get and update records to manage and define databases. Purpose The primary goal of the connection to IBM DB2 is to perform various activities within workflow and access the data stored within these tables/views/Stored Procedures by select the databases the user intend to utilize. To learn more about the IBM DB2 connection click here.New functions
New Date & Time functions
Description Our Date & Time Functions suite stands as a versatile toolkit, empowering users to craft dynamic and time-sensitive workflows within our system. In addition to the existing functions, we’re introducing new capabilities to further enhance your temporal data management. New Functions- date(year,month,day): Creates a timestamp from the specified year, month, and day.
- dateTime(year,month,day,hours,minutes,seconds (optional)): Creates a timestamp with optional seconds.
- year(datetime): Extracts the year component from a timestamp.
- month(datetime): Extracts the month component from a timestamp.
- day(datetime): Extracts the day component from a timestamp.
- hour(datetime): Extracts the hour component from a timestamp.
- minutes(datetime): Extracts the minutes component from a timestamp.
- seconds(datetime): Extracts the seconds component from a timestamp.
- DayOfWeek(datetime): Returns the day number of the week from a timestamp.