how to find no.of records in sequntial file itself?
Answer Posted / mandru naganji
in seq file set row number column and it will generate data like 1 to n depending onm num of rows.use sort satge desc order get last record.u will get count
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to write server Routine coding?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the difference between datastage and datastage tx?
How to convert RGB Value to Hexadecimal values in datastage?
What is the use of datastage designer?
What are the some differences between 7.x and 8.x version of datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are the different plug-ins stages used in your projects?
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 are the types of containers and how to create them?
Name the third party tools that can be used in datastage?
What is the differentiate between data file and descriptor file?
Difference between sequential file and data set?
What is the difference between an operational datastage and a data warehouse?
Can you explain how could anyone drop the index before loading the data in target in datastage?