Hi all
source Sequential file field is Double, Length not given
Target sequential file Field is Date and length is 8
it is a 1:1 mapping
I used the below code for conversion,It's giving null value
StringToDate(DecimalToString(DFloatToDecimal(DSLink2.a),"suppress_zero"),"%yyyy-%mm-%dd")
please help me.
Thanks
sundar
type conversion
Moderators: chulett, rschirm, roy
type conversion
try using
DfloatToStringNoExp
and then string to date.
Regards
Ashwin
DfloatToStringNoExp
and then string to date.
Regards
Ashwin
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
An import error occurs in an importing stage, not in a Transformer stage. It has no relationship, therefore, to the function you have described. Inspect the generated OSH, determine which stage generates an import operator. Add a rejects link to that stage, leading into a Peek stage so you can see what data are causing the import error.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In stage seq1 make sure that (a) the field in question is declared as nullable and (b) that you have specified either a null field value or a null field length property for it. It's the lack of one of these properties about which the error message is complaining.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.