Print Number Of records

This question is answered

Hi,

I need to print Total No Of records from Temp Table.

Could you please let me know how to write Syntax for this.

Regards

Correct Answer

January 22, 2015 at 10:47 AM

Hi,

If you need to print the count in table
go for function total_rows(<datastore.owner.table_name>)

or to print the count in the trace log:

Step 1: create one global variable with data type int.

Step2 : $gv_count= sql('datastore name','select count(*) from table)

Step 2: after dataflow , in the script you can write the below code

Print('table name count is : ' || $gv_count);

1 Likes 1 View this answer in context

Helpful Answer