Data Truncates While Writting to DB(SQL Server)
Moderators: chulett, rschirm, roy
What is the purpose of the Transformer stage? Can you add a Sequential output and verify the results are correct?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is not a premium support site. Folks post as and when they can. Don't push. If you want urgent answers, sign up for premium service with your support provider, and learn the true cost of urgent.eze_ke wrote:Hey guys no one has suggestions nor has come accross like this
please Suggest
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.
eze_ke, for my installation of SQL Server, I am having the same problem but I am using DRS stage. It is happening with one clumn, state_cd. It is a 2 character column. No matter what combination of data types I try on SQL Server side or DRS stage side (Datastage), the 2nd character gets cut off. I even tried adding blank characters to the right. Same problem!
Ok. I think I have found a solution eventhough it is really iffy. DRS stage cuts off the last character from character columns. ODBC Enterprise stage cuts off the first character. Right before the DRS stage, you have to add a transformer where you have add a character to the right of the character column which get cutoff. You also need to increase the length of the character columns by 1. This worked for me. This same technique does NOT work for the ODBC Enterprise stage. Also, you cannot use BigInt during integer column load. You have to int.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
yes. As stated in the codbccon.pdf:
Overview
The functionality of the ODBC Enterprise Stage for DataStage
Enterprise Edition is to extend the capabilities of DataStage to
communicate with external data sources. Currently, connectivity to
external data sources from the parallel canvas of DataStage is limited
to four databases: DB2, Informix, Oracle, and Teradata.
Overview
The functionality of the ODBC Enterprise Stage for DataStage
Enterprise Edition is to extend the capabilities of DataStage to
communicate with external data sources. Currently, connectivity to
external data sources from the parallel canvas of DataStage is limited
to four databases: DB2, Informix, Oracle, and Teradata.