db2 存储过程使用动态sql传递日期参数时报SQLCODE=-401,SQLSTATE=42818

--创建测试表
create tale test1(
id int,
transdate date
);

--复制测试表
create table test2 like test1;

--测试存储过程
create procedure proc_test()
dynaminc result sets 1
    language sql
begin
    declare v_date date;
    declare v_sql varchar(5000);
    set v_date='2020-10-28';
    
    v_sql='select * from test2 where transdate ='||v_date;
    call SYSPROC_ADMIN('load from ('||v_sql||') of cursor replace into test1'); 

end

--执行存储过程报如下错误
--ExecuteCallableQuery:Execute:The data types of the operands for the operation '=' are not  compatible or comparable.. SQLCODE=-401,SQLSTATE=42818
--修改存储过程如下

create procedure proc_test()
dynaminc result sets 1
    language sql
begin
    declare v_date date;
    declare v_sql varchar(5000);
    set v_date='2020-10-28';
    
    v_sql='select * from test2 where transdate ='||chr(39)||v_date||chr(39);
    call SYSPROC_ADMIN('load from ('||v_sql||') of cursor replace into test1'); 

end

--运行成功