Mainframe, MVS and zOS Discussion

Posted: **Tue Dec 30, 2014 11:26 am**

Hi All,

I have a VARCHAR column in a DB2 table. I'm trying to know the minimum and maximum size this varchar filed can store. I tried using the MIN and MAX function but they can only be used for the numeric data type. Is there any function with which I can find the length for varchar, please help.

Posted: **Tue Dec 30, 2014 11:08 pm**

Hi,

MIN/MAX should have worked for you, try this:

Code: Select all

SELECT  MIN(LENGTH(VARCHAR_COL_A)),MAX(LENGTH(VARCHAR_COL_A)) 
  FROM  TABLE_NAME

Posted: **Wed Jan 07, 2015 4:41 pm**

Great thanks Anuj.

Posted: **Thu Jan 08, 2015 12:08 pm**

You're welcome!

Mainframe, MVS and zOS Discussion

How to get the min and max varchar field size in DB2 table?

How to get the min and max varchar field size in DB2 table?

Re: How to get the min and max varchar field size in DB2 tab

Re: How to get the min and max varchar field size in DB2 tab

Re: How to get the min and max varchar field size in DB2 tab