IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How does Aggregate function MAX work on CHAR?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
chandhanarao

New User


Joined: 04 Jul 2007
Posts: 4
Location: chennai

PostPosted: Sat Jul 28, 2007 11:45 pm
Reply with quote

Can Aggregate function MAX be used on CHAR field? IF YES, HOW?
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Sun Jul 29, 2007 12:36 am
Reply with quote

From the DB2 V8 SQL Reference Manual:

The MAX function returns the maximum value in a set of values.

The argument values can be of any built-in data type other than a BLOB, CLOB, DBCLOB, or row ID. Character string arguments cannot have a maximum length greater than 255, and graphic string arguments cannot have a maximum length greater than 127.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts isfline didnt work in rexx at z/OS ve... CLIST & REXX 7
No new posts Calling an Open C library function in... CICS 1
No new posts Exclude rows with > than x occurre... DFSORT/ICETOOL 6
No new posts DATE2 function SYNCSORT 15
Search our Forums:

Back to Top