i want job aborted after some records are loaded into output
by using only sequential stage and dataset
Answer Posted / guest
HI Friend,
Use constraint in transformer stage by selecting abort after
rows column and mention the no.of rows to be rpocessed, then
after those many rows job will abort.
Thanks,
Hanumantha Rao.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are orabulk and bcp stages?
What are routines in datastage?
Have you used Unstructured data?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Where do the datastage jobs get stored?
To see hidden files in LINIX?
Differentiate between datastage and datastage tx?
What is oci?
What is the use of datastage director?
What is ibm datastage?
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
What is job control?
How you can fix the truncated data error in datastage?
What is active and passive stage?