I had a very unusal scenario. We had a date comparison logic in our program in which we compared the current date with the date in the db2 table. In the comparison we copied the current date in the signed numeric field and the table date in alphanumeric field. The logic was if the current date > table date then a flag has to be set.
In the testing it worked fine , but when we moved the code to the production it failed can you explain the reason for this.