select 'select count(1) || ''' || ',' || table_name || '''' || ' from ' || table_name ||';' from user_tables;
select 'turncate table '||table_schema||'.'||table_name||';' from dba_tables where TABLE_SCHEMA not in ('DICTIONARY_SCHEMA', 'DEFINITION_SCHEMA');
doIt()
{
gsqlnet test test <<EOF
select count(1) || ',MTS_ATALK_MSG' from MTS_ATALK_MSG;
select count(1) || ',TERMS_USE' from TERMS_USE;
select count(1) || ',MTS_MMS_MSG_LOG' from MTS_MMS_MSG_LOG;
select count(1) || ',MTS_SMS_MSG' from MTS_SMS_MSG;
select count(1) || ',MTS_SMS_MSG_LOG' from MTS_SMS_MSG_LOG;
EOF
}
doIt >> selectTOBE.log
cat selectTOBE.log |grep "^[0-9]"|grep -v "row" > bd2.out