NULLS
Moderators: chulett, rschirm, roy
NULLS
Hi,
In my source csv file, I am getting some nulls without quotes ...DataStage is writing it to a seq file as a "?" instead nulls..Why is this happening..? I am using a after-job subroutine shell script to scrub "?' to NULLS..but I would like to know the reason and try to resolve it in the beginning...
any clues..?
Thanks
In my source csv file, I am getting some nulls without quotes ...DataStage is writing it to a seq file as a "?" instead nulls..Why is this happening..? I am using a after-job subroutine shell script to scrub "?' to NULLS..but I would like to know the reason and try to resolve it in the beginning...
any clues..?
Thanks
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Do you mean Default NULL padding...I leave it blank...
Here is how it is happening...
File1 is read and written to File2 -- File 1 has some nulls..written as nulls in File2.. so far fine
Again, in next job, File 2 is read and written to File 3--- here the Nulls in File 2 are wriiten as "?" in File 3...
in the same way, in some other scenarios:
nulls without quotes in csv files are read as nulls but written as "?" in o/p files..looks weired..
any idea from this...pls?
Here is how it is happening...
File1 is read and written to File2 -- File 1 has some nulls..written as nulls in File2.. so far fine
Again, in next job, File 2 is read and written to File 3--- here the Nulls in File 2 are wriiten as "?" in File 3...
in the same way, in some other scenarios:
nulls without quotes in csv files are read as nulls but written as "?" in o/p files..looks weired..
any idea from this...pls?
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm