BEGIN

declare vtablename varchar(50);
declare vtablecount integer;

select count(1) into vtablecount from SYSCAT.TABLES Where TABSCHEMA='snerc';

IF vtablecount>0 Then

FOR RECORD_COUNT AS select TABNAME from SYSCAT.TABLES Where TABSCHEMA='snerc'
DO
SET vtablename=TABNAME;
insert into snerc.RECORD_COUNT(TABLE_NAME,NUMBER_OF_ROWS) SELECT vtablename ,count(1) from snerc.vtablename;
END FOR;
COMMIT;
END IF;
END

when i pass table name dynamically during runtime.

snerc.vtablename is an undefined name.

'snerc' shld be in upper case .

moreover you need to make the string and execute it

value in the table is case sensitive.but the object names not case sensitive

declared a variable for statement.

set stmt='insert into snerc.RECORD_COUNT(TABLE_NAME,NUMBER_OF_ROWS) SELECT' || vtablename|| ',count(1) from' || 'snerc.'||vtablename
EXEC SQL stmt;

trying above.if works will post reply.

Thats true , but in system tables they are always stored in upper case unless you create table in lower case enclosed in " "
..... so TABSCHEMA shld be in upper

ok i changed.

how can i prepare a statement to run

SELECT COLUMN1 FROM SNERC.VTABLENAME WHERE COLUMN2='ABC'

You build a string that contains the statement and prepare the string using the PREPARE statement.

I prpared what you suggested.

when i pass the variable in where clause it is throwing error called.

S0022(-206)[IBM][CLI Driver][DB2/AIX64] SQL0206N "ABC" is not valid in the context where it is used. SQLSTATE=42703

because its taking within quates.

how can i overcome this error.

Problem solved.
Thanks.