Returns the week number in the year from the given date Input: date Output: week (int16) Examples. If mylink.mydate contains date 2013-12-28, then the two following functions are equivalent, …
This is the basic concept we need to learn after code/develop DataStage jobs. In this post, I will explain how to export the jobs from one datastage server and …
“RDBMS code 6706: The string contains an untranslatable character.” Did you get this type of error in DataStage while loading data into Teradata or any other database. If yes, …
Buffering could be a technique used in the DataStage jobs to make sure a constant and uninterrupted flow of data to and from stages in such a way that …
Or Read also: Unix interview questions and answers part – 1 The basename command deletes any prefix ending in ‘/’. This will display only file name. Or Read also: …
Returns the year from the given date. Input: date Output: year (int16) Examples. If mylink.mydate contains the date 2013-08-21, then two following functions are equivalent, and return the value …
Returns the day number in the year from the given date. Input: date Output: day (int16) Examples. If mylink.mydate contains the date 2008-08-20, then two following functions are equivalent, …
Returns the day number of the week from the given date. Origin_day optionally specifies the day regarded as the first in the week and is Sunday by default. Input: …
