Embedded SQL - Retrieve a record count using a dynamic File name

//Retrieve a record count using a dynamic File name wk#file = %trim(stavl1); Clear s1count; Exec SQL Select Number_Rows into :s1count From SysPartitionStat Where System_Table_Name = :wk#file and System_Table_Schema = :YourLib ;

[report a broken link by clicking here]