Ben, I seem to remember that this field was introduced with 7.1 Release, not a patch.but the catch was it was only populated when a form was modified after the upgrade. Based on my reading just now of the 7.1 DB Reference Guide, the field is 254 long. On page 34 of the same guide it goes into the guidelines regarding how view names are created and uses the term 'maximum length allowed for an SQL name' several times during that section, but doesn't specify what that maximum is. Looking through my own DB, it appears that it's truncating my form names at 30 chars..so I don't have a definitive answer for you, but it looks like 30 is some sort of rule, then they append the rules outlined in the DB Guide.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ben Chernys Sent: Friday, June 25, 2010 4:57 AM To: [email protected] Subject: Some questions on arschema: ViewName addition release; view name maximum length in MS SQL, other non-Oracle dbs? ** Hi Guys/Gals, This is a general question that people with ITSM 7+ on ARS 7.1 patch less than 4 - or less (ARS 6 eg) on MS-SQL can answer for me. I think the "ViewName" column was added to arschema in 7.1 patch 4. Anyone know if this is right or when it was added? For servers prior to this, I use the following algorithm to derive the view name 1) change all special characters to _ 2) use User_x for User Here's the tricky bit: 3) (for Oracle), if there are more than one table with a common name in the first 30 characters, for all but the first one (lowest schemaid), substitute an underscore and the schema id for the last set of characters So for example, in my case on a 7.0.1 ARS ITSM 7.1 p 1 AST:PurchaseRequisitionLineItemOuterJoin AST_PurchaseRequisitionLine911 911 AST:PurchaseRequisitionLineItemInnerJoin AST_PurchaseRequisitionLineIte 910 BMC.CORE:BMC_ApplicationSystemServices BMC_CORE_BMC_ApplicationSys172 172 BMC.CORE:BMC_ApplicationSystem_ BMC_CORE_BMC_ApplicationSystem 123 BMC.CORE.CONFIG:BMC_FederatedProductLink BMC_CORE_CONFIG_BMC_Federat132 132 BMC.CORE.CONFIG:BMC_FederatedInterfaceLink BMC_CORE_CONFIG_BMC_Federat134 134 BMC.CORE.CONFIG:BMC_FederatedProduct BMC_CORE_CONFIG_BMC_Federat144 144 BMC.CORE.CONFIG:BMC_FederatedInterface BMC_CORE_CONFIG_BMC_Federat145 145 BMC.CORE.CONFIG:BMC_FederatedProduct_ BMC_CORE_CONFIG_BMC_Federate98 98 BMC.CORE.CONFIG:BMC_FederatedInterface_ BMC_CORE_CONFIG_BMC_Federate99 99 BMC.CORE.CONFIG:BMC_FederatedInterfaceLink_ BMC_CORE_CONFIG_BMC_FederatedI 65 BMC.CORE.CONFIG:BMC_FederatedProductLink_ BMC_CORE_CONFIG_BMC_FederatedP 63 The question for all you MS-SQL Guys is what is the maximum length of a view name and does ARS use this maximum? If you have 7.1 p 4 or greater with ITSM 7.x, the following SQL will let you know: select name, viewname, schemaid from arschema where name like 'BMC.CORE.CONFIG:BMC_FederatedI%' or select name, viewname, schemaid from arschema where name like ' BMC.CORE:BMC_MemberOfCollectio%' Really appreciate any responses. Thanks Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:[email protected]> Ben.Chernys _AT_ softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
