DSXchange

Does it happen every time? Usually this error occurs because of a "blip" in the network, and is only seen rarely. If you can generate a reproducible case, involve your support provider. ... This issue occurs consistently on one server never on the other , when we open the ODBC stage and p...

I am getting the following message when trying to use the display button thru odbc stage to look at a table : DSD.BCIClose call to SQLSetConnectOption(SQL.PRIVATE.TX) failed. SQLSTATE=08S01, DBMS.CODE=0 [DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Communication link failure when ...

can you get a sql server stored procedure through ODBC stage to return an integer value in datastage? I have a sql server procedure I call with no return value through odbc and it works but when I try to have it return an integer value it says |SQL statement has incorrect number of result columns.| ...

I checked the display and it was correct. I do believe I have resolved the issue I had to use combination iconv and oconv ,it is working, it seems that in sql server when it is adding multiple fields that are decimals (in this case 7,2) even though they are defined as 7,2 when adding it expands beyo...

I looked at the underlying data col A+B ---> C col A is 7,2 in datastage and in actual database field definition col B is 7,2 in datastage and in actual database field definition col C was actually 9,2 and not 7,2 I changed the datastage to match the actual definition for col C. so now both datastag...

What is your exact error message and in which stage is this happening? ... The error message we get is : SAddData..Transformer_20.DSLink19: DSD.BCIPut call to SQLExecute returned informational message. SQLSTATE=01004, DBMS.CODE=0 [DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Frac...

have two fields A and B both are decimal 7,2 in datastage I am adding the two fields into field C and it is also a decimal 7,2 through transformer stage A+B --> C None of the original values from A and B are even close to being 7,2 but I am getting warning message fractional truncation on them. the ...

kduke wrote:Is there a trim() in your lookup.

There is no trim in the lookup. but the lookup file
is fixed-width and the field is defined as one char.
The hash file I unloaded and it came to one char.
the only thing I thought might be the issue is the key
field being defined as varchar...

What you want to do is perfectly valid. Doesn't really answer the question if you'll have issues or not, however. :wink: The reason I am asking we have a job that has hash file with one key field (varchar) and space is a key field. I have unloaded the hash to text and it comes across as one char fi...

I want to a create hash file with one key field of one character
and space as key field. will I have issues in lookups?

if anyone converted datastage7.x from Unix server to windows?
did you encounter many issues going from Unix to windows?
and what kind if any?


Thanks in advance