if ename='subbu' while running job the job should be abort
how come?
Answers were Sorted based on User's Feedback
Answer / rajesh
if inputlink.value='subbu' then call the function
DSLogFatal, which logs a fatal error and aborts the job.
| Is This Answer Correct ? | 2 Yes | 0 No |
Use the transformer stage to abort this job when empname is subbu
Thanks
www.datagenx.net
| Is This Answer Correct ? | 1 Yes | 0 No |
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
What is the differentiate between data file and descriptor file?
When we will go for Data elements?
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
What are constraints and derivations?
How do u set a default value to a column if the column value is NULL?
How to transfer file from one system to another system in UNIX?which command to be use?
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
types of errors in datastage?
How to reverse the string using unix?