IBM Datastage

IBM Datastage has a large collection of functions. This page provides the live update of function that are being implemented in CDAP Wrangler.

Jira: here, Pull Request: here, and Documentation: here.

Status	Test	Doc	Method	Returns	Implementation divergence
Done	Y	Y	CurrentDate()	LocalDate	Exact
Done	Y	Y	CurrentTime()	LocalDate	Exact
Done	Y	Y	CurrentTimeMS()	long	Exact
Done	Y	Y	CurrentTimeStamp()	LocalDate	Exact
Done	Y	Y	CurrentTimeStampMS()	long	Exact
Done	Y	Y	DateFromDaysSince2(long)	LocalDate	DateFromDaysSince will support both inputs
Done	Y	Y	DateFromDaysSince2(long, string)	LocalDate	DateFromDaysSince will support both inputs
Done	Y	Y	DateFromDaysSince(long)	LocalDate	Exact
Done	Y	Y	DateFromDaysSince(long, string)	LocalDate	Exact
Done	Y	Y	DateFromComponents	LocalDate	Exact
Done	Y	Y	DateFromJulianDay	LocalDate	Exact
Done	Y	Y	DateOffsetByComponents(DateTime, int, int, int)	LocalDate	Exact
Done	Y	Y	DaysSinceFromDate2(DateTime, DateTime)	int	DaysSinceFromDate will support both inputs
Done	Y	Y	DaysSinceFromDate(DateTime, String)	int	Exact
Done	Y	Y	DaysInMonth(DateTime)	int	Exact
Done	Y	Y	DaysInYear(DateTime)	int	Exact
Done	Y	Y	DateOffsetByDays	LocalDate	Exact
Done	Y	Y	HoursFromTime	int	Exact
Done	Y	Y	JulianDayFromDate	long	Exact
Done	Y	Y	MicroSecondsFromTime	long	Exact
Done	Y	Y	MidnightSecondsFromTime	int	Exact
Done	Y	Y	MinutesFromTime(DateTime)	int	Exact
Done	Y	Y	MonthDayFromDate(DateTime)	int	Exact
Done	Y	Y	MonthFromDate(DateTime)	int	Exact
Done	Y	Y	NextWeekDayFromDate	LocalDate	Exact
Done	Y	Y	NthWeekDayFromDate	LocalDate	Exact
Done	Y	Y	PreviousWeekDayFromDate	LocalDate	Exact
Done	Y	Y	SecondsFromTime	int	Returns 'int' rather than 'float'
Done	Y	Y	SecondsSinceFromTimestamp	long	Returns 'int' rather than 'float', additionally this method functionality is available with `SecondsSinceFromTimestamp`
Done	Y	Y	SecondsSinceFromTimestamp2	long	Returns 'int' rather than 'float'
Done	Y	N	TimeDate	String	Exact
Done	Y	N	TimeFromComponents	LocalTime	last argument is nanoseconds and not milliseconds
Done	Y	N	TimeFromMidnightSeconds	LocalTime	Exact
Done	Y	N	TimeOffsetByComponents	LocalTime	Exact
X	N	N	TimeOffsetBySeconds		Unable to implement
Done	Y	N	TimestampFromDateTime	LocalDateTime	Exact
Done	Y	N	TimestampFromSecondSince	LocalDateTime	Exact
Done	Y	N	TimestampFromSecondSince2	LocalDateTime	Exact
Done	Y	N	TimestampFromTimet	LocalDateTime	Exact
Done	Y	N	TimestampFromTime	LocalDateTime	Exact
Done	Y	N	TimestampFromTime2	LocalDateTime	Exact
Done	Y	N	TimestampOffsetByComponents	LocalDateTime	Exact
Done	Y	N	TimestampOffsetBySeconds	LocalDateTime	Exact
Done	Y	N	TimetFromTimestamp	long	renamed to EpochFromTimeStamp
Done	Y	N	WeekdayFromDate	int	Exact
Done	Y	N	YeardayFromDate	int	Exact
Done	Y	N	YearFromDate	int	Exact
Done	Y	N	YearweekFromDate	int	Exact
New	Y	N	EpochSeconds	long	New
New	Y	Y	CurrentTimestampNano	long	New
New	Y	N	NanoSecondsFromTime	int	New
New	Y	N	MicroSecondsFromTime	int	New
New	Y	N	MilliSecondsFromTime	int	New
Logical Functions
Done	Y	Y	BitAnd(long, long)	long	Exact
Done	Y	Y	BitOr(long, long)	long	Exact
Done	Y	Y	BitXor(long, long)	long	Exact
Done	Y	Y	BitCompress(String)	long	Exact
Done	Y	Y	BitExpand(long)	String	Exact
Done	Y	Y	Not(long, long)	short	Exact
Null Handling Functions
Done	Y	Y	IsNotNull	boolean	Exact
Done	Y	Y	IsNull	boolean	Exact
Done	Y	Y	NullToEmpty	Object	Exact
Done	Y	Y	NullToZero	Object	Exact
Done	Y	Y	NullToValue	Object	Exact
Done	Y	Y	SetNull	Object	Exact