DSXchange

SQLSTATE=01000, DBMS.CODE=10054 [DataStage][SQL Client][ODBC][IBM (DataDirect OEM)][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()). SQLSTATE=08S01, DBMS.CODE=11 [DataStage][SQL Client][ODBC][IBM (DataDirect OEM)][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check you...

I know this question has been asked before and I have read the replys - this works fine in 2 of our 3 environments, the UAT environment is a lesser version of our Production server - job is not reading huge amounts of data, We changed the project defaults to 1024 buffer and 600 timeout 0- is there a...

We have the following routine to get the max value of a column from a hash file - when we run this job under one user id, it returns the correct value - when we run the same job using another account, it returns NULL - we are not sure what is causing this issue, anyone have a similiar problem before...

we moved our servers a month or two back from a VM to a physical server - we suddenly got this error last week - from what I can see in the sqlservercentral.com forum, this appears to relate to the DNS cache etc - does anyone else have any experience with this - seems to be a common error - will flu...

we have two sets of processing one in the PM and the other in the AM - we use the same look-up jobs in both runs and would like to convert these to use Connection Set Objects - however these job uses different databases in AM and PM - is it possible to manipulate a connection set to use different da...

Hello - is there any way when you move your jobs from a Dev envrionment to a UAT environment, we change the passwords in the connection sets for that environment - it is our understanding that you have to open and reompile every single job that uses that connection set which is quite time consuming ...