Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Handling Space value in datastage

Status
Not open for further replies.

ritanya

Technical User
Mar 3, 2004
7
IN
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top