error while populating date value from seq file to oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 am
error while populating date value from seq file to oracle
Hi all
I am trying to load a column which is of date datatype
i had encounter this error
can any one share your views what might be the mistake
Error message :
ob1..Transformer_1: At row 1, link "DSLink4", while processing column "datett"
Value treated as NULL
Attempt to convert String value "22-nov-04" to Date type unsuccessful
I am very much clear that i had to use Iconv & Oconv function to convert this into valid date format
but still i am facing the problem
Kindly help me out
Thanks in advance
RK
I am trying to load a column which is of date datatype
i had encounter this error
can any one share your views what might be the mistake
Error message :
ob1..Transformer_1: At row 1, link "DSLink4", while processing column "datett"
Value treated as NULL
Attempt to convert String value "22-nov-04" to Date type unsuccessful
I am very much clear that i had to use Iconv & Oconv function to convert this into valid date format
but still i am facing the problem
Kindly help me out
Thanks in advance
RK
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You seem to have an offset issue - I can see the date in the timestamp. However, you have not provided your entire derivation - for example how does the time component get there?
Try doing one piece at a time, to see where the problem is actually occurring. Just Iconv() first, which should yield a signed integer. Then Oconv(). Then feeding it to Oracle.
Are you using generated or user-defined SQL?
Try doing one piece at a time, to see where the problem is actually occurring. Just Iconv() first, which should yield a signed integer. Then Oconv(). Then feeding it to Oracle.
Are you using generated or user-defined SQL?
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: 107
- Joined: Wed Sep 29, 2004 10:15 am
Thanks ray for your response
my intention is to store the date value into the database
i had tried with changing the data type of date column from timestamp to date
but still i am unable to populate the date value into table
i had redirected the output to a flat file and it is having this data
1,22-Nov-2004
and my source file is like this
no,"date"
1,"22-nov-04"
my code is :
Oconv(Iconv(DSLink3.date,"D-DMY"),"D/DMY[2,2,4]")
kindly guide me
Thanks in advance
RK
my intention is to store the date value into the database
i had tried with changing the data type of date column from timestamp to date
but still i am unable to populate the date value into table
i had redirected the output to a flat file and it is having this data
1,22-Nov-2004
and my source file is like this
no,"date"
1,"22-nov-04"
my code is :
Oconv(Iconv(DSLink3.date,"D-DMY"),"D/DMY[2,2,4]")
kindly guide me
Thanks in advance
RK
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 am
thanks for your valid response
i had resolved my problem
the Oconv conversion format is wrong
i had tried with this code
Oconv(Iconv(DSLink3.date,"D-DMY"),"D/YMD[4,2,2]")
and it worked as i changed the date column datatype as timestamp
if any chance can anybody throw me a light that how can i load the date values using date as my target datatype column
Thanks in advance
RK
i had resolved my problem
the Oconv conversion format is wrong
i had tried with this code
Oconv(Iconv(DSLink3.date,"D-DMY"),"D/YMD[4,2,2]")
and it worked as i changed the date column datatype as timestamp
if any chance can anybody throw me a light that how can i load the date values using date as my target datatype column
Thanks in advance
RK
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: