DSXchange

The column is defined as VarChar 255 NULLABLE = NO on both the input and output side. I have "Replace NULL's with empty values" and "Replace empty values with NULLs" checked As far as the hierarchy it is at the same level as the others (i.eActivitydate) and I have no issue with t...

Hi, The last job of our sequence simply takes an text file and writes to an XML file: Sequential File ===>>Transformer ======>> XML Input stage One of the fileds we are moving is called ActivityTime. I have a stage variable defined in the transformer as: svActivityTime = if (IsNull(DSLink2.ActivityT...

Just received a response from IBM and wanted to share: Hello John, I posted your question on our internal forum and received the following: There is no documented difference between these approaches that I am aware of, beyond the fact that if you paste IPCs you can decide where to create the additio...

I did sort up front in the ODBC and indicated the Sort order in the Aggregator. I played around a bit and changed the job from ODBC==>Transformer===>Aggregator====>ODBC to ODBC==>Transformer===>Aggregator====>IPC====>ODBC and that works fine. My question is why would this work and having the Inter P...

Hi, We have a straightforward job that flows as follows: ODBC==>Transformer===>Aggregator====>ODBC When the job runs I receive the following warning: Abnormal termination of stage cfsmrt_acty_to_cost_objct_fact..Cfsmrt_acty_to_cost_objct_fact_agr detected I reset the job and see the following in the...

Here goes teh link:

http://publib.boulder.ibm.com/infocente ... vices.html

Definitely no need for a WAS admin. Since the installation here, I initially used it to set up LDAP as the security protocol and never visited it again. We are running under Windows 2003 so I do have a script from one of the IBM pages that has the sequence of starting up and shutting down various se...

IBM just forwarded me the solution to this...hope it will help someone else: Using the query Select Contact__r.XID__c , Start_Date__c, Name, License_Type__c, State__c, End_Date__c, Contact__c From Contact_License__c. The refernced column Contact__r.XID__c should read Contact__r_XID__c (period change...

Hi, We are running DataStage version 8.0.1 with the SalesForce adapter installed. I am attempting to run the SOQL: Select Contact__r.XID__c , Start_Date__c, Name, License_Type__c, State__c, End_Date__c, Contact__c From Contact_License__c and have defined the first column as XID__c on the column defi...

Hi,
Everything I needed was found @
http://publib.boulder.ibm.com/infocente ... 03_dc.html


Hope this helps - - John

I opened a PMR with IBM and they have replicated the issue on there side...They just opened an APAR (# JR36390) and will most likely be issuing us a patch for this....

I'll update teh thread with any developments.

The only difference beside the version was the ODBC we are using, unfortunately I copied the 7.5 ODBC to our 8.0 server and the warning persists!! I opened a PMR with IBM so they can lend a hand.

I just ran the same job in Version 7.5 and I do not receive a warning and no log entry for teh number of rows updated just the following: Project:CostFoundation (PAERSCBBLA0293) Job name:Zero_EnteredCost Event #:55 Timestamp:4/13/2010 12:46:36 PM Event type:Info User:PRUDENTIAL\X090842 Message: Zero...

Hi, We have a simple job that has a dummy file going into an ODBC stage (SQL server) taht runs an update statement. Looks like everything is successful but the job throws the warning below. This is the first time we are executing this job in Version 8.0. I just ported this project over from version ...

Thanks Ray...I asked around and some of the consultants had the same issue but never reported it. I guess it depends on the individual desktop configuration, since it works fine for me and a few other developers.

As always Thank You for your answer!!!