Search Results

Thanks cv_pan it has sorted out my problem

I dont need time stamp i need the value either 1 or 0 in variable

the query is returning this result

ROWCOUNT
-----------
1

1 record(s) selected.

I want the value 1 in the variable.

alert_val=$( db2 "select value (( select distinct 1 from opus.alerts where alname = 'MQ_FAILURE_INTERFACE' and
aldatetime > current timestamp - 20 minutes),0) from sysibm.sysdummy1 with ur" | sed...

alert_val=$( db2 "select value (( select distinct 1 from opus.alerts where alname = 'MQ_FAILURE_INTERFACE' and
aldatetime > current timestamp - 20 minutes),0) from sysibm.sysdummy1 with ur" | sed...

Hi I have script which will run on every tuesday of the week.I have to extract data for previous week.Can you please help in this.