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 …
No difference is there, both commands gives the same result. If we copy the file, modified time will be changed. If we move the file there will be no …
If you wonder what is dsenv file in DataStage, you can visit our previous post on dsenv file. For some ODBC connections, plug-ins, and connectors, and for interactions with …
We installed DataStage infosphere server in our windows server system with the required details. Actually we are able to run all the jobs and stages after installation except Transformer …