When i ran the query against production database, I got R33337883E70 as maximum value and i don't have access to production server to check dd cfg parameters.
What needs to be changed to get the other value as maximum just like production database.
Thanks.
ramahanumanth
Last Activity: Feb 21 '11, 06:35 PM
Joined: Jan 18 '11
Location:
-
max(char10) is giving wrong data where column has alphanumeric data
Hi,
I have a table with column char(20). The table has alphanumeric data. When i select max(column) on that table, its giving wrong data. See below more details:
Data:
db2 "select * from EPSAR_WKLY_DET_ UV"
R33337A00A3E
R33337883E70
select max(RETAIN_USER _ID) from EPSAR_WKLY_DET_ UV" =
R33337A00A3E
Instead of R33337883E70 which is bigger, its displaying...
No activity results to display
Leave a comment: