if ename='subbu' while running job the job should be abort how come?

if ename='subbu' while running job the job should be abort
how come?

Question Posted / kkk

3 Answers
8554 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if ename='subbu' while running job the job should be abort how come?..

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

if ename='subbu' while running job the job should be abort how come?..

Answer / datastage4you

Use the transformer stage to abort this job when empname is subbu

Thanks
www.datagenx.net

Is This Answer Correct ?

1 Yes

0 No

if ename='subbu' while running job the job should be abort how come?..

Answer / chinna

using grep command of unix we can do this

Is This Answer Correct ?

1 Yes

3 No

Post New Answer

More Data Stage Interview Questions

which unix commands mostly used in datastage

3 Answers HSBC,

1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?

1 Answers

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers HCL,

job locking methods? How can we unlock the job?

3 Answers IBM,

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers

How to get max salary of an organization using data stage stages........... can any body help me plz.......

7 Answers Cap Gemini,

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers IBM,

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers CGI,

How do you schedule or monitoring the job?

0 Answers

how can we extract data with out having any common column

7 Answers IBM, Switch2iTech,

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers

What are data elements?

0 Answers

For more Data Stage Interview Questions Click Here