How to change these oracle code to db2 code:
declare cnt int;
begin
SELECT COUNT(*) INTO cnt from PODTX03
WHERE TRNDATE < INT( TOCHAR( sdate, 'YYYYMMDD' ) ) ;
end;

thanks

Check this website for a lot of valuable UDF's when migrating to DB2. Because they were created when V9 didn't exist some of them might be available allready as a builtin function.

Regards, Gert

Thanks for your reply.
Except the user defined function,
I also want to know how to
change the 'select count(*) into cnt from tb1 '
into db2.
It cannot execute like 'begin atomic declare cnt int;
select count(*) into cnt from tb1; end'.

create table count (no integer)@

begin atomic
declare cnt int;
delete from count;
set cnt=(select count(*) from eone.tdb_patch_dtl);
insert into count values (cnt);
end@

--Rahul Singh

Thanks.solved