Teradata脚本在通过Jenkins执行时抛出错误

发布于 2025-02-08 12:32:40 字数 393 浏览 1 评论 0原文

REPLACE MACRO Macroname
(
col1 TIMESTAMP(0)
)
AS
(  
    DELETE FROM
        tabe1
    WHERE td_colnm = 'Jenkins';
);

我在脚本执行中在jenkins中遇到以下错误。

“原因：liquibase.exception.databaseexception：[teradata数据库] [terajdbc 17.00.00.03] [错误3707] [sqlstate 42000]构成错误，期望像';之间的';之间';';和请求的结尾。（（ COL1时间戳（0））作为（
从 tabe1 在哪里td_colnm ='jenkins']

任何人都可以提供解决方案吗？

原文

REPLACE MACRO Macroname
(
col1 TIMESTAMP(0)
)
AS
(  
    DELETE FROM
        tabe1
    WHERE td_colnm = 'Jenkins';
);

I am getting the below error in Jenkins on the script execution.

"Reason: liquibase.exception.DatabaseException: [Teradata Database] [TeraJDBC 17.00.00.03] [Error 3707] [SQLState 42000] Syntax error, expected something like ')' between ';' and the end of the request. [Failed SQL: (3707)" REPLACE MACRO Macroname
(
col1 TIMESTAMP(0)
)
AS
(
DELETE FROM
tabe1
WHERE td_colnm = 'Jenkins']

Can anyone provide the solution please?

分享到QQ

分享到微博