Hi,

I have a syntax error when trying to alter a table to add a bson column to a sbspace.

If I create the table with the bson column everything work.

Example: 
drop table if exists "prog".jgc;
create table "prog".jgc
  (
    jgc_seq bigserial not null ,
    jgc_sdbo1_seq bigint not null ,
    jgc_tabname varchar(128) not null ,
    jgc_tab_seq bigint not null ,
    jgc_type char(1) not null ,
    jgc_rec_date datetime year to second
        default current year to second,
    jgc_data "informix".bson
  ) put jgc_data in ( sbspace1_sbs )
  extent size 1000 next size 1000 lock mode row;

But if I alter and existing table I have a syntax error

Ok I found the solution.

I need to add the column first and do another alter for the put clause.

alter table "prog".jgc  add (  jgc_data "informix".bson  );
alter table "prog".jgc put jgc_data in ( sbspace1_sbs );

It's a bit strange the we can't to it at once.

Hi,

I have a syntax error when trying to alter a table to add a bson column to a sbspace.

If I create the table with the bson column everything work.

Example: 
drop table if exists "prog".jgc;
create table "prog".jgc
  (
    jgc_seq bigserial not null ,
    jgc_sdbo1_seq bigint not null ,
    jgc_tabname varchar(128) not null ,
    jgc_tab_seq bigint not null ,
    jgc_type char(1) not null ,
    jgc_rec_date datetime year to second
        default current year to second,
    jgc_data "informix".bson
  ) put jgc_data in ( sbspace1_sbs )
  extent size 1000 next size 1000 lock mode row;

But if I alter and existing table I have a syntax error