Interested to Buy Any Domain ? << Click Here >> for more details...
What is $mpjret? Where it is used in ab-initio?
- 4 Answers
- 21496 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ananya
$mpjret is the graph execution status return value.
It can be used in end script of a graph.
Ideally the value of $mpjret should be 0(zero).
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / anne
$mpjret is a variable declared in the end script which
returns the value of the execution of the graph.
Its very simalr to the $? in unix
the above command returns the value 0 ot 1
0-success
1-failure
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / pkr
we can use $mpjret in end script like this:
if 0-eq($mpjret)
then
echo"success"
else
mailx-s"(graphname)failed" mailid.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / avijit
$mpjret only works if you want to use it in the graph end script .
But if we want the return status in case we are running the graph from the back end it will not work.
If you are writing Unix shell script then use:
air sanbox run graph.mp
if [ $? –eq 0 ]; then
echo "Graph Failed"
| Is This Answer Correct ? | 1 Yes | 0 No |
what are kinds of layouts does ab initio supports ?
What is the difference between sandbox and EME?
What would be the next step after collecting the data?
What is conditional DML and Structured DML?
What is regex (lookup)? When you should use it?
What information is provided by .dbc file extension for connecting to the database?
Can we specify checkpoints without Phases?
can we perform checkin and checkout through sandbox?
Can anyone give me an example of realtime start script in the graph?
What mpjret contains ? How to use in abinitio graph?
What will be the output of using partition by Round-Robin after the partiton by key in ab initio?
i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do we make single a1b2c3d4 and 4 different rows a1, b2, c3,d4.
Teradata 
