Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2011
    Posts
    25

    Unanswered: Create table syntax to save more than 1 images in one row(Different columns).

    I want to save more than one image into row for that i want to
    create table which have 3 columns having CLOB data type,
    What will be the Create table script for this table.

    I have used the following syntax its work for only one Cloumn.

    DROP TABLE signature;
    go
    CREATE TABLE informix.signature (
    signatureID SERIAL NOT NULL,
    Title varchar,
    sign01 CLOB,
    sign02 CLOB,
    sign03 CLOB,
    PRIMARY KEY(signatureID)
    )in ol_sefindev1 put sign01 in (sbspace1) ;

    How to create table with sign01 , sign02 , sign03 columns save in sbspace1

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,


    not sure it works, but did you try this:

    Code:
    CREATE TABLE informix.signature (
    signatureID SERIAL NOT NULL,
    Title varchar,
    sign01 CLOB,
    sign02 CLOB,
    sign03 CLOB,
    PRIMARY KEY(signatureID)
    ) in data03 ;
    alter table signature put sign01 in ( sbspace01) ;
    alter table signature put sign02 in ( sbspace01) ;
    alter table signature put sign03 in ( sbspace01) ;

  3. #3
    Join Date
    Dec 2011
    Posts
    25
    This works fine.
    Thanks ....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •