on 01-22-2015 7:56 AM
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
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);
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use the total_rows built-in function:
total_rows(<datastore.owner.table_name>)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.