On mine (under Oracle) it appends the Schema_ID So you can add to the end of the steps… If the generated name is already used in the database, shorten the generated name by the number of characters for schema_id, and append schema_id to the shortened name.
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Friday, June 25, 2010 10:39 AM To: [email protected] Subject: Re: Some questions on arschema: ViewName addition release; view name maximum length in MS SQL, other non-Oracle dbs? - resolved ** And don’t forget that it first checks to see if the name is unique, if not it appends 001 or 002 as necessary to make it unique ☺. Oh…and BTW…I couldn’t look at those two links kuz they are both local to your machine. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ben Chernys Sent: Friday, June 25, 2010 8:52 AM To: [email protected] Subject: Re: Some questions on arschema: ViewName addition release; view name maximum length in MS SQL, other non-Oracle dbs? - resolved ** So, here's the answer. Introduced in 7.1 (not patch 4) If it starts with a non-alphabetic character, prepend "a_" For Informix: 18, DB2: 128; all others: 30 (in spite of the fact that the actual MS SQL limit is 128); I missed "Group" which becomes group_x. ditto for any other SQL reserved words. And there you have it. Cheers Ben
