Re: Some questions on arschema: ViewName addition release; view name maximum length in MS SQL, other non-Oracle dbs? - resolved

[Ben Chernys]

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:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: June 25, 2010 5:54 PM
To: arslist@ARSLIST.ORG
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:arsl...@arslist.org] On Behalf Of LJ LongWing
Sent: Friday, June 25, 2010 10:39 AM
To: arslist@ARSLIST.ORG
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:arsl...@arslist.org] On Behalf Of Ben Chernys
Sent: Friday, June 25, 2010 8:52 AM
To: arslist@ARSLIST.ORG
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"