时间戳

首页 > 解决方案 > Unicode 分隔标识符或“UDFCALLNAME”上的 Teradata 错误

syntax-error - Unicode 分隔标识符或“UDFCALLNAME”上的 Teradata 错误

问题描述

试图弄清楚为什么我会收到 Teradata 异常：[Teradata Database] [3707] 语法错误，预期类似于名称或 Unicode 分隔标识符或 ')' 和之间的 'UDFCALLNAME' 关键字

select ma.MHKAUDITLOGINTERNALID  as id, 
cast(MHK_CONTENT as varchar (8000)) as MHK_CONTENT,
AUDITDATETIME, CREATEDBY, MHKAPPEALSINTERNALID, MHKIREINTERNALID
   from vcoreMEDHOK_MHK_Audit as ma
   Where ma.AUDITDATETIME >= DATE '2021-08-01'
   and ma.MHKAPPEALSINTERNALID Is NOT NULL
   or  ma.AUDITDATETIME >= DATE '2021-08-01'
   and ma.MHKAPPEALSINTERNALID <> ' ' 
   or ma.AUDITDATETIME >= DATE '2021-08-01'
   and ma.MHKAPPEALSINTERNALID <> ' - ' )
select dt.id, TokenNum,regexp_replace(MHK_CONTENT, '<b>|</b>') as NewContent--- |<\/b>   --- ADT, MHKAPPEALSINTERNALID,MHKIREINTERNALID ,CreatedBy,AUDITDATETIME, CREATEDBY, MHKAPPEALSINTERNALID, MHKIREINTERNALID,                                 --- oreplace (Token,'<BR>','')
FROM TABLE    (RegExp_Split_To_Table(t.id, t.MHK_CONTENT, '<br/>*', 'i'))  --- split whenever '<BR/>' occurs t.TokenNum, t.MHK_CONTENT, t.ADT, t.MHKAPPEALSINTERNALID,t.MHKIREINTERNALID,t.CreatedBy,    ---'<b>|<\/b>|<BR>|</BR>|<br/>| - *', 'i' --- '<b>|<\/b>|<br/>|<BR>|</BR>*', 'i')
RETURNS (id BIGINT, TokenNum INT, MHK_CONTENT VARCHAR(8000), CreatedBy VARCHAR(100)))))as dt ```

标签： syntax-errorteradata

解决方案

好的，我确实纠正了它再次对我造成的影响：[Teradata Database] [3706] 语法错误：预期在字符串或 Unicode 字符文字和 ')' 之间存在某些内容。

推荐阅读