"Art S. Kagel" wrote:
>
> Fuzzy wrote:
> >
> > Hi all,
> >
> > I'm trying to figure out when usernames/userid's where allowed to be
> > longer than eight characters.
> >
> > In 7.12 (yeah, I know that's old), I used to get good old -576 errors
> > if I tried to use ids longer than 8 characters. Now, in IFS2000, I
> > can go crazy (e.g. I have a used "bloodylongusername" successfully.)
> >
> > Does anyone know when (i.e. what version) the limit was
> > removed/increased?
>
> Long identifiers were introduced in 9.20 (IDS.2000/IIF.2000). All
> identifiers (ie tablenames, columnnames, databasenames, etc) are now 128
> bytes long rather than 18 bytes and usernames are now restricted to 32 bytes
> rather than 8.
Gees, I have users now who call chunks ...._chunk, dbspaces ...._dbs,
databases ...._db, tables ...._table, views ...._view, etc. Well views
are okay, but can you imagine what they can do with 128 characters?
Instead of a table called 'a_table', they can have
'i_have_created_a_little_table_which_we_will_call_a_table'.
They should have reduced it from 18, not increased it. :-)
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /|
| http://www.informix.com http://www.informixhandbook.com |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |This email will self-destruct in |/// / ////|
| |10 sec. If you received this email |// / /////|
| |in error, sorry about the mess. |/ ////////|
+----------------------+-----------------------------------+-----------+