Skip to main content
  • EN

I would like to count the rows in a (Oracle) database table and then write that row count to the Translation log.

This is so that I can quickly compare the row counts of two tables against each other (as a quick way to determine if an update has occurred)

I can use SQLCreator to count the rows of the table

Select count(*) as COUNT from TABLE

This places the count as a value in a column that is output from the Result of the SQLCreator

My question is, how can I write this value to the Translation Log?

I assume I use the Shutdown Python script. But how does the script read that attribute value?

Expose the attribute COUNT in the SQLCreator.

Next add a Logger, and edit the Log Message to show the value of COUNT.

 

Reply


Community Stats

30,108
Posts
114,290
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.