Finding the number of records in a derived tables

Analytics
Enthusiast

Finding the number of records in a derived tables

hi,

We have the following situation :

We need to use a derived table to get the code values based on some conditions. If the derived table has some rows, we need to insert into the table. if not we need insert spaces. Is there a way to find the count of the rows in the derived table. If there is no row returned, then the count doesnt work. Please let me know if there is any way to handle this...

Thanks,
Arun
1 REPLY
Enthusiast

Re: Finding the number of records in a derived tables

Hi Arun,

i would be better if you can provide us the query.

But you can create volatile table and populate it with derived query result. Bteq Activitycount variable can be used to determine the number of rows inserted and then you can decide on the next steps...

cheers,
novice