Hi All,
I have a job, which extract data from MSSQL database server using ODBC enterprise stage. In the extract query I have field called NAME which is varchar (50) in the table and in the job I have defined it as varchar without any length. Now the issue is the data in this column is getting truncated. I am able to view only the first 26 character of the actual data.
Can anyone provide any pointers/inputs will be really helpful? Is there any environment setting that needs to be modified to resolve this issue?
Data Truncation in ODBC Enterprise stage.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Then you're going to have to find out where the truncation is occurring. For example, is there a SUBSTRINGS function in the extraction SQL? Is there some point in the job where the field is a VarChar(26)? DataStage will NOT exhibit this behaviour unless it is programmed to do so.
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.
Hi There is no substring function used in this SQl. It is a direct extract of that name column from the table. I have verified that job, nowhere its varchar(26). I am getting this truncated data even if i try to view data directly from the ODBC enterprise stage.ray.wurlod wrote:Then you're going to have to find out where the truncation is occurring. For example, is there a SUBSTRINGS function in the extraction SQL? Is there some point in the job where the field is a VarChar(26)? DataStage will NOT exhibit this behaviour unless it is programmed to do so.