--=======================================

SET SCOUNT_STMT = 'SELECT COUNT(*) INTO '''|| Char(SCOUNT) || ''' FROM '||SCHEMA_NAME||'.RTBL RTBL,'||SCHEMA_NAME||'.ETL_LINEAGE A
WHERE A.DM_LINEAGE_CREATE_TS = '''|| CAST(RUN_DT AS CHAR(26) ) ||''' AND
A.PROCESS_NM = '''||PROCESS_NAME||'''';

--PREPARE SCOUNT_STMT1 FROM SCOUNT_STMT;
EXECUTE IMMEDIATE SCOUNT_STMT;
SET SOURCE_COUNT = SCOUNT;

Hi

I try to execute the above statement.There are around 12 rows in my table.But I get the below err.
SQL0198N The statement string of the PREPARE or EXECUTE IMMEDIATE statement
is blank or empty. SQLSTATE=42617


Statement processed with ERROR.
Please help
Thanks

correct me if I'm wrong, but

SELECT INTO is not valid for dynamic sql. You have to use a cursor.


by the way:
There are two tables in your query ( RTBL and ETL_LINEAGE ), but there is no join condition.

Am passing that as parameter,those records are fecthed from ETL lineage tbl...handled in script.

Can you pls give more idea on handling it cursor(count into)

have a look for all details
http://publib.boulder.ibm.com/infoce...c/r0000937.htm

Still am facing same issue after replacing with cursor

You should have a look at the final statement that's being generated. Pass it as an OUT parameter back from your stored procedure. Maybe you have a schema name that requires delimiters, maybe something else.