size of tabname and colums for IDS 7.31
gbdba asked about the maximum length of table and column names in IDS 7.31. Jonathan Leffler said it is 18 characters for all names and cannot be extended in 7.31, while 9.21 allows names up to 128 characters. Stefan Weideneder added user names are the exception: 8 characters in 7.31 and 28 in 9.21. Answered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
dear readers, how many characters could be used for the tabname and the columnname in the IDS 7.31 system? is it correct, that there can used 18 characters only for the tabname? exist there a possibility to enhance the size of characters for tabnames and columns for one database in an instanze of 16 databases? who knows a helping answer for me? Sent via Deja.com http://www.deja.com/
this is only a testanswer to my request t so if all settings of deja works In article <94r81c$2vu$1@nnrp1.deja.com>, gbdba@my-deja.com wrote: > dear readers, > > how many characters could be used for the tabname and the columnname in > the IDS 7.31 system? > > is it correct, that there can used 18 characters only for the tabname? > > exist there a possibility to enhance the size of characters for > tabnames and columns for one database in an instanze of 16 databases? > > who knows a helping answer for me? > > Sent via Deja.com > http://www.deja.com/ > Sent via Deja.com http://www.deja.com/
gbdba@my-deja.com wrote: > how many characters could be used for the tabname and the columnname in > the IDS 7.31 system? > > is it correct, that there can used 18 characters only for the tabname? Yes, 18. And for the column names, and all the other names. > exist there a possibility to enhance the size of characters for > tabnames and columns for one database in an instanze of 16 databases? Using 7.31, no. Using 9.21, you can have names up to 128 characters. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"
Jonathan Leffler wrote: > > gbdba@my-deja.com wrote: > > how many characters could be used for the tabname and the columnname in > > the IDS 7.31 system? > > > > is it correct, that there can used 18 characters only for the tabname? > > Yes, 18. And for the column names, and all the other names. ... except user names. 7.31 allows 8 characters and 9.21 allows 28. snipped ... -- Stefan Weideneder Phone: +49 89/3565478-2 --------------- --- Fax: +49 89/3565478-3 ------------- ------ mailto:/stefan@weideneder.de --- -------- http://www.weideneder.de -----