How to handle the backslash \ character in DB2 DDL Creation

Liquibase Development
1

Dear All,

We have an issue while creating a DB2 Function using Liquibase, though the functiona can be created on DB2 without any issue. How ever we we are through Liquibase, its throwing error as below.

Query we are trying to trigger:

Unexpected error running Liquibase: Lexical error at line 51, column 45. Encountered: “\uffe5” (65509), after : “”

Logs saved to
main\resources\LiquibaseDB2LUW\logs\liquibase.log

SET wk_Char = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(wk_Char
,’!’,’！’),’"’,’”’),’#’,’＃’),’$’,‘＄’),’%’,’％’),’&’,’＆’),’’’’,’’’),’(’,’（’),’)’,’）’),’=’,‘＝’)
,’^’,‘＾’),’|’,‘｜’),‘backslash’,‘￥’),’`’,’‘’),’@’,’＠’),’{’,’｛’),’[’,’［’),’+’,’＃’),’;’,’；’),’/’,’／’)
,’*’,’＊’),’:’,’：’),’}’,’｝’),’]’,’］’),’<’,’＃’),’,’,’，’),’>’,’＃’),’.’,’．’),’?’,’？’),’-’,’－’)
,’_’,’＿’),’ ‘,’ ‘),’~’,’＃’);–

Error shown on ‘backslash’‘￥’

2

[2021-11-30 13:45:25] SEVERE [liquibase.integration] Lexical error at line 51, column 45. Encountered: “\uffe5” (65509), after : “”
liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: Unexpected error running Liquibase: Lexical error at line 51, column 45. Encountered: “\uffe5” (65509), after : “”
at liquibase.command.CommandScope.execute(CommandScope.java:156)
at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:45)
at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:15)
at picocli.CommandLine.executeUserObject(CommandLine.java:1953)
at picocli.CommandLine.access$1300(CommandLine.java:145)
at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2352)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2346)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2311)
at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2179)
at picocli.CommandLine.execute(CommandLine.java:2078)
at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$1(LiquibaseCommandLine.java:325)
at liquibase.Scope.child(Scope.java:186)
at liquibase.Scope.child(Scope.java:162)
at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:291)
at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:80)
Caused by: liquibase.exception.LiquibaseException: Unexpected error running Liquibase: Lexical error at line 51, column 45. Encountered: “\uffe5” (65509), after : “”