Re: Login greater than 8 Characters

Thank you Art, for your lucid explanation. That sure explains it. As soon as I am able to install and play with 9.4., this should get tested. Regards, Zev Berezin B&H Photo Informix DBA On 23 Oct 2003, at 11:16, ART KAGEL, BLOOMBERG/ 65E 55TH wrote: > When you perform an upgrade on an existing instance the oninit drops > sysmaster when it first comes online and recreates it by running the > buildsmi script in $INFORMIXDIR/etc, also the system catalog tables of > all databases are ALTERED so > the tablenames, colnames, procnames, etc. will all handle 128 > character > identifiers for future CREATE/ALTER/RENAME statements and so that > sysusers and the authorization tables will accept 32 character > usernames. > > Art S. Kagel > > ----- Original Message ----- > From: Zev Berezin <zevb@bhphotovideo.com> > At: 10/23 10:46 > > > On 23 Oct 2003, at 9:03, Art S. Kagel wrote: > > > > > First Please do no post HTML, etc., many, like me, do not use a > > > browser to read the news group or mail gateways for that matter. > > > > Thank you for pointing that out. > > I fiddled around with some settings (Pegasus WinPmail V3.12c). > > Please rsvp if they didn't help. > > > > > The solution is to upgrade to 9.xx where database identifiers (ie > > > database, table, and column names) were increased from 18 > > > characters to 128 characters and usernames and other external > > > identifiers were increased from 8 chars to 32 characters. > > > > That seems like a good solution for a new instance. How can this > > help for an upgrade, where there is no root initialization taking > > place? How would the sysmaster database get modified? > > > > Regards, > > Zev Berezin > > B&H Photo > > Informix DBA > > > > sending to informix-list