DSXchange

and IBM seems to acknowledge this (the alias issue especially) officially: https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.conn.drs.doc/topics/DRS063.html Excerpt from above article: "The DRS Connector stage configured for the Oracle database type and the Dynamic RD...

Hey Saurabh...i'm doing well. Hope same for you too. On the subject, perhaps KARMA does exist :D

we have anyhow initiated a Problem ticket with IBM.

Hi Craig Thanks for sharing the reason around implicit conversion issues and other coding practices while upgrading to newer versions. Wasn't aware of this thing. You're right in stating that there's no actual need of using DRS stages but just to set the context - we overtook the support sometime ba...

Thanks, Craig ! That was a good pointer. for some reason, environment variable pertaining to compiler (VS****) was not appearing in the system variables. 1) Removed VS .Net 2003 framework and installed VS .Net 2005 Express edition and MS SDK (for windows 7 + .Net framework 3.5 SP1) instead. 2) Kept ...

Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 00:08:28(000) <main_program> IBM InfoSphere DataStage Enterprise Edition 8.7.0.6614 Copyright (c) 2001, 2005-2011 IBM Corporation. All rights reserved ##I IIS-DSEE-TFCN-00006 00:08:28(001) <main_program> conductor uname: -s=Windows...

Hello Have recently installed Datastage v8.7 EE for training purpose on Windows 2008 R2 enterprise edition server. For c/c++ compiler, as per the installation guidelines mentioned at below link: http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_8.5.0/com.ibm.swg.im.iis.productization.iisinfsv.ins...

This one was an issue with incorrect partitioning, not sure how it was working on the old version though.

Thanks all for your responses.

I checked that. There are no changes in the field type.

Hi, I have a parallel job which was running fine in 8.1, but the job is throwing a warning after migration to 8.7 - main_program: When checking operator: Unrecognized type-specific format properties: {case=sensitive}; on key field_name. field_name is being used as a key for a lookup and is also a pa...

Description - The job is doing a CDC with the target table. (keys - Parent_id and child_name). For every new parent entry - child_id is generated from 1. For every existing parent and new child, max(child_id) is fetched from the target table lookup(key - parent_id) and child_id is generated from max...

Hi, I have a job that generates sequences using stage variables based on change in key field value. We have upgraded from 8.1 to 8.7. The job works perfectly in 8.1, however in 8.7 the job is generating duplicate sequences. Has anyone come across a similar scenario? Do stage variables/their initiali...

Hi All Though there are multiple posts around this topic but somehow I can't view the Premium content posts( looks like I can view only those premium posts which were posted after I received the premium membership :| ) , so please pardon me for generating a new post afresh. Server jobs in production...

Looks like very doable one( just had the overview, though, for now-will check in detail tonight )

Many thanks for sharing this, Craig. Cheers :D

Hi All Is there any way we can retrieve the information that what are all the hash files still being used by a Data Stage project? Unix production box contains an external hash directory where huge no. of hash files are being accumulated since last 5 yrs. Even for the decommissioned applications, fi...

Many thanks...will try and get back.