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
In merge stage can we update the values?
how can you generate sequence number using only the sequential file stage?
If you want to use the same piece of code in different jobs, how will you achieve it?
source file is having 5 records while moving into target it want to be 10 records
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
How do you import and export the datastage jobs?
Define project in datastage?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
options available in sequence job to run,validate?
How to read the length of word in unix?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
How to Remove Duplicate using SQL?