Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.
Select * from OPENQUERY(SIDPERS, 'Select ACN, APP_Name, ADMIN_REMARKS, substr(SSN_SM,6,9), UIC, PARA, LINE, GRADE, MOS, DT_EXPIRE, NCOID, Case when ELIG_SLRP IS NULL then NULL else ''X'' end ELIG_SLRP, Case when SLRP_CNTL_NBR IS NULL then NULL else SLRP_CNTL_NBR end SLRP_CNTL_NBR, Case when ELIG_NPS_BONUS IS NULL then NULL else ''X'' end ELIG_NPS_BONUS, Case when ELIG_NPS_BONUS IS NULL then BONUS_CNTL_NBR IS NULL else BONUS_CNTL_NBR end NPS_BONUS_CNTL_NBR from ACN.ACN_CNTL_NBR_TBL where ACN = ''09-119-003''')
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.