DSXchange

We are using DS 11.5 and tried to commenct salesforce (API 41) using Saleforce pack in DS. We getting following error:- "main_program: Fatal Error: Information: error code: 8 error message: ; nested exception is: org.xml.sax.SAXException: Invalid element in com.sforce.soap.partner.fault.Unexpec...

corrected metadata and selected equal length at both side

Input table : Having columns A, DATE Input A DATE 00002819 1901-01-01 00002819 2000-09-11 00002819 2001-01-01 00002819 2001-08-27 00002819 2001-12-03 00002819 2001-12-17 00002819 2002-02-25 00002819 2002-07-29 I want to drive the new column New_Date in target table as mentioned below rule/condition ...

ray.wurlod wrote:That IS my suggestion. ...

use this query to get the desire result.....

SELECT child,parnt,level FROM PARENT START WITH parnt='A' CONNECT BY PRIOR child =parnt

ray.wurlod wrote:Search DSXchange for the term "recursive SQL". ...

please give ur suggestion on above problem if any one have..

Suppose parent record is A belong to two child B,C. and further B and C belong to their child records and finally the met a same exit point. I need to identify the two flows how these two flow from child. Example A B C D E E W F F Above mention example. I need two optimal path. Like A B D E F Second...

i am having a table emp. there is path info is available for emp. Parent record is A. Tbale records are in below metion table TABLE EMP Path1 Pateh2 A B A C B D D E E F C E E W W F i need out put result like result path1 A B D E F AND SECOND Result Path2 A C E W F Please help me to mange the output ...