Category Archive: Unix

Search records and null
  • 24
    Set

Search records and null

Find in a table, for any field of the table, how many records are NULL, and of these NULL how many separate by values of another field of the same table. Example result: TAB_NAME                      COL_NAME                      NUM_ROWS                   NUM_NULLS_TOT       NUM_NULLS_X_COLVAL               COLVAL_LE_ID -------------------------------------------------------------------------------------...

Read More
File Directory Change Monitoring
  • 12
    Ago

File Directory Change Monitoring

1) Purpose: We want to check out a unix directory, signaling with an email if its content change.   2) Solution: Before modify appropriately the configuration parameters inside, then run in background mode (sh filedirChangeMonitoring.sh &) the following shell script....

Read More