I am getting Error -550:

The total size of all the columns listed in a UNIQUE, PRIMARY KEY, or
FOREIGN KEY clause is limited. The limit depends on the database server
in use, but all servers support a total of 120 bytes. The limit is the
same as the restriction on the total size of all columns in a composite
index. For additional information, see the CREATE TABLE statement in
the Informix Guide to SQL: Syntax.

Does any one know how I can easily determin what the current limit is for
the server version/installation/configuration I am using ?

Many thanks,

Andrew H.


sending to informix-list

Look in $INFORMIXDIR/release/*/*/<stuff>

Andrew Hardy wrote:
>
> I am getting Error -550:
>
> The total size of all the columns listed in a UNIQUE, PRIMARY KEY, or
> FOREIGN KEY clause is limited. The limit depends on the database server
> in use, but all servers support a total of 120 bytes. The limit is the
> same as the restriction on the total size of all columns in a composite
> index. For additional information, see the CREATE TABLE statement in
> the Informix Guide to SQL: Syntax.
>
> Does any one know how I can easily determin what the current limit is for
> the server version/installation/configuration I am using ?
>
> Many thanks,
>
> Andrew H.
>
> sending to informix-list

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #

Andrew Hardy wrote:

> I am getting Error -550:
>
> The total size of all the columns listed in a UNIQUE, PRIMARY KEY, or
> FOREIGN KEY clause is limited. The limit depends on the database server
> in use, but all servers support a total of 120 bytes. The limit is the
> same as the restriction on the total size of all columns in a composite
> index. For additional information, see the CREATE TABLE statement in
> the Informix Guide to SQL: Syntax.
>
> Does any one know how I can easily determin what the current limit is for
> the server version/installation/configuration I am using ?

Given that you give us no clues about which version you're using,
Paul's advice - read the release notes - is the only definitive way to
find out.

All versions of IDS (and OnLine IIRC) suppport 255 bytes. Most
versions of IDS that you should be using support 390 bytes.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/