In this way we can use the cat command to concatenate the files and write them into another file. We can use rev command to reverse the word. …
Sometimes while working with the joins/lookups you may get the following warning in DataStage: EMP_NAME field is given for information purpose and it can be any column other than …
Cat command is one of the basic commands that you learn when you start your journey in the Unix / Linux world. You already know that cat displays a …
While loop statement continually executes a block of statements while a particular condition is true. Syntax for while loop in shell script is: After evaluating shell command, if the …
mtime, atime, and ctime are timestamps associated with the modification, access and change of any file in unix. A common misunderstanding is ‘ctime is file creation time’, but this …
If you are working with a job that contains hundreds of columns, sometimes we have to change some of the properties in all the columns. It is time-consuming to …
We can use the Field function in DataStage to return one or more sub strings that are located between specified delimiters in string. Syntax: Field(%string%,%delimiter%,%occurrence%,) delimiter evaluates to any …
METHOD-1: The below query will give a number of rows for the required tables but these are not accurate until we ANALYZE(gather stats) the tables. So we can not …
