no found record print out "no record found"

[flaskvacuum]

i am thinking if there is no ORA- error found in the log,
it will print out "NO ORA-ERROR found"

Code: Select all

   if (findstr "ORA-[0-9]" alert_OCEAN_test.log neq 0) (
      echo NO ORA-ERROR found>>%output%
   )

[flaskvacuum]

Code: Select all

findstr "ORA-[0-9]" alert_OCEAN_test.log
If %ERRORLEVEL% EQU 1 echo NO ERROR FOUND>>%output%

so far the above work.

[foxidrive]

This is a method that runs when the errorlevel is true.

The || runs statements when errorlevel is true and && runs statements when the errorlevel is false.

Code: Select all

findstr "ORA-[0-9]" "alert_OCEAN_test.log" >nul || echo NO ORA-ERROR found>>%output%

Your method above will not do anything if the errorlevel is above 1 although that is usually an error condition.

[mfm4aa]

or use the ERRORLEVEL function:

Code: Select all

findstr "ORA-[0-9]" alert_OCEAN_test.log
If ERRORLEVEL 1 echo NO ERROR FOUND>>%output%

This catches all errorlevels above zero.

[foxidrive]

or use the ERRORLEVEL function:
This catches all errorlevels above zero.

Yes, it does.

The trouble in this case is that it would be an error condition and the log would state that the text isn't found (NO ERROR FOUND).

I was thinking it earlier but didn't comment... this is probably better to catch that kind of error.

Code: Select all

findstr "ORA-[0-9]" "alert_OCEAN_test.log" >nul
If %ERRORLEVEL% EQU 1 echo NO ERROR FOUND>>%output%
If ERRORLEVEL 2 echo An error occured in Findstr & Pause

[flaskvacuum]

This is a method that runs when the errorlevel is true.

The || runs statements when errorlevel is true and && runs statements when the errorlevel is false.

Code: Select all

findstr "ORA-[0-9]" "alert_OCEAN_test.log" >nul || echo NO ORA-ERROR found>>%output%

Your method above will not do anything if the errorlevel is above 1 although that is usually an error condition.

very true . indeed better logic then mine. Thanks.

[flaskvacuum]

or use the ERRORLEVEL function:

Code: Select all

findstr "ORA-[0-9]" alert_OCEAN_test.log
If ERRORLEVEL 1 echo NO ERROR FOUND>>%output%

This catches all errorlevels above zero.

this one very good too. Thanks!