I was trying to use ROW_NUMBER() and RANK() keyword in Cross Connection Editor. But its throwing some error while executing these keywords in Cross-Connection editor.Following is my query:
SELECT CUST_ID AS PARTY_ID,
CUST_TO_ACCT_RELATIONSHIP_CD AS CUST_TO_ACCT_RELATIONSHIP_CD,
ACCT_ID AS ACCT_ID
FROM (SELECT ACCT_ID,
PARTITION BY ACCT_ID
FROM OODSCIF.CUST_TO_ACCT_RELATIONSHIP_B C
WHERE APP_CD = ‘AFS’)
WHERE KEY = 1
Could you please tell me the alternative of these keywords that can be used in the Cross connection editor?
Also while executing the above keywords in the CrossConnection editor i am getting the error message - > Go to Helpetopicapath/topic/topic.htm for more information.
Please let me know the exact path of the help file.
Bharat Bhusan Singh