Page tree
Skip to end of metadata
Go to start of metadata

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.

StatusTestDocMethodReturnsImplementation divergence
DoneYYCurrentDate()LocalDateExact
DoneYYCurrentTime()LocalDateExact
DoneYYCurrentTimeMS()longExact
DoneYYCurrentTimeStamp()LocalDateExact
DoneYYCurrentTimeStampMS()longExact
DoneYYDateFromDaysSince2(long)LocalDateDateFromDaysSince will support both inputs
DoneYYDateFromDaysSince2(long, string)LocalDateDateFromDaysSince will support both inputs
DoneYYDateFromDaysSince(long)LocalDateExact
DoneYYDateFromDaysSince(long, string)LocalDateExact
DoneYYDateFromComponentsLocalDateExact
DoneYYDateFromJulianDayLocalDateExact
DoneYYDateOffsetByComponents(DateTime, int, int, int)LocalDateExact
DoneYYDaysSinceFromDate2(DateTime, DateTime)intDaysSinceFromDate will support both inputs
DoneYYDaysSinceFromDate(DateTime, String)intExact
DoneYYDaysInMonth(DateTime)intExact
DoneYYDaysInYear(DateTime)intExact
DoneYYDateOffsetByDaysLocalDateExact
DoneYYHoursFromTimeintExact
DoneYYJulianDayFromDatelongExact
DoneYYMicroSecondsFromTimelongExact
DoneYYMidnightSecondsFromTimeintExact
DoneYYMinutesFromTime(DateTime)intExact
DoneYYMonthDayFromDate(DateTime)intExact
DoneYYMonthFromDate(DateTime)intExact
DoneYYNextWeekDayFromDateLocalDateExact
DoneYYNthWeekDayFromDateLocalDateExact
DoneYYPreviousWeekDayFromDateLocalDateExact
DoneYYSecondsFromTimeintReturns 'int' rather than 'float'
DoneYYSecondsSinceFromTimestamplongReturns 'int' rather than 'float', additionally this method functionality is available with `SecondsSinceFromTimestamp`
DoneYYSecondsSinceFromTimestamp2longReturns 'int' rather than 'float'
DoneYNTimeDateStringExact
DoneYNTimeFromComponentsLocalTimelast argument is nanoseconds and not milliseconds
DoneYNTimeFromMidnightSecondsLocalTimeExact
DoneYNTimeOffsetByComponentsLocalTimeExact
XNNTimeOffsetBySeconds
Unable to implement
DoneYNTimestampFromDateTimeLocalDateTimeExact
DoneYNTimestampFromSecondSinceLocalDateTimeExact
DoneYNTimestampFromSecondSince2LocalDateTimeExact
DoneYNTimestampFromTimetLocalDateTimeExact
DoneYNTimestampFromTimeLocalDateTimeExact
DoneYNTimestampFromTime2LocalDateTimeExact
DoneYNTimestampOffsetByComponentsLocalDateTimeExact
DoneYNTimestampOffsetBySecondsLocalDateTimeExact
DoneYNTimetFromTimestamplongrenamed to EpochFromTimeStamp
DoneYNWeekdayFromDateintExact
DoneYNYeardayFromDateintExact
DoneYNYearFromDateintExact
DoneYNYearweekFromDateintExact
NewYNEpochSecondslongNew
NewYYCurrentTimestampNanolongNew
NewYNNanoSecondsFromTimeintNew
NewYNMicroSecondsFromTimeintNew
NewYNMilliSecondsFromTimeintNew
Logical Functions
DoneYYBitAnd(long, long)longExact
DoneYYBitOr(long, long)longExact
DoneYYBitXor(long, long)longExact
DoneYYBitCompress(String)longExact
DoneYYBitExpand(long)StringExact
DoneYYNot(long, long)shortExact
Null Handling Functions
DoneYYIsNotNullbooleanExact
DoneYYIsNullbooleanExact
DoneYYNullToEmptyObjectExact
DoneYYNullToZeroObjectExact
DoneYYNullToValueObjectExact
DoneYYSetNullObjectExact
  • No labels