DSXchange

Same answer as my original reply... First I would recommend you upgrade to the newest DataDirect ODBC drivers, which are currently at version 6.1. Check with IBM about downloading those. They will better support SQL Server 2008. I would add to check with IBM also about using DataDirect 6.1 drivers w...

It is possible if the target stage action is set to update then insert and the array size is greater than 1, which it should not be in this scenario to begin with, it will cause an abnormal termination error. Nobody on this topic has provided enough detail to say if that was truly the cause or not. ...

With IBM, like any company, it depends on who you talk to. I've highlighted the document that clearly shows support, so you can take that to IBM next time you face a problem on SQL Server 2008 R2.

SURA wrote:The latest Datastage 8.7 Version is not compatible with SQL Server 2008 R2.

Not true based on what I see here... Are you seeing something different?

I'm running 8.7 w/ DataDirect 6.1 ODBC drivers. The ODBC reference PDF states that the drivers support SQL Server 2000, 2005, and 2008 R1 and R2.

The Lookup stage has plenty of options you can choose from. If the Lookup condition is not met then you can set it to Continue, Drop, Fail (abort the job), or Reject. If the Lookup fails then you have the same 4 options also.

The IBM tech note says that the IsValid() behavior changed starting in 8.1. Here's what I see on 8.7.0.0 (64 bit) on AIX using a simple test of Row Gen -> Xfm -> Peek, without having APT_ISVALID_75COMPAT or any other special environment variables set. This tests IsValid() on the upper limits of vari...

Yes, you can have many conditions using Or, And, or both. As mentioned, you've used an Or when you most likely should have used an And. Your syntax is correct. Add parenthesis to help group them if you have many, just like any programming language.

As I stated above, I confirmed a wrong result on version 8.7 (version 8.7.0.0 64 bit on AIX). It returned a 1 for me... So you are on 8.x? What version of x?

PaulVL wrote:The only difference is that if you mess it up, someone might die.

The ISD manual specifically defines a real-time web service as "someone's life does not depend on it." I guess ISD is not designed to handle web services inside a pace maker or air traffic control tower...

IsValid("Int32","+2147483648") this retrun 1 even though the max positive value allowed is 2147483647. I think you may have found a bug. I've confirmed it in version 8.7. IsValid('int32', 2147483647) returns 1. IsValid('int32', 2147483648) returns 1. It should return 0. IsValid(...

It has been difficult to find good DataStage resource in India, especially people with experience. They're out there, and on this forum, but hard to find when projects start up, meaning their availability can be a problem. Where I am now we normally look for at least 5 years experience with DataStag...

YW.

I'm not sure what to make of your output either. The file command work for me on AIX using Korn shell (ksh), the default shell here. It returns the path plus this:

.../bin/osh: 64-bit XCOFF executable or object module

I ran it as the file owner, dsadm.

I don't know if the industry has any concerns other than turning a profit, but I know the customers have such concerns!

I agree to contact support; it's best not to simply make guesses here.

Try out this IBM tech note:

How do I tell the Bitness of Websphere Application Server, Information Server DataStage and my Operating System?

http://www-01.ibm.com/support/docview.w ... wg21508944