DB2 connector> transformer > sequential file
Data will be exported into a csv format in a sequential file.
This file will be send in a email using a sequence job.
Problem here is, how to avoid sending a blank csv file?
When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
No Answer is Posted For this Question
Be the First to Post Answer
Can you filter data in hashed file?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the difference between passive stage and active stage?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
how to handle null values in sequential file?
whom do you report?
What are orabulk and bcp stages?
If the job aborted in a sequencer, how can we start that from the previews successful job.
How do you start developing a datastage project?
tell me abt Datastage trigger?
What are stage variables, derivations and constants?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know