HI , As part of our performance testing we are trying to run complex select query with joins
When we run the query with our application we are getting result where as when the same query is run with Jmeter we are only getting the column header but getting empty result set This is the query which we are running SELECT A.CLM_NUM,CURRENT_TIMESTAMP,C.SF_OC_CD,SUBSTR(A.CLM_NUM,1,2),E.INTN_ID,F.PARTY_ID FROM DSN1_TSJJP_CLM A JOIN DSN1_TSJJP_CLM_PARTY B ON A.EPAD_CLM_ID = B.EPAD_CLM_ID JOIN DSN1_TSJJP_CLM_OC_RLTN C ON A.EPAD_CLM_ID = C.EPAD_CLM_ID JOIN EAZJU_IDAA X ON B.DRVR_LICNS_ID = X.DRIVER_ID JOIN KM92_UC_IDAA_W E ON X.CLNT_ID = E.EXTNL_ID JOIN DSN1_TSJJP_ECSE_PRTPT F ON A.CLM_NUM = CONCAT(F.CLM_ST_CD,F.CLM_NUM) WHERE A.BUSN_LINE_CD = 'A' AND B.DRVR_VERIF_IND = 'N' AND B.DRVR_LICNS_ID <> ' ' AND C.DSPLY_CLM_IND = 'Y' AND ((F.PRTPT_TYPE_CD = 'NI' AND F.PRTPT_ROLE_CD = 'D') OR F.PRTPT_TYPE_CD = 'DD'); Can you please help us out with the above Please let me know if any more information is required Thanks and Regards Roopa ================================ Rocket Software, Inc. and subsidiaries ? 77 Fourth Avenue, Waltham MA 02451 ? Main Office Toll Free Number: +1 855.577.4323 Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy ================================ This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you.
