Select statement GT sign ('>') is redirecting the output instead of comparing the value

[budatollah]

Trying to perform a select statement- select * from actlog where (date_time >"2003-02-01" and msgno=4037) - but the Gt sign is redirecting the output instead of performing the comparison to the date_time field. Doc doesn't seem to be correct regarding the use of the greater than sign.

 

[n9kws]

Try the following:



select * from actlog where (date_time>"2003-02-01" and msgno=4037)



Notice: there are NO spaces on either side of the comparision operator. Otherwise, TSM thinks you want to redirect the output.



Andy.