Interested to Buy Any Domain ? << Click Here >> for more details...
How can we do null handling in sequential files
- 3 Answers
- 15557 Views
- Reliance, I also Faced
- E-Mail Answers
Answer Posted / phani kumar
Sequential file doesn't handle nulls. If the file contains
nulls, then it gives records while reading the file by using
sequential stage,only records which are not having nulls.
In order to handle nulls, there is a option available in
seq.file as NULL TO VALUE. Here, we can give any value for
replacing of Nulls.
Then, DS Engine will consider those symbols are nulls while
reading the data from sequential file.
Thanks and regards,
Phani kumar
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is the purpose of interprocessor stage in server jobs?
sed,awk,head
Describe stream connector?
how to export or import the jobs in .ISX file
What are stage variables, derivations and constants?
What is oci?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
what is the use of materialized view?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Explain the importance of surrogate key in data warehousing?
Explain datastage architecture?
Can you highlight the main features of ibm infosphere information server?
How and where you used hash file?
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
