OnDemand User Group

Support Forums => Other => Topic started by: imene on September 29, 2020, 07:22:43 AM

Title: CMOD V9.0 Limitation of size of DataBase Field Name on App Group and Folder
Post by: imene on September 29, 2020, 07:22:43 AM
i find that we have a limit of 18 characters in field name of app group

https://www.ibm.com/support/knowledgecenter/SSQHWE_10.5.0/com.ibm.ondemand.mp.doc/arsa0090.htm     and i think for folder it 20

it is too small  , Is it possible to do something to increase them ?
Title: Re: CMOD V9.0 Limitation of size of DataBase Field Name on App Group and Folder
Post by: Ed_Arnold on September 29, 2020, 08:50:35 AM
imene - I'm not quite following you.

If you look here:

https://www.ibm.com/support/knowledgecenter/SSEPCD_9.5.0/com.ibm.ondemand.administeringmp.doc/dodsc001.htm (https://www.ibm.com/support/knowledgecenter/SSEPCD_9.5.0/com.ibm.ondemand.administeringmp.doc/dodsc001.htm)

Name is varchar(60).

Perhaps the doc is off?

Ed Arnold
Title: Re: CMOD V9.0 Limitation of size of DataBase Field Name on App Group and Folder
Post by: Justin Derrick on September 29, 2020, 10:13:25 AM
Either way, I think the DB2 limit is 128 characters.  Not that I've seen anyone ask, but can we bump it up to match what DB2 permits?

I'll check on the database definition - it might be that this server didn't get a proper upgrade many years ago.

-JD.