cancel
Showing results for 
Search instead for 
Did you mean: 

Print Number Of records

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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);

Answers (1)

Answers (1)

former_member187605
Active Contributor
0 Kudos

Use the total_rows built-in function:

     total_rows(<datastore.owner.table_name>)