have problem with the sort stage
Posted: Tue Nov 21, 2006 9:49 am
I have a job where the i need to implement the query using stages
the query looks something like this
SELECT
A.RACCOUNT
C.REP_TO_ACC
FROM VB.R_M_LAST A, VA.M_H_LAST B, VA.M_H_LAST C WHERE A.M_ACCOUNT_NO = B.M_ACCOUNT_NO
AND B.REP_TO_ACC = C.M_ACC_NO
AND C.HQ_IND = 'Y'
AND CURRENT DATE < A.REDEPLOY_EFF_DATE
AND CURRENT DATE > A.EFFECTIVE_DATE FOR READ ONLY WITH UR
i have problem giving the constraint for the current date. could anyone let me know how to give this constraint?
i have tried giving Date() < A.REDEPLOY_EFF_DATE AND Date() > A.EFFECTIVE_DATE.
but the output is not right
the query looks something like this
SELECT
A.RACCOUNT
C.REP_TO_ACC
FROM VB.R_M_LAST A, VA.M_H_LAST B, VA.M_H_LAST C WHERE A.M_ACCOUNT_NO = B.M_ACCOUNT_NO
AND B.REP_TO_ACC = C.M_ACC_NO
AND C.HQ_IND = 'Y'
AND CURRENT DATE < A.REDEPLOY_EFF_DATE
AND CURRENT DATE > A.EFFECTIVE_DATE FOR READ ONLY WITH UR
i have problem giving the constraint for the current date. could anyone let me know how to give this constraint?
i have tried giving Date() < A.REDEPLOY_EFF_DATE AND Date() > A.EFFECTIVE_DATE.
but the output is not right