注册

我从其他数据库抽取数据发现下面这个insert语句出现了问题,SROAD前面有一个单引号导致,该字段里面就包括这个单引号,我该怎么写这条sql呢?

宽宽 2023/12/01 540 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
INSERT INTO jy.cw_KNA1 ("/BIC/LOGSYS","MANDT","KUNNR","LAND1","NAME1","NAME2","ORT01","PSTLZ","REGIO","SORTL","STRAS","TELF1","TELFX","XCPDK","ADRNR","MCOD1","MCOD2","MCOD3","ANRED","AUFSD","BAHNE","BAHNS","BBBNR","BBSNR","BEGRU","BRSCH","BUBKZ","DATLT","ERDAT","ERNAM","EXABL","FAKSD","FISKN","KNAZK","KNRZA","KONZS","KTOKD","KUKLA","LIFNR","LIFSD","LOCCO","LOEVM","NAME3","NAME4","NIELS","ORT02","PFACH","PSTL2","COUNC","CITYC","RPMKR","SPERR","SPRAS","STCD1","STCD2","STKZA","STKZU","TELBX","TELF2","TELTX","TELX1","LZONE","XZEMP","VBUND","STCEG","DEAR1","DEAR2","DEAR3","DEAR4","DEAR5","GFORM","BRAN1","BRAN2","BRAN3","BRAN4","BRAN5","EKONT","UMSAT","UMJAH","UWAER","JMZAH","JMJAH","KATR1","KATR2","KATR3","KATR4","KATR5","KATR6","KATR7","KATR8","KATR9","KATR10","STKZN","UMSA1","TXJCD","PERIV","ABRVW","INSPBYDEBI","INSPATDEBI","KTOCD","PFORT","WERKS","DTAMS","DTAWS","DUEFL","HZUOR","SPERZ","ETIKG","CIVVE","MILVE","KDKG1","KDKG2","KDKG3","KDKG4","KDKG5","XKNZA","FITYP","STCDT","STCD3","STCD4","STCD5","XICMS","XXIPI","XSUBT","CFOPC","TXLW1","TXLW2","CCC01","CCC02","CCC03","CCC04","CASSD","KNURL","J_1KFREPRE","J_1KFTBUS","J_1KFTIND","CONFS","UPDAT","UPTIM","NODEL","DEAR6","/VSO/R_PALHGT","/VSO/R_PAL_UL","/VSO/R_PK_MAT","/VSO/R_MATPAL","/VSO/R_I_NO_LYR","/VSO/R_ONE_MAT","/VSO/R_ONE_SORT","/VSO/R_ULD_SIDE","/VSO/R_LOAD_PREF","/VSO/R_DPOINT","ALC","PMT_OFFICE","FEE_SCHEDULE","DUNS","DUNS4","PSOFG","PSOIS","PSON1","PSON2","PSON3","PSOVN","PSOTL","PSOHS","PSOST","PSOO1","PSOO2","PSOO3","PSOO4","PSOO5","OIDRC","OID_POREQD","OIPBL","RES_CNTRY","CCODE") VALUES ('PR3CLNT800','800','0048796119','SG','EasyDense','EasyDense Solutions LLP','Singapore','260003','SG','FGW2022092','PRINCIPALOFFICEAT3QUEEN'SROAD,10-14','','','','0000933149','EASYDENSE','EASYDENSE SOLUTIONS LLP','SINGAPORE','公司','','','','0000000','00000','','','0','','20220921','RFCMDM001','','','','','','','SD10','','0048796119','','','','','','','','','','','','','','E','GW2022092113165','','','','','','','','','','','','','','','','','','','','','','','','0','0000','','000000','0000','','','','','','','','','','','','0','','','','','','','','','','','X','00','','','X','','','','','','','','','','','','','','','','','','','','','','','','','','','','','00000000','000000','','','0','','','','00','','','0','0','','','','','','','','','','','','','','','','','','','','','','','','','')

Cause: dm.jdbc.driver.DMException: -2007 第 1 行, 第 1710 列[SROAD]附近出现错误:

回答 0
暂无回答
扫一扫
联系客服