Skip to Content
0
Former Member
Apr 14, 2016 at 01:32 AM

How to get row count when extracting ?

73 Views

Hi experts

how to get row count when extracting ?

------------ ext.sql (bof)-------------

set temporary option temp_extract_name1='/data/a.dat'

set temporary option temp_extract_column_delimiter='|';

select * from tab_a;

------------- (eof) -----------------------

dbisql -nogui ext.sql 2>&1>ext.sql.log

tab_a has 100 rows but (0 rows) is printed to ext.sql.log

I want to get printed row count to standard output.

Thanks in advance