DSXchange

It really hit its stride when you gave it a portal look and these days 200+ posts a day is just phenomenal for niche software. Great site and continued great support.

I'm trying to put all my DataStage Certification links onto this page:
http://www.squidoo.com/DataStage

It really depends on whether you have the capacity in your Teradata engine or on your DataStage server. DataStage offers a GUI inteface to do the aggregation while Teradata requires you writing and maintaining SQL and perhaps losing some of your data lineage. I would recommend asking for a Teradata ...

There is no Modify function that sets a constant value! You can do a little hack to get what you want. For example lookup_int16_from_string( default_value=0('AAA=0')) might return a 0 all the time. NullToZero(SetNull)) might work if the Modify stage accepts multiple functions. IsNull(SourceColumn) m...

That is a good one. Funny jokes are always welcome. Mind you I tend to get sent nine lame jokes for every good one.

There are two guides to programming in DataStage basic. There is a section in the Server Job Developers Guide and there is a DataStage BASIC guide. There are also some example SDK routines. There is also a large archive of code in this forum if you just search for specific commands such as DSSetPara...

If developers can unprotect production or deliver jobs into production it kind of defeats the purpose of making making it read only. Release job functionality is not even in DataStage 8. There is a FAQ entry How do I make my production jobs read only?.

De Ja Vu, a similar thread was just on the server forum. The API stage uses the native DB2 client to connect to the database which is faster than the ODBC client. The DB2 Enterprise stage is faster than both and can be configured for remote DB2 databases. The Dynamic Database stage provides another ...

The parallel sequential file input stage is supposed to handle implicit conversions of fields to numeric and decimal - unless the extract developer has cocked it up and put formatting into a data exchange field, such as the commas. You could dig into the column properties and see if you can define a...

An IBM technical article on the DataStage DB2 enterprise stage had it benchmarked at extracting data 250% faster than the parallel DB2 API stage. You can assume this also makes it a lot faster than an ODBC extract or a server edition job. See my blog entry DataStage Tip: Extracting database data 250...

I just came across the bulletin myself and blogged about it . Looks like there is no impact on DataStage, QualityStage, MetaStage or ProfileStage version 7.5.x but there is an impact on the java runtime engine used by the DataStage JAVA PACK, SOA edition and RTI. You will need to make sure you have ...

First isolate the problem. Remove a couple columns at a time and rerun the job until you identify the column or columns that is triggering the change. Examine the contents of that column via a DataStage View editor and, if you can, via a different viewer such as a SQL window. DataStage can add some ...

I did a blog post on this a long time ago. I think the IBM Oracle Change Data Capture and Replication Server both add triggers to the Oracle tables. You might have to go for an Oracle product to get log scraping. Even then you still need to do change data determination where, at the end of transform...

If you have the right version of DataStage, I think it's the latest Unix/Linux version but not the Windows version, you can do a conditional lookup using the parallel lookup stage. The constraints form lets you enter a condition on whether the lookup should be performed for each row using values in ...

Isn't it usually the case that you have to make some minor changes to a cobol copybook to get DataStage to recognise it? DataStage seems picky about levels and comments and syntax.