Skip to main content
Question

Write row count to log?

  • May 28, 2024
  • 1 reply
  • 61 views

nicholas
Contributor
Forum|alt.badge.img+11

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?

1 reply

geomancer
Evangelist
Forum|alt.badge.img+47
  • Evangelist
  • May 28, 2024

Expose the attribute COUNT in the SQLCreator.

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

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings