DSXchange

As far as I'm concerned, Visual Studio 2010 Express C++ compiler is not supported.

Try installing e.g google chrome, set it as a default browser, and try installation again.

No one seems to know?

I also put a DSN Trace on, but that did not reveal anything crucial. I found this from the documentation ( http://www-01.ibm.com/support/docview.wss?uid=swg27018822#info ): If you are planning to access 64-bit databases, they must exist on a different computer than the engine tier. For more informat...

Actually no manipulations at all, also there is an error row saying:

SQLServer_Enterprise_5,0: Internal Error: (shbuf): iomgr\iomgr.C: 1882

I tried to google that but found nothing helpful.

I'm trying to insert data from local SQL Server database into another database on the same database instance. My parallel job workflow is as follows: SQL Server Enterprise Stage --> Transfrom --> SQL Server Enterprise Stage The data is read correctly from the database, but when the job tries to inse...

@abhijain: very good point, thank you !

Actually I figured it out, this works:

If DSLink2.Ozone = 'NA' Then 'NULL' Else DSLink2.Ozone

I was thinking this too complicated, thanks for your insights!

Thanks for the reply. My parallel job data flow is Seq. File --> transform --> seq. File In the first seq. File there is data in the integer column 1, 5, NA, 8 ... NA stands for a missing value. My intention is to convert NA --> NULL using If col = 'NA' Then Setnull() else col And this produces 0 in...

Disclaimer: I'm DataStage noob.... I have a IfThenElse function/derivation in the Transform stage: If DSLink2.SalesAmount = 'NA' Then SetNull() Else DSLink2.SalesAmount DSLink2.SalesAmount is an integer column. When populating this data into a sequential file, I get a value 0 instead of NULL in the ...

Hi, I new to DataStage and willing to learn more. I tried to read DSXEchange FAQ but I got an error saying Sorry, but only users granted special access can read topics in this forum. How to get this special access to read FAQ of this forum? Please move this post into another "room", if thi...