Hi,
I'm passing default value of single space(" ") for one of the column which is char(1) in the transformer. My database is SQL Server. After the job runs, when i check the length for the field, i'm getting 0 as length whereas i'm supposed to get 1. I assume sql server is simply truncating the space, but i'm not sure. Even though if i give two spaces(" ") also, i'm not getting the length(space not inserted) as well as warning message in datastage.
The same job (two spaces),is giving warning message in my client location. It's truncating one space and the job is failing.
Please let me know is this a problem with datastage(i'm using v7.1) or with SQL Server.
Please let me know how to handle this? Do i need to change or set anything in Datastage.....
Thanks in advance
Ritanya
I'm passing default value of single space(" ") for one of the column which is char(1) in the transformer. My database is SQL Server. After the job runs, when i check the length for the field, i'm getting 0 as length whereas i'm supposed to get 1. I assume sql server is simply truncating the space, but i'm not sure. Even though if i give two spaces(" ") also, i'm not getting the length(space not inserted) as well as warning message in datastage.
The same job (two spaces),is giving warning message in my client location. It's truncating one space and the job is failing.
Please let me know is this a problem with datastage(i'm using v7.1) or with SQL Server.
Please let me know how to handle this? Do i need to change or set anything in Datastage.....
Thanks in advance
Ritanya