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 definition page . The job runs(just loads a flat file) but does not retrieve any data for the XID__c column (which I know exists). I want to avoid having to do a look up on every referenced object. I
s there a way to resolve this either in the SOQL our column definition? (I tried defining the column as Contact__r.XID__c but datastage aborted during execution). Ialso tried the as clause but DS did not like that either.
Thanks - - John
SalesForce SOQL question
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
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 changed to an underscore) for the column definition.
- - John
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 changed to an underscore) for the column definition.
- - John