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
What are the types of containers in datastage?
source file is having 5 records while moving into target it want to be 10 records
What are the enhancements made in datastage 7.5 compare with 7.0?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..
What are the stages in datastage?
table actions available in oracle connector?
How can u write exception handling in seq file????
Can you explain how could anyone drop the index before loading the data in target in datastage?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
How can we improve performance of data stage jobs?
Describe stream connector?
which unix commands mostly used in datastage