Mainframe, MVS and zOS Discussion

I am getting 180 sqlcode while selecting record from table where date is current date ... didn't find any issue with date format...what could be the reason...any suggestions

The message seems pretty clear -- either the length of the date field you are using is wrong, or the format doesn't match what DB2 is expecting (YYYY-DD-MM instead of YYYY-MM-DD for example). Since you didn't provide us with anything else, that's about all we can say. If you had provided the query or at least the field in question, we might have been able to do more.