Hi,
When I converted my target DRS to a userdefined SQL and when I used %DateIn to a Date field, Data Stage is not taking the same. If I use a %Substring, it is taking. This issue occurs in DB2 OS390. If I won't use this ,Datastage is giving an error Inserted value too larger for the column since the target will accept only date and not the time.Does anyone have any suggestions?
Cannot append %DateIn Metatags to target DRS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 16
- Joined: Sun Apr 17, 2005 11:27 pm
-
- Participant
- Posts: 16
- Joined: Sun Apr 17, 2005 11:27 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What is the precise data type of this column in the database table? Date or TimeStamp? Different databases handle this differently - some (such as Oracle) don't differentiate, while others do. What this means mostly is that you can't assume that what works with one database will work with another. DRS has the terrible tendency to do things the Oracle way. Have you considered using a DB2/UDB stage?
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: 16
- Joined: Sun Apr 17, 2005 11:27 pm
Ray,
I using a normal DRS and my Job should work independent of the databases(Oracle/DB2/SQL Server).The issues I quoted is DB2 specific and there the undelying datatype is Date.But while passing the value to the target, the DRS automatically takes the time part.That is why I am using the Metatag and making the target as userdefined one.
Thanks,
Poornima.
I using a normal DRS and my Job should work independent of the databases(Oracle/DB2/SQL Server).The issues I quoted is DB2 specific and there the undelying datatype is Date.But while passing the value to the target, the DRS automatically takes the time part.That is why I am using the Metatag and making the target as userdefined one.
Thanks,
Poornima.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: