"DB2" "SQL -- Informix On-line" "SQL -- SQL Server" "SQL -- Oracle" "SQL -- Sybase"
Mark -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ben Chernys Sent: 25 June 2010 17:15 To: [email protected] Subject: Re: Some questions on arschema: ViewName addition release; view name maximum length in MS SQL, other non-Oracle dbs? - resolved It is in the steps now. Remember this works on Oracle and SQL Dbs of any release. >From the original email: 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 the schema id for the last set of characters What I now need is the AR_INFO, DB_TYPE for Informix and DB2 as these are the only ones that use a value other than 30. Cheers Ben -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: June 25, 2010 5:54 PM To: [email protected] Subject: Re: Some questions on arschema: ViewName addition release; view name maximum length in MS SQL, other non-Oracle dbs? - resolved 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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"
