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 …
The simplest and common way to do this would be by using the command: where $LOGFILE is an environment variable corresponding to the path to the log file to …
Below sed used to remove special characters from file. $ cat emp_new.txt Michael,10#$ Bob,20^& Smith,30@! Will,20() Joe,$30+_ $ sed -e ‘s///g’ emp_new.txt Michael,10 Bob,20 Smith,30 Will,20 Joe,30 …
In this DataStage scenario, we need to get the output as reverse letters in a given word. Input Data: almost big datastage etl navy Output Data: tsomla gib egatsatad …
