Creating a table with BLOB in a SBSpace

Posted in 2009

Summary

Alberto got "261: Cannot create file for table / 130: ISAM error: no such DBspace" when issuing CREATE TABLE ... IN sbs_photospace01, trying to put a whole table (with a BYTE, then BLOB, column) into an sbspace. Replies from Everett Mills and Art Kagel explained the cause: a table itself cannot live in an sbspace (or blobspace) — the table must be created IN a regular dbspace, with only the large-object column directed at the space, e.g. IMAGEM BLOB IN sbs_photospace01 ... IN my_dbspace. Also, BYTE/TEXT can only go in a classic blobspace or in-table; sbspaces require BLOB/CLOB.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: High Availability & Replication, Storage & Space Management, Error Codes & Troubleshooting, Server Administration, Data Types & Schema Design, Triggers, Constraints & Referential Integrity, Platform-Specific Issues, Versions, Editions & End-of-Life

ALBERTO ROMEU PESSONIO — Thu, 17 Sep 2009 15:24:25 — source: IIUG Forums & Mailing Lists

Hi everyone! Version of IDS: 11.50 FC5 OS: HP-UX 11.11 I'm trying to create a table with a BYTE datatype in a SBSpace. When i run the DDL statement on DBAccess, i've got the following error: CREATE TABLE TB_ANEXO_GUIA_1 ( ID_ANEXO_GUIA INTEGER NOT NULL, CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, CD_CARTEIRINHA VARCHAR(30) , COD_OPERADORA_ANS VARCHAR(6) , NM_ARQUIVO VARCHAR(255) , DS_EXTENSAO_ARQUIVO VARCHAR(3) , NU_TAMANHO_ARQUIVO BIGINT , NU_SEQUENCIAL INTEGER , ID_STATUS_ANEXO_GUIA INTEGER , DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , ID_PRESTADOR INTEGER , ID_OPERADORA INTEGER , ID_MAQUINA INTEGER , NM_SERVICO VARCHAR(100) , ID_THREAD INTEGER , IMAGEM BYTE ) IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; 261: Cannot create file for table (informix.tb_anexo_guia_1). 130: ISAM error: no such DBspace I tried to change the datatype from BYTE to BLOB, but the error remains. I created the database called "imagem" for use with a system thar store images in a regular DBSpace, but that table i'm trying to store in a SBSpace, showed on a onstat -d output below: IBM Informix Dynamic Server Version 11.50.FC5 -- On-Line -- Up 01:05:02 --1229596 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name c00000002cc62028 1 0x40001 1 1 2048 N B informix rootdbs c00000002ec27c38 2 0x40001 2 1 2048 N B informix physdbs c00000002ec27dd0 3 0x40001 3 1 2048 N B informix llogdbs c00000002ec28028 4 0x42001 4 1 2048 N TB informix tempdbs01 c00000002ec281c0 5 0x42001 5 1 2048 N TB informix tempdbs02 c00000002ec28358 6 0x40001 6 3 8192 N B informix datadbs01 c00000002ec284f0 7 0x48001 8 1 2048 N SB informix cdr_sbspace01 c00000002ec28688 8 0x40001 9 1 2048 N B informix cdr_dbspace01 c00000002ec28820 9 0x48001 11 1 2048 N SB informix sbs_photospace01 9 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname c00000002cc621c0 1 1 0 2560000 2527259 PO-B- /informix/v11/dbspaces/autorizador/rootdbs c00000002ec289b8 2 2 0 2560000 59947 PO-B- /informix/v11/dbspaces/autorizador/physdbs c00000002ec28ba8 3 3 0 2560000 4043 PO-B- /informix/v11/dbspaces/autorizador/llogdbs c00000002ec28d98 4 4 0 2560000 2556121 PO-B- /informix/v11/dbspaces/autorizador/tempdbs01 c00000002ec2a028 5 5 0 2560000 2559947 PO-B- /informix/v11/dbspaces/autorizador/tempdbs02 c00000002ec2a218 6 6 0 640000 811 PO-B- /informix/v11/dbspaces/autorizador/datadbs01a c00000002ec2a408 7 6 0 640000 48996 PO-B- /informix/v11/dbspaces/autorizador/datadbs01b c00000002ec2a5f8 8 7 0 2560000 1991184 1991185 POSB- /informix/v11/dbspaces/autorizador/sbsspace01 Metadata 568762 457027 568762 c00000002ec2a7e8 9 8 0 2560000 2559907 PO-B- /informix/v11/dbspaces/autorizador/cdr_dbspace01 c00000002ec2a9d8 10 6 0 640000 419622 PO-B- /informix/v11/dbspaces/autorizador/datadbs01c c00000002ec2abc8 11 9 0 2560000 1059947 1059947 POSB- /informix/v11/dbspaces/autorizador/sbs_photospc01 Metadata 1500000 1495875 1500000 11 active, 32766 maximum I have available space on the chunks of sbs_photospace. I also runned oncheck -cr, -ce, -cS,: informix@dvohp006:/informix/v11# oncheck -cr Validating IBM Informix Dynamic Server reserved pages Validating PAGE_PZERO... Validating PAGE_CONFIG... Validating PAGE_1CKPT & PAGE_2CKPT... Using check point page PAGE_2CKPT. Validating PAGE_1DBSP & PAGE_2DBSP... Using DBspace page PAGE_2DBSP. Validating PAGE_1PCHUNK & PAGE_2PCHUNK... Using primary chunk page PAGE_2PCHUNK. Validating PAGE_1ARCH & PAGE_2ARCH... Using archive page PAGE_1ARCH. informix@dvohp006:/informix/v11# oncheck -ce sbs_photospace01 Validating extents for Space 'sbs_photospace01' ... Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p) 11 /informix/v11/dbspaces/autorizador/sbs_photospc01 2560000 4178 1059947 Note: 'Used' = used metadata space + used user data space. 'Free' = free user data space. informix@dvohp006:/informix/v11# oncheck -cS Validating space 'cdr_sbspace01' ... sbspace Metadata Partition Partnum Used Free cdr_sbspace01:'informix'.TBLSpace 0x700001 6 44 cdr_sbspace01:'informix'.sbspace_desc 0x700002 2 2 cdr_sbspace01:'informix'.chunk_adjunc 0x700003 2 2 cdr_sbspace01:'informix'.LO_ud_free 0x700004 2 5529 cdr_sbspace01:'informix'.LO_hdr_partn 0x700005 10 106186 Large Objects ID Ref Size Allocced Creat Last Sbs# Chk# Seq# Cnt (Bytes) Pages Extns Flags Modified ---- ---- ----- ---- ---------- -------- ----- ----- ------------------------ 7 8 3 1 3 1 1 L-N-H Wed Aug 12 11:44:07 2009 Validating space 'sbs_photospace01' ... sbspace Metadata Partition Partnum Used Free sbs_photospace01:'informix'.TBLSpace 0x900001 6 44 sbs_photospace01:'informix'.sbspace_desc 0x900002 2 2 sbs_photospace01:'informix'.chunk_adjunc 0x900003 2 2 sbs_photospace01:'informix'.LO_ud_free 0x900004 2 2943 sbs_photospace01:'informix'.LO_hdr_partn 0x900005 1 1171 informix@dvohp006:/informix/v11# oncheck -cD imagem TBLspace data check for imagem:informix.systables TBLspace data check for imagem:informix.syscolumns TBLspace data check for imagem:informix.sysindices TBLspace data check for imagem:informix.systabauth TBLspace data check for imagem:informix.syscolauth TBLspace data check for imagem:informix.sysviews TBLspace data check for imagem:informix.sysusers TBLspace data check for imagem:informix.sysdepend TBLspace data check for imagem:informix.syssynonyms TBLspace data check for imagem:informix.syssyntable TBLspace data check for imagem:informix.sysconstraints TBLspace data check for imagem:informix.sysreferences TBLspace data check for imagem:informix.syschecks TBLspace data check for imagem:informix.sysdefaults TBLspace data check for imagem:informix.syscoldepend TBLspace data check for imagem:informix.sysprocedures TBLspace data check for imagem:informix.sysprocbody TBLspace data check for imagem:informix.sysprocplan TBLspace data check for imagem:informix.sysprocauth TBLspace data check for imagem:informix.sysblobs TBLspace data check for imagem:informix.sysopclstr TBLspace data check for imagem:informix.systriggers TBLspace data check for imagem:informix.systrigbody TBLspace data check for imagem:informix.sysdistrib TBLspace data check for imagem:informix.sysfragments TBLspace data check for imagem:informix.sysobjstate TBLspace data check for imagem:informix.sysviolations TBLspace data check for imagem:informix.sysfragauth TBLspace data check for imagem:informix.sysroleauth TBLspace data check for imagem:informix.sysxtdtypes TBLspace data check for imagem:informix.sysattrtypes TBLspace data check for imagem:informix.sysxtddesc TBLspace data check for imagem:informix.sysinherits TBLspace data check for imagem:informix.syscolattribs TBLspace data check for imagem:informix.syslogmap TBLspace data check for imagem:informix.syscasts TBLspace data check for imagem:informix.sysxtdtypeauth TBLspace data check for imagem:informix.sysroutinelangs TBLspace data check for imagem

↪ replying to ALBERTO ROMEU PESSONIO

Everett Mills — Thu, 17 Sep 2009 15:51:29 — source: IIUG Forums & Mailing Lists

The short answer is that you can't create tables in blobspace. Create your table in a regular dbspace with your blob column pointed at your blobspace: CREATE TABLE TB_ANEXO_GUIA_1 ( ID_ANEXO_GUIA INTEGER NOT NULL, CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, CD_CARTEIRINHA VARCHAR(30) , COD_OPERADORA_ANS VARCHAR(6) , NM_ARQUIVO VARCHAR(255) , DS_EXTENSAO_ARQUIVO VARCHAR(3) , NU_TAMANHO_ARQUIVO BIGINT , NU_SEQUENCIAL INTEGER , ID_STATUS_ANEXO_GUIA INTEGER , DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , ID_PRESTADOR INTEGER , ID_OPERADORA INTEGER , ID_MAQUINA INTEGER , NM_SERVICO VARCHAR(100) , ID_THREAD INTEGER , IMAGEM BYTE IN sbs_photospace01) IN my_dbspace_here EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ALBERTO > ROMEU PESSONIO FILHO > Sent: Thursday, September 17, 2009 10:24 AM > To: ids@iiug.org > Subject: Creating a table with BLOB in a SBSpace [17060] > > Hi everyone! > > Version of IDS: 11.50 FC5 > OS: HP-UX 11.11 > > I'm trying to create a table with a BYTE datatype in a SBSpace. When i run the > DDL statement on DBAccess, i've got the following error: > > CREATE TABLE TB_ANEXO_GUIA_1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) , > ID_THREAD INTEGER , > IMAGEM BYTE ) > IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row;> > 261: Cannot create file for table (informix.tb_anexo_guia_1). > 130: ISAM error: no such DBspace> > I tried to change the datatype from BYTE to BLOB, but the error remains. I > created the database called "imagem" for use with a system thar store images > in a regular DBSpace, but that table i'm trying to store in a SBSpace, showed > on a onstat -d output below: > > IBM Informix Dynamic Server Version 11.50.FC5 -- On-Line -- Up 01:05:02 --> 1229596 Kbytes > > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > c00000002cc62028 1 0x40001 1 1 2048 N B informix rootdbs > c00000002ec27c38 2 0x40001 2 1 2048 N B informix physdbs > c00000002ec27dd0 3 0x40001 3 1 2048 N B informix llogdbs > c00000002ec28028 4 0x42001 4 1 2048 N TB informix tempdbs01 > c00000002ec281c0 5 0x42001 5 1 2048 N TB informix tempdbs02 > c00000002ec28358 6 0x40001 6 3 8192 N B informix datadbs01 > c00000002ec284f0 7 0x48001 8 1 2048 N SB informix cdr_sbspace01 > c00000002ec28688 8 0x40001 9 1 2048 N B informix cdr_dbspace01 > c00000002ec28820 9 0x48001 11 1 2048 N SB informix sbs_photospace01 > 9 active, 2047 maximum > > Chunks > address chunk/dbs offset size free bpages flags pathname > c00000002cc621c0 1 1 0 2560000 2527259 PO-B- > /informix/v11/dbspaces/autorizador/rootdbs > c00000002ec289b8 2 2 0 2560000 59947 PO-B- > /informix/v11/dbspaces/autorizador/physdbs > c00000002ec28ba8 3 3 0 2560000 4043 PO-B- > /informix/v11/dbspaces/autorizador/llogdbs > c00000002ec28d98 4 4 0 2560000 2556121 PO-B- > /informix/v11/dbspaces/autorizador/tempdbs01 > c00000002ec2a028 5 5 0 2560000 2559947 PO-B- > /informix/v11/dbspaces/autorizador/tempdbs02 > c00000002ec2a218 6 6 0 640000 811 PO-B- > /informix/v11/dbspaces/autorizador/datadbs01a > c00000002ec2a408 7 6 0 640000 48996 PO-B- > /informix/v11/dbspaces/autorizador/datadbs01b > c00000002ec2a5f8 8 7 0 2560000 1991184 1991185 POSB- > /informix/v11/dbspaces/autorizador/sbsspace01 > > Metadata 568762 457027 568762 > c00000002ec2a7e8 9 8 0 2560000 2559907 PO-B- > /informix/v11/dbspaces/autorizador/cdr_dbspace01 > c00000002ec2a9d8 10 6 0 640000 419622 PO-B- > /informix/v11/dbspaces/autorizador/datadbs01c > c00000002ec2abc8 11 9 0 2560000 1059947 1059947 POSB- > /informix/v11/dbspaces/autorizador/sbs_photospc01 > > Metadata 1500000 1495875 1500000 > 11 active, 32766 maximum > > I have available space on the chunks of sbs_photospace. > > I also runned oncheck -cr, -ce, -cS,: > > informix@dvohp006:/informix/v11# oncheck -cr > Validating IBM Informix Dynamic Server reserved pages > > Validating PAGE_PZERO... > > Validating PAGE_CONFIG... > > Validating PAGE_1CKPT & PAGE_2CKPT... > > Using check point page PAGE_2CKPT. > > Validating PAGE_1DBSP & PAGE_2DBSP... > > Using DBspace page PAGE_2DBSP. > > Validating PAGE_1PCHUNK & PAGE_2PCHUNK... > > Using primary chunk page PAGE_2PCHUNK. > > Validating PAGE_1ARCH & PAGE_2ARCH... > > Using archive page PAGE_1ARCH. > > informix@dvohp006:/informix/v11# oncheck -ce sbs_photospace01 > > Validating extents for Space 'sbs_photospace01' ... > > Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p) > > 11 /informix/v11/dbspaces/autorizador/sbs_photospc01 2560000 4178 1059947 > > Note: 'Used' = used metadata space + used user data space. > > 'Free' = free user data space. > > informix@dvohp006:/informix/v11# oncheck -cS > > Validating space 'cdr_sbspace01' ... > > sbspace Metadata Partition Partnum Used Free > cdr_sbspace01:'informix'.TBLSpace 0x700001 6 44 > cdr_sbspace01:'informix'.sbspace_desc 0x700002 2 2 > cdr_sbspace01:'informix'.chunk_adjunc 0x700003 2 2 > cdr_sbspace01:'informix'.LO_ud_free 0x700004 2 5529 > cdr_sbspace01:'informix'.LO_hdr_partn 0x700005 10 106186 > > Large Objects > ID Ref Size Allocced Creat Last > Sbs# Chk# Seq# Cnt (Bytes) Pages Extns Flags Modified > ---- ---- ----- ---- ---------- -------- ----- ----- ------------------------ > > 7 8 3 1 3 1 1 L-N-H Wed Aug 12 11:44:07 2009 > > Validating space 'sbs_photospace01' ... > > sbspace Metadata Partition Partnum Used Free > sbs_photospace01:'informix'.TBLSpace 0x900001 6 44 > sbs_photospace01:'informix'.sbspace_desc 0x900002 2 2 > sbs_photospace01:'informix'.chunk_adjunc 0x900003 2 2 > sbs_photospace01:'informix'.LO_ud_free 0x900004 2 2943 > sbs_photospace01:'informix'.LO_hdr_partn 0x900005 1 1171 > > informix@dvohp006:/informix/v11# oncheck -cD imagem > > TBLspace data check for imagem:informix.systables > TBLspace data check for imagem:informix.syscolumns > TBLspace data check for imagem:informix.sysindices > TBLspace data check for imagem:informix.systabauth > TBLspace data check for imagem:informix.syscolauth > TBLspace data check for imagem:informix.sysviews > TBLspace data check for imagem:informix.sysusers > TBLspace data check for imagem:informix.sysdepend > TBLspace data check for imagem:informix.syssynonyms > TBLspace data check for imagem:informix.syssyntable > TBLspace data check for imagem:informix.sysconstraints > TBLspace data check for imagem:informix.sysreferenc

↪ replying to ALBERTO ROMEU PESSONIO

Art Kagel — Thu, 17 Sep 2009 15:53:12 — source: IIUG Forums & Mailing Lists

You cannot place BYTE or TEXT columns in sbspace (SmartBlobSpace). BYTE and TEXT are simple blob objects and can only be placed IN TABLE or in a regular BLOBSpace - onspaces -c -b. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 17, 2009 at 11:24 AM, ALBERTO ROMEU PESSONIO FILHO < arfilho@orizonbrasil.com.br> wrote: > Hi everyone! > > Version of IDS: 11.50 FC5 > OS: HP-UX 11.11 > > I'm trying to create a table with a BYTE datatype in a SBSpace. When i run > the > DDL statement on DBAccess, i've got the following error: > > CREATE TABLE TB_ANEXO_GUIA_1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) , > ID_THREAD INTEGER , > IMAGEM BYTE ) > IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row;> > 261: Cannot create file for table (informix.tb_anexo_guia_1). > 130: ISAM error: no such DBspace> > I tried to change the datatype from BYTE to BLOB, but the error remains. I > created the database called "imagem" for use with a system thar store > images > in a regular DBSpace, but that table i'm trying to store in a SBSpace, > showed > on a onstat -d output below: > > IBM Informix Dynamic Server Version 11.50.FC5 -- On-Line -- Up 01:05:02 --> 1229596 Kbytes > > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > c00000002cc62028 1 0x40001 1 1 2048 N B informix rootdbs > c00000002ec27c38 2 0x40001 2 1 2048 N B informix physdbs > c00000002ec27dd0 3 0x40001 3 1 2048 N B informix llogdbs > c00000002ec28028 4 0x42001 4 1 2048 N TB informix tempdbs01 > c00000002ec281c0 5 0x42001 5 1 2048 N TB informix tempdbs02 > c00000002ec28358 6 0x40001 6 3 8192 N B informix datadbs01 > c00000002ec284f0 7 0x48001 8 1 2048 N SB informix cdr_sbspace01 > c00000002ec28688 8 0x40001 9 1 2048 N B informix cdr_dbspace01 > c00000002ec28820 9 0x48001 11 1 2048 N SB informix sbs_photospace01 > 9 active, 2047 maximum > > Chunks > address chunk/dbs offset size free bpages flags pathname > c00000002cc621c0 1 1 0 2560000 2527259 PO-B- > /informix/v11/dbspaces/autorizador/rootdbs > c00000002ec289b8 2 2 0 2560000 59947 PO-B- > /informix/v11/dbspaces/autorizador/physdbs > c00000002ec28ba8 3 3 0 2560000 4043 PO-B- > /informix/v11/dbspaces/autorizador/llogdbs > c00000002ec28d98 4 4 0 2560000 2556121 PO-B- > /informix/v11/dbspaces/autorizador/tempdbs01 > c00000002ec2a028 5 5 0 2560000 2559947 PO-B- > /informix/v11/dbspaces/autorizador/tempdbs02 > c00000002ec2a218 6 6 0 640000 811 PO-B- > /informix/v11/dbspaces/autorizador/datadbs01a > c00000002ec2a408 7 6 0 640000 48996 PO-B- > /informix/v11/dbspaces/autorizador/datadbs01b > c00000002ec2a5f8 8 7 0 2560000 1991184 1991185 POSB- > /informix/v11/dbspaces/autorizador/sbsspace01 > > Metadata 568762 457027 568762 > c00000002ec2a7e8 9 8 0 2560000 2559907 PO-B- > /informix/v11/dbspaces/autorizador/cdr_dbspace01 > c00000002ec2a9d8 10 6 0 640000 419622 PO-B- > /informix/v11/dbspaces/autorizador/datadbs01c > c00000002ec2abc8 11 9 0 2560000 1059947 1059947 POSB- > /informix/v11/dbspaces/autorizador/sbs_photospc01 > > Metadata 1500000 1495875 1500000 > 11 active, 32766 maximum > > I have available space on the chunks of sbs_photospace. > > I also runned oncheck -cr, -ce, -cS,: > > informix@dvohp006:/informix/v11# oncheck -cr > Validating IBM Informix Dynamic Server reserved pages > > Validating PAGE_PZERO... > > Validating PAGE_CONFIG... > > Validating PAGE_1CKPT & PAGE_2CKPT... > > Using check point page PAGE_2CKPT. > > Validating PAGE_1DBSP & PAGE_2DBSP... > > Using DBspace page PAGE_2DBSP. > > Validating PAGE_1PCHUNK & PAGE_2PCHUNK... > > Using primary chunk page PAGE_2PCHUNK. > > Validating PAGE_1ARCH & PAGE_2ARCH... > > Using archive page PAGE_1ARCH. > > informix@dvohp006:/informix/v11# oncheck -ce sbs_photospace01 > > Validating extents for Space 'sbs_photospace01' ... > > Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p) > > 11 /informix/v11/dbspaces/autorizador/sbs_photospc01 2560000 4178 1059947 > > Note: 'Used' = used metadata space + used user data space. > > 'Free' = free user data space. > > informix@dvohp006:/informix/v11# oncheck -cS > > Validating space 'cdr_sbspace01' ... > > sbspace Metadata Partition Partnum Used Free > cdr_sbspace01:'informix'.TBLSpace 0x700001 6 44 > cdr_sbspace01:'informix'.sbspace_desc 0x700002 2 2 > cdr_sbspace01:'informix'.chunk_adjunc 0x700003 2 2 > cdr_sbspace01:'informix'.LO_ud_free 0x700004 2 5529 > cdr_sbspace01:'informix'.LO_hdr_partn 0x700005 10 106186 > > Large Objects > ID Ref Size Allocced Creat Last > Sbs# Chk# Seq# Cnt (Bytes) Pages Extns Flags Modified > ---- ---- ----- ---- ---------- -------- ----- ----- > ------------------------ > > 7 8 3 1 3 1 1 L-N-H Wed Aug 12 11:44:07 2009 > > Validating space 'sbs_photospace01' ... > > sbspace Metadata Partition Partnum Used Free > sbs_photospace01:'informix'.TBLSpace 0x900001 6 44 > sbs_photospace01:'informix'.sbspace_desc 0x900002 2 2 > sbs_photospace01:'informix'.chunk_adjunc 0x900003 2 2 > sbs_photospace01:'informix'.LO_ud_free 0x900004 2 2943 > sbs_photospace01:'informix'.LO_hdr_partn 0x900005 1 1171 > > informix@dvohp006:/informix/v11# oncheck -cD imagem > > TBLspace data check for imagem:informix.systables > TBLspace data check for imagem:informix.syscolumns > TBLspace data check for imagem:informix.sysindices > TBLspace data check for imagem:informix.systabauth > TBLspace data check for imagem:informix.syscolauth > TBLspace data check for imagem:informix.sysviews > TBLspace data check for imagem:informix.sysusers > TBLspace data check for imagem:informix.sysdepend > TBLspace data check for imagem:informix.syssynonyms > TBLspace data check for imagem:informix.syssyntable > TBLspace data check for imagem:informix.sysconstraints > TBLspace data check for imagem:informix.sysreferences > TBLspace data check for imagem:informix.syschecks > TBLspace data check for imagem:informix.sysdefaults > TBLspace data check for imagem:informix.syscoldepend > TBLspace data check for imagem:informix.sysprocedures > TBLspace data check for imagem:informix.sysprocbody > TBLspace data check for imagem:informix.sysprocplan > TBLspace data

↪ replying to Everett Mills

Everett Mills — Thu, 17 Sep 2009 16:07:23 — source: IIUG Forums & Mailing Lists

> -----Original Message----- > From: Alberto Romeu Pessonio Filho [mailto:arfilho@orizonbrasil.com.br] > Sent: Thursday, September 17, 2009 10:56 AM > To: Everett Mills > Subject: RES: Creating a table with BLOB in a SBSpace [17062] > > Hi Everett!!! > > That's exactly what i'm trying to do, but instead of use a Blobspace, > I'm using a SBSpace to create the entire table into the SBSpace, because > I need to use some SBSpace's functionality. > Ok then, use the BLOB datatype, but you still have to create the table itself in a regular dbspace, then the column for your blob is a pointer to its real location in the sbspace. Best to read the blob sections of chapter 4 the Guide to SQL Syntax to get a handle on how these all fit together. --EEM > Any tips? > Tks very much, > Alberto Pessonio. > > -----Mensagem original----- > De: Everett Mills [mailto:Everett.Mills@nationalbeef.com] > Enviada em: quinta-feira, 17 de setembro de 2009 12:52 > Para: Alberto Romeu Pessonio Filho > Assunto: RE: Creating a table with BLOB in a SBSpace [17062] > > The short answer is that you can't create tables in blobspace. Create > your table in a regular dbspace with your blob column pointed at your > blobspace: > > CREATE TABLE TB_ANEXO_GUIA_1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) , > ID_THREAD INTEGER , > IMAGEM BYTE IN sbs_photospace01) > IN my_dbspace_here > EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row;> > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > ALBERTO > > ROMEU PESSONIO FILHO > > Sent: Thursday, September 17, 2009 10:24 AM > > To: ids@iiug.org > > Subject: Creating a table with BLOB in a SBSpace [17060] > > > > Hi everyone! > > > > Version of IDS: 11.50 FC5 > > OS: HP-UX 11.11 > > > > I'm trying to create a table with a BYTE datatype in a SBSpace. When i > > run the > > DDL statement on DBAccess, i've got the following error: > > > > CREATE TABLE TB_ANEXO_GUIA_1 > > ( > > ID_ANEXO_GUIA INTEGER NOT NULL, > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > CD_CARTEIRINHA VARCHAR(30) , > > COD_OPERADORA_ANS VARCHAR(6) , > > NM_ARQUIVO VARCHAR(255) , > > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > > NU_TAMANHO_ARQUIVO BIGINT , > > NU_SEQUENCIAL INTEGER , > > ID_STATUS_ANEXO_GUIA INTEGER , > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > ID_PRESTADOR INTEGER , > > ID_OPERADORA INTEGER , > > ID_MAQUINA INTEGER , > > NM_SERVICO VARCHAR(100) , > > ID_THREAD INTEGER , > > IMAGEM BYTE ) > > IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock moderow; > > > > > 261: Cannot create file for table (informix.tb_anexo_guia_1). > > 130: ISAM error: no such DBspace> > > > I tried to change the datatype from BYTE to BLOB, but the error > remains. I > > created the database called "imagem" for use with a system thar store > images > > in a regular DBSpace, but that table i'm trying to store in a SBSpace, > > showed > > on a onstat -d output below: > > > > IBM Informix Dynamic Server Version 11.50.FC5 -- On-Line -- Up > 01:05:02 --> > 1229596 Kbytes > > > > Dbspaces > > address number flags fchunk nchunks pgsize flags owner name > > c00000002cc62028 1 0x40001 1 1 2048 N B informix rootdbs > > c00000002ec27c38 2 0x40001 2 1 2048 N B informix physdbs > > c00000002ec27dd0 3 0x40001 3 1 2048 N B informix llogdbs > > c00000002ec28028 4 0x42001 4 1 2048 N TB informix tempdbs01 > > c00000002ec281c0 5 0x42001 5 1 2048 N TB informix tempdbs02 > > c00000002ec28358 6 0x40001 6 3 8192 N B informix datadbs01 > > c00000002ec284f0 7 0x48001 8 1 2048 N SB informix cdr_sbspace01 > > c00000002ec28688 8 0x40001 9 1 2048 N B informix cdr_dbspace01 > > c00000002ec28820 9 0x48001 11 1 2048 N SB informix sbs_photospace01 > > 9 active, 2047 maximum > > > > Chunks > > address chunk/dbs offset size free bpages flags pathname > > c00000002cc621c0 1 1 0 2560000 2527259 PO-B- > > /informix/v11/dbspaces/autorizador/rootdbs > > c00000002ec289b8 2 2 0 2560000 59947 PO-B- > > /informix/v11/dbspaces/autorizador/physdbs > > c00000002ec28ba8 3 3 0 2560000 4043 PO-B- > > /informix/v11/dbspaces/autorizador/llogdbs > > c00000002ec28d98 4 4 0 2560000 2556121 PO-B- > > /informix/v11/dbspaces/autorizador/tempdbs01 > > c00000002ec2a028 5 5 0 2560000 2559947 PO-B- > > /informix/v11/dbspaces/autorizador/tempdbs02 > > c00000002ec2a218 6 6 0 640000 811 PO-B- > > /informix/v11/dbspaces/autorizador/datadbs01a > > c00000002ec2a408 7 6 0 640000 48996 PO-B- > > /informix/v11/dbspaces/autorizador/datadbs01b > > c00000002ec2a5f8 8 7 0 2560000 1991184 1991185 POSB- > > /informix/v11/dbspaces/autorizador/sbsspace01 > > > > Metadata 568762 457027 568762 > > c00000002ec2a7e8 9 8 0 2560000 2559907 PO-B- > > /informix/v11/dbspaces/autorizador/cdr_dbspace01 > > c00000002ec2a9d8 10 6 0 640000 419622 PO-B- > > /informix/v11/dbspaces/autorizador/datadbs01c > > c00000002ec2abc8 11 9 0 2560000 1059947 1059947 POSB- > > /informix/v11/dbspaces/autorizador/sbs_photospc01 > > > > Metadata 1500000 1495875 1500000 > > 11 active, 32766 maximum > > > > I have available space on the chunks of sbs_photospace. > > > > I also runned oncheck -cr, -ce, -cS,: > > > > informix@dvohp006:/informix/v11# oncheck -cr > > Validating IBM Informix Dynamic Server reserved pages > > > > Validating PAGE_PZERO... > > > > Validating PAGE_CONFIG... > > > > Validating PAGE_1CKPT & PAGE_2CKPT... > > > > Using check point page PAGE_2CKPT. > > > > Validating PAGE_1DBSP & PAGE_2DBSP... > > > > Using DBspace page PAGE_2DBSP. > > > > Validating PAGE_1PCHUNK & PAGE_2PCHUNK... > > > > Using primary chunk page PAGE_2PCHUNK. > > > > Validating PAGE_1ARCH & PAGE_2ARCH... > > > > Using archive page PAGE_1ARCH. > > > > informix@dvohp006:/informix/v11# oncheck -ce sbs_photospace01 > > > > Validating extents for Space 'sbs_photospace01' ... > > > > Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p) > > > > 11 /informix/v11/dbspaces/autorizador/sbs_photospc01 2560000 4178 > 1059947 > > > > Note: 'Used' = used metadata space + used user data space. > > > > 'Free' = free user data space. > > > > informix@dvohp006:/informix/v11# oncheck -cS > > > > Validating space 'cdr_sbspace01' ... > > > > sbspace Metadata Partition Partnum Used Free > > cdr_sbspace01:'informix'.TBLSpace 0x700001 6 44 > > cdr_sbspace01:'informix'.sbspace_desc 0x700002 2 2 > > cdr_sbspace01:'informix'.chunk_adjunc

↪ replying to Art Kagel

Alberto Romeu — Thu, 17 Sep 2009 16:12:41 — source: IIUG Forums & Mailing Lists

Hi Art!!! Ok, but i changed the datatype from BYTE to BLOB and the error still remain. SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit Modify the current SQL statements using the SQL editor. ----------------------- imagem@df06_d ---------- Press CTRL-W for Help -------- CREATE TABLE TB_ANEXO_GUIA1 ( ID_ANEXO_GUIA INTEGER NOT NULL, CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, CD_CARTEIRINHA VARCHAR(30) , COD_OPERADORA_ANS VARCHAR(6) , NM_ARQUIVO VARCHAR(255) , DS_EXTENSAO_ARQUIVO VARCHAR(3) , NU_TAMANHO_ARQUIVO BIGINT , NU_SEQUENCIAL INTEGER , ID_STATUS_ANEXO_GUIA INTEGER , DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , ID_PRESTADOR INTEGER , ID_OPERADORA INTEGER , ID_MAQUINA INTEGER , NM_SERVICO VARCHAR(100) ,ID_THREAD INTEGER , IMAGEM BLOB ) IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; 261: Cannot create file for table (informix.tb_anexo_guia1). 130: ISAM error: no such DBspace Tks anyway, Alberto Pessonio. -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art Kagel Enviada em: quinta-feira, 17 de setembro de 2009 12:53 Para: ids@iiug.org Assunto: Re: Creating a table with BLOB in a SBSpace [17064] You cannot place BYTE or TEXT columns in sbspace (SmartBlobSpace). BYTE and TEXT are simple blob objects and can only be placed IN TABLE or in a regular BLOBSpace - onspaces -c -b. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 17, 2009 at 11:24 AM, ALBERTO ROMEU PESSONIO FILHO < arfilho@orizonbrasil.com.br> wrote: > Hi everyone! > > Version of IDS: 11.50 FC5 > OS: HP-UX 11.11 > > I'm trying to create a table with a BYTE datatype in a SBSpace. When i run > the > DDL statement on DBAccess, i've got the following error: > > CREATE TABLE TB_ANEXO_GUIA_1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) , > ID_THREAD INTEGER , > IMAGEM BYTE ) > IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > 261: Cannot create file for table (informix.tb_anexo_guia_1). > 130: ISAM error: no such DBspace> > I tried to change the datatype from BYTE to BLOB, but the error remains. I > created the database called "imagem" for use with a system thar store > images > in a regular DBSpace, but that table i'm trying to store in a SBSpace, > showed > on a onstat -d output below: > > IBM Informix Dynamic Server Version 11.50.FC5 -- On-Line -- Up 01:05:02 --> 1229596 Kbytes > > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > c00000002cc62028 1 0x40001 1 1 2048 N B informix rootdbs > c00000002ec27c38 2 0x40001 2 1 2048 N B informix physdbs > c00000002ec27dd0 3 0x40001 3 1 2048 N B informix llogdbs > c00000002ec28028 4 0x42001 4 1 2048 N TB informix tempdbs01 > c00000002ec281c0 5 0x42001 5 1 2048 N TB informix tempdbs02 > c00000002ec28358 6 0x40001 6 3 8192 N B informix datadbs01 > c00000002ec284f0 7 0x48001 8 1 2048 N SB informix cdr_sbspace01 > c00000002ec28688 8 0x40001 9 1 2048 N B informix cdr_dbspace01 > c00000002ec28820 9 0x48001 11 1 2048 N SB informix sbs_photospace01 > 9 active, 2047 maximum > > Chunks > address chunk/dbs offset size free bpages flags pathname > c00000002cc621c0 1 1 0 2560000 2527259 PO-B- > /informix/v11/dbspaces/autorizador/rootdbs > c00000002ec289b8 2 2 0 2560000 59947 PO-B- > /informix/v11/dbspaces/autorizador/physdbs > c00000002ec28ba8 3 3 0 2560000 4043 PO-B- > /informix/v11/dbspaces/autorizador/llogdbs > c00000002ec28d98 4 4 0 2560000 2556121 PO-B- > /informix/v11/dbspaces/autorizador/tempdbs01 > c00000002ec2a028 5 5 0 2560000 2559947 PO-B- > /informix/v11/dbspaces/autorizador/tempdbs02 > c00000002ec2a218 6 6 0 640000 811 PO-B- > /informix/v11/dbspaces/autorizador/datadbs01a > c00000002ec2a408 7 6 0 640000 48996 PO-B- > /informix/v11/dbspaces/autorizador/datadbs01b > c00000002ec2a5f8 8 7 0 2560000 1991184 1991185 POSB- > /informix/v11/dbspaces/autorizador/sbsspace01 > > Metadata 568762 457027 568762 > c00000002ec2a7e8 9 8 0 2560000 2559907 PO-B- > /informix/v11/dbspaces/autorizador/cdr_dbspace01 > c00000002ec2a9d8 10 6 0 640000 419622 PO-B- > /informix/v11/dbspaces/autorizador/datadbs01c > c00000002ec2abc8 11 9 0 2560000 1059947 1059947 POSB- > /informix/v11/dbspaces/autorizador/sbs_photospc01 > > Metadata 1500000 1495875 1500000 > 11 active, 32766 maximum > > I have available space on the chunks of sbs_photospace. > > I also runned oncheck -cr, -ce, -cS,: > > informix@dvohp006:/informix/v11# oncheck -cr > Validating IBM Informix Dynamic Server reserved pages > > Validating PAGE_PZERO... > > Validating PAGE_CONFIG... > > Validating PAGE_1CKPT & PAGE_2CKPT... > > Using check point page PAGE_2CKPT. > > Validating PAGE_1DBSP & PAGE_2DBSP... > > Using DBspace page PAGE_2DBSP. > > Validating PAGE_1PCHUNK & PAGE_2PCHUNK... > > Using primary chunk page PAGE_2PCHUNK. > > Validating PAGE_1ARCH & PAGE_2ARCH... > > Using archive page PAGE_1ARCH. > > informix@dvohp006:/informix/v11# oncheck -ce sbs_photospace01 > > Validating extents for Space 'sbs_photospace01' ... > > Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p) > > 11 /informix/v11/dbspaces/autorizador/sbs_photospc01 2560000 4178 1059947 > > Note: 'Used' = used metadata space + used user data space. > > 'Free' = free user data space. > > informix@dvohp006:/informix/v11# oncheck -cS > > Validating space 'cdr_sbspace01' ... > > sbspace Metadata Partition Partnum Used Free > cdr_sbspace01:'informix'.TBLSpace 0x700001 6 44 > cdr_sbspace01:'informix'.sbspace_desc 0x700002 2 2 > cdr_sbspace01:'informix'.chunk_adjunc 0x700003 2 2 > cdr_sbspace01:'informix'.LO_ud_free 0x700004 2 5529 > cdr_sbspace01:'informix'.LO_hdr_partn 0x700005 10 106186 > > Large Objects > ID Ref Size Allocced Creat Last > Sbs# Chk# Seq# Cnt (Bytes) Pages Extns Flags Modified > ---- ---- ----- ---- ---------- -------- ----- ----- > ------------------------ > > 7 8 3 1 3 1 1 L-N-H Wed Aug 12 11:44:07 2009

↪ replying to Everett Mills

Alberto Romeu — Thu, 17 Sep 2009 16:12:49 — source: IIUG Forums & Mailing Lists

Hi Everett!!! That's exactly what i'm trying to do, but instead of use a Blobspace, I'm using a SBSpace to create the entire table into the SBSpace, because I need to use some SBSpace's functionality. Any tips? Tks very much, Alberto Pessonio. -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Everett Mills Enviada em: quinta-feira, 17 de setembro de 2009 12:51 Para: ids@iiug.org Assunto: RE: Creating a table with BLOB in a SBSpace [17062] The short answer is that you can't create tables in blobspace. Create your table in a regular dbspace with your blob column pointed at your blobspace: CREATE TABLE TB_ANEXO_GUIA_1 ( ID_ANEXO_GUIA INTEGER NOT NULL, CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, CD_CARTEIRINHA VARCHAR(30) , COD_OPERADORA_ANS VARCHAR(6) , NM_ARQUIVO VARCHAR(255) , DS_EXTENSAO_ARQUIVO VARCHAR(3) , NU_TAMANHO_ARQUIVO BIGINT , NU_SEQUENCIAL INTEGER , ID_STATUS_ANEXO_GUIA INTEGER , DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , ID_PRESTADOR INTEGER , ID_OPERADORA INTEGER , ID_MAQUINA INTEGER , NM_SERVICO VARCHAR(100) , ID_THREAD INTEGER , IMAGEM BYTE IN sbs_photospace01) IN my_dbspace_here EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ALBERTO > ROMEU PESSONIO FILHO > Sent: Thursday, September 17, 2009 10:24 AM > To: ids@iiug.org > Subject: Creating a table with BLOB in a SBSpace [17060] > > Hi everyone! > > Version of IDS: 11.50 FC5 > OS: HP-UX 11.11 > > I'm trying to create a table with a BYTE datatype in a SBSpace. When i run the > DDL statement on DBAccess, i've got the following error: > > CREATE TABLE TB_ANEXO_GUIA_1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) , > ID_THREAD INTEGER , > IMAGEM BYTE ) > IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > 261: Cannot create file for table (informix.tb_anexo_guia_1). > 130: ISAM error: no such DBspace> > I tried to change the datatype from BYTE to BLOB, but the error remains. I > created the database called "imagem" for use with a system thar store images > in a regular DBSpace, but that table i'm trying to store in a SBSpace, showed > on a onstat -d output below: > > IBM Informix Dynamic Server Version 11.50.FC5 -- On-Line -- Up 01:05:02 --> 1229596 Kbytes > > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > c00000002cc62028 1 0x40001 1 1 2048 N B informix rootdbs > c00000002ec27c38 2 0x40001 2 1 2048 N B informix physdbs > c00000002ec27dd0 3 0x40001 3 1 2048 N B informix llogdbs > c00000002ec28028 4 0x42001 4 1 2048 N TB informix tempdbs01 > c00000002ec281c0 5 0x42001 5 1 2048 N TB informix tempdbs02 > c00000002ec28358 6 0x40001 6 3 8192 N B informix datadbs01 > c00000002ec284f0 7 0x48001 8 1 2048 N SB informix cdr_sbspace01 > c00000002ec28688 8 0x40001 9 1 2048 N B informix cdr_dbspace01 > c00000002ec28820 9 0x48001 11 1 2048 N SB informix sbs_photospace01 > 9 active, 2047 maximum > > Chunks > address chunk/dbs offset size free bpages flags pathname > c00000002cc621c0 1 1 0 2560000 2527259 PO-B- > /informix/v11/dbspaces/autorizador/rootdbs > c00000002ec289b8 2 2 0 2560000 59947 PO-B- > /informix/v11/dbspaces/autorizador/physdbs > c00000002ec28ba8 3 3 0 2560000 4043 PO-B- > /informix/v11/dbspaces/autorizador/llogdbs > c00000002ec28d98 4 4 0 2560000 2556121 PO-B- > /informix/v11/dbspaces/autorizador/tempdbs01 > c00000002ec2a028 5 5 0 2560000 2559947 PO-B- > /informix/v11/dbspaces/autorizador/tempdbs02 > c00000002ec2a218 6 6 0 640000 811 PO-B- > /informix/v11/dbspaces/autorizador/datadbs01a > c00000002ec2a408 7 6 0 640000 48996 PO-B- > /informix/v11/dbspaces/autorizador/datadbs01b > c00000002ec2a5f8 8 7 0 2560000 1991184 1991185 POSB- > /informix/v11/dbspaces/autorizador/sbsspace01 > > Metadata 568762 457027 568762 > c00000002ec2a7e8 9 8 0 2560000 2559907 PO-B- > /informix/v11/dbspaces/autorizador/cdr_dbspace01 > c00000002ec2a9d8 10 6 0 640000 419622 PO-B- > /informix/v11/dbspaces/autorizador/datadbs01c > c00000002ec2abc8 11 9 0 2560000 1059947 1059947 POSB- > /informix/v11/dbspaces/autorizador/sbs_photospc01 > > Metadata 1500000 1495875 1500000 > 11 active, 32766 maximum > > I have available space on the chunks of sbs_photospace. > > I also runned oncheck -cr, -ce, -cS,: > > informix@dvohp006:/informix/v11# oncheck -cr > Validating IBM Informix Dynamic Server reserved pages > > Validating PAGE_PZERO... > > Validating PAGE_CONFIG... > > Validating PAGE_1CKPT & PAGE_2CKPT... > > Using check point page PAGE_2CKPT. > > Validating PAGE_1DBSP & PAGE_2DBSP... > > Using DBspace page PAGE_2DBSP. > > Validating PAGE_1PCHUNK & PAGE_2PCHUNK... > > Using primary chunk page PAGE_2PCHUNK. > > Validating PAGE_1ARCH & PAGE_2ARCH... > > Using archive page PAGE_1ARCH. > > informix@dvohp006:/informix/v11# oncheck -ce sbs_photospace01 > > Validating extents for Space 'sbs_photospace01' ... > > Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p) > > 11 /informix/v11/dbspaces/autorizador/sbs_photospc01 2560000 4178 1059947 > > Note: 'Used' = used metadata space + used user data space. > > 'Free' = free user data space. > > informix@dvohp006:/informix/v11# oncheck -cS > > Validating space 'cdr_sbspace01' ... > > sbspace Metadata Partition Partnum Used Free > cdr_sbspace01:'informix'.TBLSpace 0x700001 6 44 > cdr_sbspace01:'informix'.sbspace_desc 0x700002 2 2 > cdr_sbspace01:'informix'.chunk_adjunc 0x700003 2 2 > cdr_sbspace01:'informix'.LO_ud_free 0x700004 2 5529 > cdr_sbspace01:'informix'.LO_hdr_partn 0x700005 10 106186 > > Large Objects > ID Ref Size Allocced Creat Last > Sbs# Chk# Seq# Cnt (Bytes) Pages Extns Flags Modified > ---- ---- ----- ---- ---------- -------- ----- ----- ------------------------ > > 7 8 3 1 3 1 1 L-N-H Wed Aug 12 11:44:07 2009 > > Validating space 'sbs_photospace01' ... > > sbspace Metadata Partition Partnum Used Free > sbs_photospace01:'informix'.TBLSpace 0x900001 6 44 > sbs_photospace01:'informix'.sbspace_desc 0x900002 2 2 > sbs_photospace01:'informix'.chunk_adjunc 0x900003 2 2 > sbs_photospace01:'informix'.LO_ud_free 0x900004 2 2943 > sbs_photospace01:'informix'.LO_hdr_partn 0x900005 1 1171 > > informix@dvohp006:/informix/v11# oncheck -cD imagem > > TBLspace data check for imagem:informix.systables > TBLspace data check for imagem:informi

↪ replying to Art Kagel

Alberto Romeu — Thu, 17 Sep 2009 16:21:05 — source: IIUG Forums & Mailing Lists

Art: The error has changed now... Look: MODIFY: ESC = Done editing CTRL-A = Typeover/Insert CTRL-R = Redraw CTRL-X = Delete character CTRL-D = Delete rest of line -- 10 to 20 of 20 ----- imagem@df06_d ---------- Press CTRL-W for Help -------- NU_SEQUENCIAL INTEGER , ID_STATUS_ANEXO_GUIA INTEGER , DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , ID_PRESTADOR INTEGER , ID_OPERADORA INTEGER , ID_MAQUINA INTEGER , NM_SERVICO VARCHAR(100) , ID_THREAD INTEGER , IMAGEM BLOB IN sbs_photospace01 ) EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; 201: A syntax error has occurred. The cursor stopped before "IN sbs_ photospace01". I don't know if I'm wrong, but... in my opinion, I can't put just one column inside a SBSpace; I must store the entire table, opposite a Blobspace... Is that right? Tks, Alberto. De: Art Kagel [mailto:art.kagel@gmail.com] Enviada em: quinta-feira, 17 de setembro de 2009 13:06 Para: Alberto Romeu Pessonio Filho Assunto: Re: Creating a table with BLOB in a SBSpace [17064] Yes, what I didn't notice is that you are trying to put the entire table into the sbspace. Tables live in regular dbspaces, you would place ONLY the BLOB column into the sb_space. So, that should be: CREATE TABLE TB_ANEXO_GUIA1 ( ID_ANEXO_GUIA INTEGER NOT NULL, CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, CD_CARTEIRINHA VARCHAR(30) , COD_OPERADORA_ANS VARCHAR(6) , NM_ARQUIVO VARCHAR(255) , DS_EXTENSAO_ARQUIVO VARCHAR(3) , NU_TAMANHO_ARQUIVO BIGINT , NU_SEQUENCIAL INTEGER , ID_STATUS_ANEXO_GUIA INTEGER , DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , ID_PRESTADOR INTEGER , ID_OPERADORA INTEGER , ID_MAQUINA INTEGER , NM_SERVICO VARCHAR(100) ,ID_THREAD INTEGER , IMAGEM BLOB IN sbs_photospace01 ) IN some_normal_dbspace EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; Art S. Kagel Oninit (www.oninit.com <http://www.oninit.com>; ) IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 17, 2009 at 12:00 PM, Alberto Romeu Pessonio Filho <arfilho@orizonbrasil.com.br> wrote: Hi Art!!! Ok, but i changed the datatype from BYTE to BLOB and the error still remain. SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit Modify the current SQL statements using the SQL editor. ----------------------- imagem@df06_d ---------- Press CTRL-W for Help -------- CREATE TABLE TB_ANEXO_GUIA1 ( ID_ANEXO_GUIA INTEGER NOT NULL, CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, CD_CARTEIRINHA VARCHAR(30) , COD_OPERADORA_ANS VARCHAR(6) , NM_ARQUIVO VARCHAR(255) , DS_EXTENSAO_ARQUIVO VARCHAR(3) , NU_TAMANHO_ARQUIVO BIGINT , NU_SEQUENCIAL INTEGER , ID_STATUS_ANEXO_GUIA INTEGER , DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , ID_PRESTADOR INTEGER , ID_OPERADORA INTEGER , ID_MAQUINA INTEGER , NM_SERVICO VARCHAR(100) ,ID_THREAD INTEGER , IMAGEM BLOB ) IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; 261: Cannot create file for table (informix.tb_anexo_guia1). 130: ISAM error: no such DBspace Tks anyway, Alberto Pessonio. -----Mensagem original----- De: Art Kagel [mailto:art.kagel@gmail.com <mailto:art.kagel@gmail.com> ] Enviada em: quinta-feira, 17 de setembro de 2009 12:53 Para: Alberto Romeu Pessonio Filho Assunto: Re: Creating a table with BLOB in a SBSpace [17064] You cannot place BYTE or TEXT columns in sbspace (SmartBlobSpace). BYTE and TEXT are simple blob objects and can only be placed IN TABLE or in a regular BLOBSpace - onspaces -c -b. Art Art S. Kagel Oninit (www.oninit.com <http://www.oninit.com>; ) IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 17, 2009 at 11:24 AM, ALBERTO ROMEU PESSONIO FILHO < arfilho@orizonbrasil.com.br <mailto:arfilho@orizonbrasil.com.br> > wrote: > Hi everyone! > > Version of IDS: 11.50 FC5 > OS: HP-UX 11.11 > > I'm trying to create a table with a BYTE datatype in a SBSpace. When i run > the > DDL statement on DBAccess, i've got the following error: > > CREATE TABLE TB_ANEXO_GUIA_1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) , > ID_THREAD INTEGER , > IMAGEM BYTE ) > IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > 261: Cannot create file for table (informix.tb_anexo_guia_1). > 130: ISAM error: no such DBspace> > I tried to change the datatype from BYTE to BLOB, but the error remains. I > created the database called "imagem" for use with a system thar store > images > in a regular DBSpace, but that table i'm trying to store in a SBSpace, > showed > on a onstat -d output below: > > IBM Informix Dynamic Server Version 11.50.FC5 -- On-Line -- Up 01:05:02 --> 1229596 Kbytes > > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > c00000002cc62028 1 0x40001 1 1 2048 N B informix rootdbs > c00000002ec27c38 2 0x40001 2 1 2048 N B informix physdbs > c00000002ec27dd0 3 0x40001 3 1 2048 N B informix llogdbs > c00000002ec28028 4 0x42001 4 1 2048 N TB informix tempdbs01 > c00000002ec281c0 5 0x42001 5 1 2048 N TB informix tempdbs02 > c00000002ec28358 6 0x40001 6 3 8192 N B informix datadbs01 > c00000002ec284f0 7 0x48001 8 1 2048 N SB informix cdr_sbspace01 > c00000002ec28688 8 0x40001 9 1 2048 N B informix cdr_dbspace01 > c00000002ec28820 9 0x48001 11 1 2048 N SB informix sbs_photospace01 > 9 active, 2047 maximum > > Chunks > address chunk/dbs offset size free bpages flags pathname > c00000002cc621c0 1 1 0 2560000 2527259 PO-B- > /informix/v11/dbspaces/autorizador/rootdbs@@

↪ replying to Alberto Romeu

Everett Mills — Thu, 17 Sep 2009 16:38:22 — source: IIUG Forums & Mailing Lists

> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Alberto > Romeu Pessonio Filho > Sent: Thursday, September 17, 2009 11:21 AM > To: ids@iiug.org > Subject: Re: Creating a table with BLOB in a SBSpace [17070] > > Art: > > The error has changed now... > > Look: > > MODIFY: ESC = Done editing CTRL-A = Typeover/Insert CTRL-R = > Redraw > > CTRL-X = Delete character CTRL-D = Delete rest of line > > -- 10 to 20 of 20 ----- imagem@df06_d ---------- Press CTRL-W for Help > -------- > > NU_SEQUENCIAL INTEGER , > > ID_STATUS_ANEXO_GUIA INTEGER , > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > ID_PRESTADOR INTEGER , > > ID_OPERADORA INTEGER , > > ID_MAQUINA INTEGER , > > NM_SERVICO VARCHAR(100) , > > ID_THREAD INTEGER , > > IMAGEM BLOB IN sbs_photospace01 ) > > EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > 201: A syntax error has occurred.> > The cursor stopped before "IN sbs_ photospace01". I don't know if I'm > wrong, but... in my opinion, I can't put just one column inside a > SBSpace; I must store the entire table, opposite a Blobspace... Is that > right? I haven't used BLOB columns, but if I'm reading the manual correctly, for a BLOB column, you leave the IN clause off and the engine assigns the sbspace used on the fly as you store your images are saved. So try this, instead: CREATE TABLE TB_ANEXO_GUIA1 ( ID_ANEXO_GUIA INTEGER NOT NULL, CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, CD_CARTEIRINHA VARCHAR(30) , COD_OPERADORA_ANS VARCHAR(6) , NM_ARQUIVO VARCHAR(255) , DS_EXTENSAO_ARQUIVO VARCHAR(3) , NU_TAMANHO_ARQUIVO BIGINT , NU_SEQUENCIAL INTEGER , ID_STATUS_ANEXO_GUIA INTEGER , DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , ID_PRESTADOR INTEGER , ID_OPERADORA INTEGER , ID_MAQUINA INTEGER , NM_SERVICO VARCHAR(100) , ID_THREAD INTEGER, IMAGEM BLOB) > Tks, > > Alberto. > > De: Art Kagel [mailto:art.kagel@gmail.com] > Enviada em: quinta-feira, 17 de setembro de 2009 13:06 > Para: Alberto Romeu Pessonio Filho > Assunto: Re: Creating a table with BLOB in a SBSpace [17064] > > Yes, what I didn't notice is that you are trying to put the entire table > into the sbspace. Tables live in regular dbspaces, you would place ONLY > the BLOB column into the sb_space. So, that should be: > > CREATE TABLE TB_ANEXO_GUIA1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) ,> ID_THREAD INTEGER > , > IMAGEM BLOB IN sbs_photospace01 > ) > IN some_normal_dbspace EXTENT SIZE 102400 NEXT SIZE 102400 lock mode > row; > > Art S. Kagel > Oninit (www.oninit.com <http://www.oninit.com>; ) > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Oninit, the IIUG, nor any other > organization with which I am associated either explicitly or implicitly. > Neither do those opinions reflect those of other individuals affiliated > with any entity with which I am affiliated nor those of the entities > themselves. > > On Thu, Sep 17, 2009 at 12:00 PM, Alberto Romeu Pessonio Filho > <arfilho@orizonbrasil.com.br> wrote: > > Hi Art!!! > > Ok, but i changed the datatype from BYTE to BLOB and the error still > remain. > > SQL: New Run Modify Use-editor Output Choose Save Info Drop > Exit > Modify the current SQL statements using the SQL editor. > > ----------------------- imagem@df06_d ---------- Press CTRL-W for Help > -------- > > CREATE TABLE TB_ANEXO_GUIA1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) ,> ID_THREAD INTEGER > , > IMAGEM BLOB > ) > IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > 261: Cannot create file for table (informix.tb_anexo_guia1). > 130: ISAM error: no such DBspace> > Tks anyway, > Alberto Pessonio. > > -----Mensagem original----- > De: Art Kagel [mailto:art.kagel@gmail.com <mailto:art.kagel@gmail.com> ] > Enviada em: quinta-feira, 17 de setembro de 2009 12:53 > Para: Alberto Romeu Pessonio Filho > Assunto: Re: Creating a table with BLOB in a SBSpace [17064] > > You cannot place BYTE or TEXT columns in sbspace (SmartBlobSpace). BYTE > and > TEXT are simple blob objects and can only be placed IN TABLE or in a > regular > BLOBSpace - onspaces -c -b. > > Art > > Art S. Kagel > Oninit (www.oninit.com <http://www.oninit.com>; ) > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Oninit, the IIUG, nor any other > organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any > entity > with which I am affiliated nor those of the entities themselves. > > On Thu, Sep 17, 2009 at 11:24 AM, ALBERTO ROMEU PESSONIO FILHO < > arfilho@orizonbrasil.com.br <mailto:arfilho@orizonbrasil.com.br> > > wrote: > > > Hi everyone! > > > > Version of IDS: 11.50 FC5 > > OS: HP-UX 11.11 > > > > I'm trying to create a table with a BYTE datatype in a SBSpace. When i > run > > the > > DDL statement on DBAccess, i've got the following error: > > > > CREATE TABLE TB_ANEXO_GUIA_1 > > ( > > ID_ANEXO_GUIA INTEGER NOT NULL, > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > CD_CARTEIRINHA VARCHAR(30) , > > COD_OPERADORA_ANS VARCHAR(6) , > > NM_ARQUIVO VARCHAR(255) , > > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > > NU_TAMANHO_ARQUIVO BIGINT , > > NU_SEQUENCIAL INTEGER , > > ID_STATUS_ANEXO_GUIA INTEGER , > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > ID_PRESTADOR INTEGER , > > ID_OPERADORA INTEGER , > > ID_MAQUINA INTEGER , > > NM_SERVICO VARCHAR(100) ,> > ID_THREAD INTEGER ,@@NL

↪ replying to Alberto Romeu

Art Kagel — Thu, 17 Sep 2009 17:05:07 — source: IIUG Forums & Mailing Lists

Sorry, senior moment. No, you do not put a table into a smart blobspace, only a column, but the syntax is different than for simple blobspaces. You need to use the PUT() clause at the table level: CREATE TABLE TB_ANEXO_GUIA1 ( ID_ANEXO_GUIA INTEGER NOT NULL, CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, CD_CARTEIRINHA VARCHAR(30) , COD_OPERADORA_ANS VARCHAR(6) , NM_ARQUIVO VARCHAR(255) , DS_EXTENSAO_ARQUIVO VARCHAR(3) , NU_TAMANHO_ARQUIVO BIGINT , NU_SEQUENCIAL INTEGER , ID_STATUS_ANEXO_GUIA INTEGER , DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , ID_PRESTADOR INTEGER , ID_OPERADORA INTEGER , ID_MAQUINA INTEGER , NM_SERVICO VARCHAR(100) ,ID_THREAD INTEGER , IMAGEM BLOB ) PUT IMAGEM IN (sbs_photospace01) EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 17, 2009 at 12:21 PM, Alberto Romeu Pessonio Filho < arfilho@orizonbrasil.com.br> wrote: > Art: > > The error has changed now... > > Look: > > MODIFY: ESC = Done editing CTRL-A = Typeover/Insert CTRL-R = > Redraw > > CTRL-X = Delete character CTRL-D = Delete rest of line > > -- 10 to 20 of 20 ----- imagem@df06_d ---------- Press CTRL-W for Help > -------- > > NU_SEQUENCIAL INTEGER , > > ID_STATUS_ANEXO_GUIA INTEGER , > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > ID_PRESTADOR INTEGER , > > ID_OPERADORA INTEGER , > > ID_MAQUINA INTEGER , > > NM_SERVICO VARCHAR(100) , > > ID_THREAD INTEGER , > > IMAGEM BLOB IN sbs_photospace01 ) > > EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > 201: A syntax error has occurred.> > The cursor stopped before "IN sbs_ photospace01". I don't know if I'm > wrong, but... in my opinion, I can't put just one column inside a > SBSpace; I must store the entire table, opposite a Blobspace... Is that > right? > > Tks, > > Alberto. > > De: Art Kagel [mailto:art.kagel@gmail.com] > Enviada em: quinta-feira, 17 de setembro de 2009 13:06 > Para: Alberto Romeu Pessonio Filho > Assunto: Re: Creating a table with BLOB in a SBSpace [17064] > > Yes, what I didn't notice is that you are trying to put the entire table > into the sbspace. Tables live in regular dbspaces, you would place ONLY > the BLOB column into the sb_space. So, that should be: > > CREATE TABLE TB_ANEXO_GUIA1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) ,> ID_THREAD INTEGER > , > IMAGEM BLOB IN sbs_photospace01 > ) > IN some_normal_dbspace EXTENT SIZE 102400 NEXT SIZE 102400 lock mode > row; > > Art S. Kagel > Oninit (www.oninit.com <http://www.oninit.com>; ) > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Oninit, the IIUG, nor any other > organization with which I am associated either explicitly or implicitly. > Neither do those opinions reflect those of other individuals affiliated > with any entity with which I am affiliated nor those of the entities > themselves. > > On Thu, Sep 17, 2009 at 12:00 PM, Alberto Romeu Pessonio Filho > <arfilho@orizonbrasil.com.br> wrote: > > Hi Art!!! > > Ok, but i changed the datatype from BYTE to BLOB and the error still > remain. > > SQL: New Run Modify Use-editor Output Choose Save Info Drop > Exit > Modify the current SQL statements using the SQL editor. > > ----------------------- imagem@df06_d ---------- Press CTRL-W for Help > -------- > > CREATE TABLE TB_ANEXO_GUIA1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) ,> ID_THREAD INTEGER > , > IMAGEM BLOB > ) > IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > 261: Cannot create file for table (informix.tb_anexo_guia1). > 130: ISAM error: no such DBspace> > Tks anyway, > Alberto Pessonio. > > -----Mensagem original----- > De: Art Kagel [mailto:art.kagel@gmail.com <mailto:art.kagel@gmail.com> ] > Enviada em: quinta-feira, 17 de setembro de 2009 12:53 > Para: Alberto Romeu Pessonio Filho > Assunto: Re: Creating a table with BLOB in a SBSpace [17064] > > You cannot place BYTE or TEXT columns in sbspace (SmartBlobSpace). BYTE > and > TEXT are simple blob objects and can only be placed IN TABLE or in a > regular > BLOBSpace - onspaces -c -b. > > Art > > Art S. Kagel > Oninit (www.oninit.com <http://www.oninit.com>; ) > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Oninit, the IIUG, nor any other > organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any > entity > with which I am affiliated nor those of the entities themselves. > > On Thu, Sep 17, 2009 at 11:24 AM, ALBERTO ROMEU PESSONIO FILHO < > arfilho@orizonbrasil.com.br <mailto:arfilho@orizonbrasil.com.br> > > wrote: > > > Hi everyone! > > > > Version of IDS: 11.50 FC5 > > OS: HP-UX 11.11 > > > > I'm trying to create a table with a BYTE datatype in a SBSpace. When i > run > > the > > DDL statement on DBAccess, i've got the following error: > > > > CREATE TABLE TB_ANEXO_GUIA_1 > > ( > > ID_ANEXO_GUIA INTEGER NOT NULL, > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > CD_CARTEIRINHA VARCHAR(30) , > > COD_OPERADORA_ANS VARCHAR(6) , > > NM_ARQUIVO VARCHAR(255) , > > DS_EXTENSAO_ARQUIVO VARCHAR(3) ,> > NU_TAMANHO_ARQUIVO BIGINT ,@@NL

↪ replying to Everett Mills

Art Kagel — Thu, 17 Sep 2009 17:11:07 — source: IIUG Forums & Mailing Lists

It will work that way, but if you want to use a specific sbspace, you need to use the PUT clause. I was just having a senior moment there. See my corrected post. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 17, 2009 at 12:38 PM, Everett Mills < Everett.Mills@nationalbeef.com> wrote: > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Alberto > > Romeu Pessonio Filho > > Sent: Thursday, September 17, 2009 11:21 AM > > To: ids@iiug.org > > Subject: Re: Creating a table with BLOB in a SBSpace [17070] > > > > Art: > > > > The error has changed now... > > > > Look: > > > > MODIFY: ESC = Done editing CTRL-A = Typeover/Insert CTRL-R = > > Redraw > > > > CTRL-X = Delete character CTRL-D = Delete rest of line > > > > -- 10 to 20 of 20 ----- imagem@df06_d ---------- Press CTRL-W for Help > > -------- > > > > NU_SEQUENCIAL INTEGER , > > > > ID_STATUS_ANEXO_GUIA INTEGER , > > > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > > > ID_PRESTADOR INTEGER , > > > > ID_OPERADORA INTEGER , > > > > ID_MAQUINA INTEGER , > > > > NM_SERVICO VARCHAR(100) , > > > > ID_THREAD INTEGER , > > > > IMAGEM BLOB IN sbs_photospace01 ) > > > > EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > > > 201: A syntax error has occurred.> > > > The cursor stopped before "IN sbs_ photospace01". I don't know if I'm > > wrong, but... in my opinion, I can't put just one column inside a > > SBSpace; I must store the entire table, opposite a Blobspace... Is > that > > right? > > I haven't used BLOB columns, but if I'm reading the manual correctly, > for a BLOB column, you leave the IN clause off and the engine assigns > the sbspace used on the fly as you store your images are saved. So try > this, instead: > > CREATE TABLE TB_ANEXO_GUIA1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) , > ID_THREAD INTEGER, > IMAGEM BLOB)> > > Tks, > > > > Alberto. > > > > De: Art Kagel [mailto:art.kagel@gmail.com] > > Enviada em: quinta-feira, 17 de setembro de 2009 13:06 > > Para: Alberto Romeu Pessonio Filho > > Assunto: Re: Creating a table with BLOB in a SBSpace [17064] > > > > Yes, what I didn't notice is that you are trying to put the entire > table > > into the sbspace. Tables live in regular dbspaces, you would place > ONLY > > the BLOB column into the sb_space. So, that should be: > > > > CREATE TABLE TB_ANEXO_GUIA1 > > ( > > ID_ANEXO_GUIA INTEGER NOT NULL, > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > CD_CARTEIRINHA VARCHAR(30) , > > COD_OPERADORA_ANS VARCHAR(6) , > > NM_ARQUIVO VARCHAR(255) , > > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > > NU_TAMANHO_ARQUIVO BIGINT , > > NU_SEQUENCIAL INTEGER , > > ID_STATUS_ANEXO_GUIA INTEGER , > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > ID_PRESTADOR INTEGER , > > ID_OPERADORA INTEGER , > > ID_MAQUINA INTEGER , > > NM_SERVICO VARCHAR(100) ,> > ID_THREAD INTEGER > > , > > IMAGEM BLOB IN sbs_photospace01 > > ) > > IN some_normal_dbspace EXTENT SIZE 102400 NEXT SIZE 102400 lock mode > > row; > > > > Art S. Kagel > > Oninit (www.oninit.com <http://www.oninit.com>; ) > > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > and do not reflect on my employer, Oninit, the IIUG, nor any other > > organization with which I am associated either explicitly or > implicitly. > > Neither do those opinions reflect those of other individuals > affiliated > > with any entity with which I am affiliated nor those of the entities > > themselves. > > > > On Thu, Sep 17, 2009 at 12:00 PM, Alberto Romeu Pessonio Filho > > <arfilho@orizonbrasil.com.br> wrote: > > > > Hi Art!!! > > > > Ok, but i changed the datatype from BYTE to BLOB and the error still > > remain. > > > > SQL: New Run Modify Use-editor Output Choose Save Info Drop > > Exit > > Modify the current SQL statements using the SQL editor. > > > > ----------------------- imagem@df06_d ---------- Press CTRL-W for Help > > -------- > > > > CREATE TABLE TB_ANEXO_GUIA1 > > ( > > ID_ANEXO_GUIA INTEGER NOT NULL, > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > CD_CARTEIRINHA VARCHAR(30) , > > COD_OPERADORA_ANS VARCHAR(6) , > > NM_ARQUIVO VARCHAR(255) , > > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > > NU_TAMANHO_ARQUIVO BIGINT , > > NU_SEQUENCIAL INTEGER , > > ID_STATUS_ANEXO_GUIA INTEGER , > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > ID_PRESTADOR INTEGER , > > ID_OPERADORA INTEGER , > > ID_MAQUINA INTEGER , > > NM_SERVICO VARCHAR(100) ,> > ID_THREAD INTEGER > > , > > IMAGEM BLOB > > ) > > IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > > > 261: Cannot create file for table (informix.tb_anexo_guia1). > > 130: ISAM error: no such DBspace> > > > Tks anyway, > > Alberto Pessonio. > > > > -----Mensagem original----- > > De: Art Kagel [mailto:art.kagel@gmail.com <mailto:art.kagel@gmail.com> > ] > > Enviada em: quinta-feira, 17 de setembro de 2009 12:53 > > Para: Alberto Romeu Pessonio Filho > > Assunto: Re: Creating a table with BLOB in a SBSpace [17064] > > > > You cannot place BYTE or TEXT columns in sbspace (SmartBlobSpace). > BYTE > > and > > TEXT are simple blob objects and can only be placed IN TABLE or in a > > regular > > BLOBSpace - onspaces -c -b. > > > > Art > > > > Art S. Kagel > > Oninit (www.oninit.com <http://www.oninit.com>; ) > > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > and > > do not reflect on my employer, Oninit, the IIUG, nor any other > > organization > > with which I am associated either explicitly or implicitly. Neither do > > those opinions reflect those of other individuals affiliated with any > > entity > > with

↪ replying to Art Kagel

Alberto Romeu — Thu, 17 Sep 2009 17:12:59 — source: IIUG Forums & Mailing Lists

-----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art Kagel Enviada em: quinta-feira, 17 de setembro de 2009 14:11 Para: ids@iiug.org Assunto: Re: Creating a table with BLOB in a SBSpace [17073] It will work that way, but if you want to use a specific sbspace, you need to use the PUT clause. I was just having a senior moment there. See my corrected post. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 17, 2009 at 12:38 PM, Everett Mills < Everett.Mills@nationalbeef.com> wrote: > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Alberto > > Romeu Pessonio Filho > > Sent: Thursday, September 17, 2009 11:21 AM > > To: ids@iiug.org > > Subject: Re: Creating a table with BLOB in a SBSpace [17070] > > > > Art: > > > > The error has changed now... > > > > Look: > > > > MODIFY: ESC = Done editing CTRL-A = Typeover/Insert CTRL-R = > > Redraw > > > > CTRL-X = Delete character CTRL-D = Delete rest of line > > > > -- 10 to 20 of 20 ----- imagem@df06_d ---------- Press CTRL-W for Help > > -------- > > > > NU_SEQUENCIAL INTEGER , > > > > ID_STATUS_ANEXO_GUIA INTEGER , > > > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > > > ID_PRESTADOR INTEGER , > > > > ID_OPERADORA INTEGER , > > > > ID_MAQUINA INTEGER , > > > > NM_SERVICO VARCHAR(100) , > > > > ID_THREAD INTEGER , > > > > IMAGEM BLOB IN sbs_photospace01 ) > > > > EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > > > 201: A syntax error has occurred.> > > > The cursor stopped before "IN sbs_ photospace01". I don't know if I'm > > wrong, but... in my opinion, I can't put just one column inside a > > SBSpace; I must store the entire table, opposite a Blobspace... Is > that > > right? > > I haven't used BLOB columns, but if I'm reading the manual correctly, > for a BLOB column, you leave the IN clause off and the engine assigns > the sbspace used on the fly as you store your images are saved. So try > this, instead: > > CREATE TABLE TB_ANEXO_GUIA1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) , > ID_THREAD INTEGER, > IMAGEM BLOB)> > > Tks, > > > > Alberto. > > > > De: Art Kagel [mailto:art.kagel@gmail.com] > > Enviada em: quinta-feira, 17 de setembro de 2009 13:06 > > Para: Alberto Romeu Pessonio Filho > > Assunto: Re: Creating a table with BLOB in a SBSpace [17064] > > > > Yes, what I didn't notice is that you are trying to put the entire > table > > into the sbspace. Tables live in regular dbspaces, you would place > ONLY > > the BLOB column into the sb_space. So, that should be: > > > > CREATE TABLE TB_ANEXO_GUIA1 > > ( > > ID_ANEXO_GUIA INTEGER NOT NULL, > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > CD_CARTEIRINHA VARCHAR(30) , > > COD_OPERADORA_ANS VARCHAR(6) , > > NM_ARQUIVO VARCHAR(255) , > > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > > NU_TAMANHO_ARQUIVO BIGINT , > > NU_SEQUENCIAL INTEGER , > > ID_STATUS_ANEXO_GUIA INTEGER , > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > ID_PRESTADOR INTEGER , > > ID_OPERADORA INTEGER , > > ID_MAQUINA INTEGER , > > NM_SERVICO VARCHAR(100) ,> > ID_THREAD INTEGER > > , > > IMAGEM BLOB IN sbs_photospace01 > > ) > > IN some_normal_dbspace EXTENT SIZE 102400 NEXT SIZE 102400 lock mode > > row; > > > > Art S. Kagel > > Oninit (www.oninit.com <http://www.oninit.com>; ) > > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > and do not reflect on my employer, Oninit, the IIUG, nor any other > > organization with which I am associated either explicitly or > implicitly. > > Neither do those opinions reflect those of other individuals > affiliated > > with any entity with which I am affiliated nor those of the entities > > themselves. > > > > On Thu, Sep 17, 2009 at 12:00 PM, Alberto Romeu Pessonio Filho > > <arfilho@orizonbrasil.com.br> wrote: > > > > Hi Art!!! > > > > Ok, but i changed the datatype from BYTE to BLOB and the error still > > remain. > > > > SQL: New Run Modify Use-editor Output Choose Save Info Drop > > Exit > > Modify the current SQL statements using the SQL editor. > > > > ----------------------- imagem@df06_d ---------- Press CTRL-W for Help > > -------- > > > > CREATE TABLE TB_ANEXO_GUIA1 > > ( > > ID_ANEXO_GUIA INTEGER NOT NULL, > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > CD_CARTEIRINHA VARCHAR(30) , > > COD_OPERADORA_ANS VARCHAR(6) , > > NM_ARQUIVO VARCHAR(255) , > > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > > NU_TAMANHO_ARQUIVO BIGINT , > > NU_SEQUENCIAL INTEGER , > > ID_STATUS_ANEXO_GUIA INTEGER , > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > ID_PRESTADOR INTEGER , > > ID_OPERADORA INTEGER , > > ID_MAQUINA INTEGER , > > NM_SERVICO VARCHAR(100) ,> > ID_THREAD INTEGER > > , > > IMAGEM BLOB > > ) > > IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > > > 261: Cannot create file for table (informix.tb_anexo_guia1). > > 130: ISAM error: no such DBspace> > > > Tks anyway, > > Alberto Pessonio. > > > > -----Mensagem original----- > > De: Art Kagel [mailto:art.kagel@gmail.com <mailto:art.kagel@gmail.com> > ] > > Enviada em: quinta-feira, 17 de setembro de 2009 12:53 > > Para: Alberto Romeu Pessonio Filho > > Assunto: Re: Creating a table with BLOB in a SBSpace [17064] > > > > You cannot place BYTE or TEXT columns in sbspace (SmartBlobSpace). > BYTE > > and > > TEXT are simple blob objects and can only be placed IN TABLE or in a > > regular > > BLOBSpace - onspaces -c -b. > > > > Art > > > > Art S. Kagel > > Oninit (www.oninit.com <http://www.oninit.com>; ) > > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) > > > > Disclaimer: Please k

↪ replying to Art Kagel

Alberto Romeu — Thu, 17 Sep 2009 17:26:34 — source: IIUG Forums & Mailing Lists

Art: Perfect!!! I created the table. No words to tell you how grateful I am!!! I'd like to thank Bogdam Botez and Everett Mills, as well. Great Forum!!! Unfortunately, I've searched all manuals of IDS I have (and I have about 40 manuals), but I didn't find any example of how to create a table using BLOBS. Maybe, I didn't see at the moment, because I was in a hurry. Any hint of a specific document / white paper, etc... that I can use as a reference to work with datablades on IDS and Image Datablade Module? Thank you all, Alberto Pessonio Orizon Brasil www.orizonbrasil.com.br -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art Kagel Enviada em: quinta-feira, 17 de setembro de 2009 14:11 Para: ids@iiug.org Assunto: Re: Creating a table with BLOB in a SBSpace [17073] It will work that way, but if you want to use a specific sbspace, you need to use the PUT clause. I was just having a senior moment there. See my corrected post. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 17, 2009 at 12:38 PM, Everett Mills < Everett.Mills@nationalbeef.com> wrote: > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Alberto > > Romeu Pessonio Filho > > Sent: Thursday, September 17, 2009 11:21 AM > > To: ids@iiug.org > > Subject: Re: Creating a table with BLOB in a SBSpace [17070] > > > > Art: > > > > The error has changed now... > > > > Look: > > > > MODIFY: ESC = Done editing CTRL-A = Typeover/Insert CTRL-R = > > Redraw > > > > CTRL-X = Delete character CTRL-D = Delete rest of line > > > > -- 10 to 20 of 20 ----- imagem@df06_d ---------- Press CTRL-W for Help > > -------- > > > > NU_SEQUENCIAL INTEGER , > > > > ID_STATUS_ANEXO_GUIA INTEGER , > > > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > > > ID_PRESTADOR INTEGER , > > > > ID_OPERADORA INTEGER , > > > > ID_MAQUINA INTEGER , > > > > NM_SERVICO VARCHAR(100) , > > > > ID_THREAD INTEGER , > > > > IMAGEM BLOB IN sbs_photospace01 ) > > > > EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > > > 201: A syntax error has occurred.> > > > The cursor stopped before "IN sbs_ photospace01". I don't know if I'm > > wrong, but... in my opinion, I can't put just one column inside a > > SBSpace; I must store the entire table, opposite a Blobspace... Is > that > > right? > > I haven't used BLOB columns, but if I'm reading the manual correctly, > for a BLOB column, you leave the IN clause off and the engine assigns > the sbspace used on the fly as you store your images are saved. So try > this, instead: > > CREATE TABLE TB_ANEXO_GUIA1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) , > ID_THREAD INTEGER, > IMAGEM BLOB)> > > Tks, > > > > Alberto. > > > > De: Art Kagel [mailto:art.kagel@gmail.com] > > Enviada em: quinta-feira, 17 de setembro de 2009 13:06 > > Para: Alberto Romeu Pessonio Filho > > Assunto: Re: Creating a table with BLOB in a SBSpace [17064] > > > > Yes, what I didn't notice is that you are trying to put the entire > table > > into the sbspace. Tables live in regular dbspaces, you would place > ONLY > > the BLOB column into the sb_space. So, that should be: > > > > CREATE TABLE TB_ANEXO_GUIA1 > > ( > > ID_ANEXO_GUIA INTEGER NOT NULL, > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > CD_CARTEIRINHA VARCHAR(30) , > > COD_OPERADORA_ANS VARCHAR(6) , > > NM_ARQUIVO VARCHAR(255) , > > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > > NU_TAMANHO_ARQUIVO BIGINT , > > NU_SEQUENCIAL INTEGER , > > ID_STATUS_ANEXO_GUIA INTEGER , > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > ID_PRESTADOR INTEGER , > > ID_OPERADORA INTEGER , > > ID_MAQUINA INTEGER , > > NM_SERVICO VARCHAR(100) ,> > ID_THREAD INTEGER > > , > > IMAGEM BLOB IN sbs_photospace01 > > ) > > IN some_normal_dbspace EXTENT SIZE 102400 NEXT SIZE 102400 lock mode > > row; > > > > Art S. Kagel > > Oninit (www.oninit.com <http://www.oninit.com>; ) > > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > and do not reflect on my employer, Oninit, the IIUG, nor any other > > organization with which I am associated either explicitly or > implicitly. > > Neither do those opinions reflect those of other individuals > affiliated > > with any entity with which I am affiliated nor those of the entities > > themselves. > > > > On Thu, Sep 17, 2009 at 12:00 PM, Alberto Romeu Pessonio Filho > > <arfilho@orizonbrasil.com.br> wrote: > > > > Hi Art!!! > > > > Ok, but i changed the datatype from BYTE to BLOB and the error still > > remain. > > > > SQL: New Run Modify Use-editor Output Choose Save Info Drop > > Exit > > Modify the current SQL statements using the SQL editor. > > > > ----------------------- imagem@df06_d ---------- Press CTRL-W for Help > > -------- > > > > CREATE TABLE TB_ANEXO_GUIA1 > > ( > > ID_ANEXO_GUIA INTEGER NOT NULL, > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > CD_CARTEIRINHA VARCHAR(30) , > > COD_OPERADORA_ANS VARCHAR(6) , > > NM_ARQUIVO VARCHAR(255) , > > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > > NU_TAMANHO_ARQUIVO BIGINT , > > NU_SEQUENCIAL INTEGER , > > ID_STATUS_ANEXO_GUIA INTEGER , > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > ID_PRESTADOR INTEGER , > > ID_OPERADORA INTEGER , > > ID_MAQUINA INTEGER , > > NM_SERVICO VARCHAR(100) ,> > ID_THREAD INTEGER > > , > > IMAGEM BLOB > > ) > > IN sbs_photospace01 EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > > > 261: Cannot create file for table (informix.tb_anexo_guia1). > > 130: ISAM error: no such DBspace> > > > Tks anyway, > > Alberto Pessonio. > > > > -----Mensagem original----- > > De: Art Kagel [mailto:art.kagel@g

↪ replying to Alberto Romeu

Art Kagel — Thu, 17 Sep 2009 17:58:26 — source: IIUG Forums & Mailing Lists

The only example is on p 2-223 of the Guide to SQL Syntax manual for IDS v 11.50xC4. If you have a different version of the manual, the page may be different, look up the PUT clause in the index and scroll down about a page or so from the beginning of that section for an example. The documentation of PUT that's linked from the CREATE TABLE statement has no examples. Oh, if you also want to place the table in a specific dbspace, the IN <dbspace> clause has to precede the PUT column IN... clause. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 17, 2009 at 1:26 PM, Alberto Romeu Pessonio Filho < arfilho@orizonbrasil.com.br> wrote: > Art: > > Perfect!!! I created the table. > > No words to tell you how grateful I am!!! > > I'd like to thank Bogdam Botez and Everett Mills, as well. > Great Forum!!! > > Unfortunately, I've searched all manuals of IDS I have (and I have about > 40 manuals), but I didn't find any example of how to create a table > using BLOBS. Maybe, I didn't see at the moment, because I was in a > hurry. Any hint of a specific document / white paper, etc... that I can > use as a reference to work with datablades on IDS and Image Datablade > Module? > > Thank you all, > Alberto Pessonio > Orizon Brasil > > www.orizonbrasil.com.br > > -----Mensagem original----- > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art > Kagel > Enviada em: quinta-feira, 17 de setembro de 2009 14:11 > Para: ids@iiug.org > Assunto: Re: Creating a table with BLOB in a SBSpace [17073] > > It will work that way, but if you want to use a specific sbspace, you > need > to use the PUT clause. I was just having a senior moment there. See my > corrected post. > > Art > > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Oninit, the IIUG, nor any other > organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any > entity > with which I am affiliated nor those of the entities themselves. > > On Thu, Sep 17, 2009 at 12:38 PM, Everett Mills < > Everett.Mills@nationalbeef.com> wrote: > > > > -----Original Message----- > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf > Of > > Alberto > > > Romeu Pessonio Filho > > > Sent: Thursday, September 17, 2009 11:21 AM > > > To: ids@iiug.org > > > Subject: Re: Creating a table with BLOB in a SBSpace [17070] > > > > > > Art: > > > > > > The error has changed now... > > > > > > Look: > > > > > > MODIFY: ESC = Done editing CTRL-A = Typeover/Insert CTRL-R = > > > Redraw > > > > > > CTRL-X = Delete character CTRL-D = Delete rest of line > > > > > > -- 10 to 20 of 20 ----- imagem@df06_d ---------- Press CTRL-W for > Help > > > -------- > > > > > > NU_SEQUENCIAL INTEGER , > > > > > > ID_STATUS_ANEXO_GUIA INTEGER , > > > > > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > > > > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > > > > > ID_PRESTADOR INTEGER , > > > > > > ID_OPERADORA INTEGER , > > > > > > ID_MAQUINA INTEGER , > > > > > > NM_SERVICO VARCHAR(100) , > > > > > > ID_THREAD INTEGER , > > > > > > IMAGEM BLOB IN sbs_photospace01 ) > > > > > > EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > > > > > 201: A syntax error has occurred.> > > > > > The cursor stopped before "IN sbs_ photospace01". I don't know if > I'm > > > wrong, but... in my opinion, I can't put just one column inside a > > > SBSpace; I must store the entire table, opposite a Blobspace... Is > > that > > > right? > > > > I haven't used BLOB columns, but if I'm reading the manual correctly, > > for a BLOB column, you leave the IN clause off and the engine assigns > > the sbspace used on the fly as you store your images are saved. So try > > > this, instead: > > > > CREATE TABLE TB_ANEXO_GUIA1 > > ( > > ID_ANEXO_GUIA INTEGER NOT NULL, > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > CD_CARTEIRINHA VARCHAR(30) , > > COD_OPERADORA_ANS VARCHAR(6) , > > NM_ARQUIVO VARCHAR(255) , > > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > > NU_TAMANHO_ARQUIVO BIGINT , > > NU_SEQUENCIAL INTEGER , > > ID_STATUS_ANEXO_GUIA INTEGER , > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > ID_PRESTADOR INTEGER , > > ID_OPERADORA INTEGER , > > ID_MAQUINA INTEGER , > > NM_SERVICO VARCHAR(100) , > > ID_THREAD INTEGER, > > IMAGEM BLOB)> > > > > Tks, > > > > > > Alberto. > > > > > > De: Art Kagel [mailto:art.kagel@gmail.com] > > > Enviada em: quinta-feira, 17 de setembro de 2009 13:06 > > > Para: Alberto Romeu Pessonio Filho > > > Assunto: Re: Creating a table with BLOB in a SBSpace [17064] > > > > > > Yes, what I didn't notice is that you are trying to put the entire > > table > > > into the sbspace. Tables live in regular dbspaces, you would place > > ONLY > > > the BLOB column into the sb_space. So, that should be: > > > > > > CREATE TABLE TB_ANEXO_GUIA1 > > > ( > > > ID_ANEXO_GUIA INTEGER NOT NULL, > > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > > CD_CARTEIRINHA VARCHAR(30) , > > > COD_OPERADORA_ANS VARCHAR(6) , > > > NM_ARQUIVO VARCHAR(255) , > > > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > > > NU_TAMANHO_ARQUIVO BIGINT , > > > NU_SEQUENCIAL INTEGER , > > > ID_STATUS_ANEXO_GUIA INTEGER , > > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > > ID_PRESTADOR INTEGER , > > > ID_OPERADORA INTEGER , > > > ID_MAQUINA INTEGER , > > > NM_SERVICO VARCHAR(100) ,> > > ID_THREAD INTEGER > > > , > > > IMAGEM BLOB IN sbs_photospace01 > > > ) > > > IN some_normal_dbspace EXTENT SIZE 102400 NEXT SIZE 102400 lock mode > > > > row; > > > > > > Art S. Kagel > > > Oninit (www.oninit.com <http://www.oninit.com>; ) > > > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) > > > > > > Disclaimer: Please keep in mind that my own opinions are my own > > opinions > > > and do not reflect on my employer, Oninit, the IIUG, nor any other > > > organization with which I am associated either explicitly or > > implicitly. > > > Neither do those opinions reflect those of other individuals > > affiliated > > > with any entity with which I am affiliated nor those of the entities > > > > themselves. > > > > > > On Thu, Sep 17, 2009 at 12:00 PM, Alberto Romeu Pessonio Filho@@NL

↪ replying to Art Kagel

R Fo — Thu, 17 Sep 2009 18:20:58 — source: IIUG Forums & Mailing Lists

Hi friend Alberto... Try it ... CREATE TABLE TB_ANEXO_GUIA_1 ( ID_ANEXO_GUIA INTEGER NOT NULL, CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, CD_CARTEIRINHA VARCHAR(30) , COD_OPERADORA_ANS VARCHAR(6) , NM_ARQUIVO VARCHAR(255) , DS_EXTENSAO_ARQUIVO VARCHAR(3) , NU_TAMANHO_ARQUIVO BIGINT , NU_SEQUENCIAL INTEGER , ID_STATUS_ANEXO_GUIA INTEGER , DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , ID_PRESTADOR INTEGER , ID_OPERADORA INTEGER , ID_MAQUINA INTEGER , NM_SERVICO VARCHAR(100) , ID_THREAD INTEGER , IMAGEM BYTE IN sbs_photospace01 ) IN dbspace_for_other_columns EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; OR CREATE TABLE TB_ANEXO_GUIA_1 ( ID_ANEXO_GUIA INTEGER NOT NULL, CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, CD_CARTEIRINHA VARCHAR(30) , COD_OPERADORA_ANS VARCHAR(6) , NM_ARQUIVO VARCHAR(255) , DS_EXTENSAO_ARQUIVO VARCHAR(3) , NU_TAMANHO_ARQUIVO BIGINT , NU_SEQUENCIAL INTEGER , ID_STATUS_ANEXO_GUIA INTEGER , DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , ID_PRESTADOR INTEGER , ID_OPERADORA INTEGER , ID_MAQUINA INTEGER , NM_SERVICO VARCHAR(100) , ID_THREAD INTEGER , IMAGEM BYTE ) IN dbspace_for_other_columns IMAGEM in sbs_photospace01 EXTENT SIZE 102400NEXT SIZE 102400 lock mode row; I believe the first will work... if not, try second option ... BR R Ferronato > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: Creating a table with BLOB in a SBSpace [17076] > Date: Thu, 17 Sep 2009 13:58:26 -0400 > > The only example is on p 2-223 of the Guide to SQL Syntax manual for IDS v > 11.50xC4. If you have a different version of the manual, the page may be > different, look up the PUT clause in the index and scroll down about a page > or so from the beginning of that section for an example. The documentation > of PUT that's linked from the CREATE TABLE statement has no examples. Oh, > if you also want to place the table in a specific dbspace, the IN <dbspace> > clause has to precede the PUT column IN... clause. > > Art > > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any entity > with which I am affiliated nor those of the entities themselves. > > On Thu, Sep 17, 2009 at 1:26 PM, Alberto Romeu Pessonio Filho < > arfilho@orizonbrasil.com.br> wrote: > > > Art: > > > > Perfect!!! I created the table. > > > > No words to tell you how grateful I am!!! > > > > I'd like to thank Bogdam Botez and Everett Mills, as well. > > Great Forum!!! > > > > Unfortunately, I've searched all manuals of IDS I have (and I have about > > 40 manuals), but I didn't find any example of how to create a table > > using BLOBS. Maybe, I didn't see at the moment, because I was in a > > hurry. Any hint of a specific document / white paper, etc... that I can > > use as a reference to work with datablades on IDS and Image Datablade > > Module? > > > > Thank you all, > > Alberto Pessonio > > Orizon Brasil > > > > www.orizonbrasil.com.br > > > > -----Mensagem original----- > > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art > > Kagel > > Enviada em: quinta-feira, 17 de setembro de 2009 14:11 > > Para: ids@iiug.org > > Assunto: Re: Creating a table with BLOB in a SBSpace [17073] > > > > It will work that way, but if you want to use a specific sbspace, you > > need > > to use the PUT clause. I was just having a senior moment there. See my > > corrected post. > > > > Art > > > > Art S. Kagel > > Oninit (www.oninit.com) > > IIUG Board of Directors (art@iiug.org) > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and > > do not reflect on my employer, Oninit, the IIUG, nor any other > > organization > > with which I am associated either explicitly or implicitly. Neither do > > those opinions reflect those of other individuals affiliated with any > > entity > > with which I am affiliated nor those of the entities themselves. > > > > On Thu, Sep 17, 2009 at 12:38 PM, Everett Mills < > > Everett.Mills@nationalbeef.com> wrote: > > > > > > -----Original Message----- > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf > > Of > > > Alberto > > > > Romeu Pessonio Filho > > > > Sent: Thursday, September 17, 2009 11:21 AM > > > > To: ids@iiug.org > > > > Subject: Re: Creating a table with BLOB in a SBSpace [17070] > > > > > > > > Art: > > > > > > > > The error has changed now... > > > > > > > > Look: > > > > > > > > MODIFY: ESC = Done editing CTRL-A = Typeover/Insert CTRL-R = > > > > Redraw > > > > > > > > CTRL-X = Delete character CTRL-D = Delete rest of line > > > > > > > > -- 10 to 20 of 20 ----- imagem@df06_d ---------- Press CTRL-W for > > Help > > > > -------- > > > > > > > > NU_SEQUENCIAL INTEGER , > > > > > > > > ID_STATUS_ANEXO_GUIA INTEGER , > > > > > > > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > > > > > > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > > > > > > > ID_PRESTADOR INTEGER , > > > > > > > > ID_OPERADORA INTEGER , > > > > > > > > ID_MAQUINA INTEGER , > > > > > > > > NM_SERVICO VARCHAR(100) , > > > > > > > > ID_THREAD INTEGER , > > > > > > > > IMAGEM BLOB IN sbs_photospace01 ) > > > > > > > > EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > > > > > > > 201: A syntax error has occurred.> > > > > > > > The cursor stopped before "IN sbs_ photospace01". I don't know if > > I'm > > > > wrong, but... in my opinion, I can't put just one column inside a > > > > SBSpace; I must store the entire table, opposite a Blobspace... Is > > > that > > > > right? > > > > > > I haven't used BLOB columns, but if I'm reading the manual correctly, > > > for a BLOB column, you leave the IN clause off and the engine assigns > > > the sbspace used on the fly as you store your images are saved. So try > > > > > this, instead: > > > > > > CREATE TABLE TB_ANEXO_GUIA1 > > > ( > > > ID_ANEXO_GUIA INTEGER NOT NULL, > > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > > CD_CARTEIRINHA VARCHAR(30) , > > > COD_OPERADORA_ANS VARCHAR(6) , > > > NM_ARQUIVO VARCHAR(255) , > > > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > > > NU_TAMANHO_ARQUIVO BIGINT , > > > NU_SEQUENCIAL INTEGER , > > > ID_STATUS_ANEXO_GUIA INTEGER , > > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > > ID_PRESTADOR INTEGER , > > > ID_OPERADORA INTEGER , > > > ID_MAQUINA INTEGER , > > > NM_SERVICO VARCHAR(100) , > > > ID_THREAD INTEGER, > > > IMAGEM BLOB)> > > > > > > Tks, > > > > > > > > Albe

↪ replying to R Fo

R Fo — Thu, 17 Sep 2009 18:26:39 — source: IIUG Forums & Mailing Lists

Ops ... sorry .... now I saw the Art message .... It's late! > To: ids@iiug.org > From: roeferr@hotmail.com > Subject: RE: Creating a table with BLOB in a SBSpace [17077] > Date: Thu, 17 Sep 2009 14:20:58 -0400 > > Hi friend Alberto... > > Try it ... > > CREATE TABLE TB_ANEXO_GUIA_1 > ( ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) , > ID_THREAD INTEGER , > IMAGEM BYTE IN sbs_photospace01 ) > IN dbspace_for_other_columns EXTENT SIZE 102400 NEXT SIZE 102400 lock mode> row; > > OR > > CREATE TABLE TB_ANEXO_GUIA_1 > ( ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) , > ID_THREAD INTEGER , > IMAGEM BYTE ) > IN dbspace_for_other_columns IMAGEM in sbs_photospace01 EXTENT SIZE 102400> NEXT SIZE 102400 lock mode row; > > I believe the first will work... if not, try second option ... > > BR > > R Ferronato > > > To: ids@iiug.org > > From: art.kagel@gmail.com > > Subject: Re: Creating a table with BLOB in a SBSpace [17076] > > Date: Thu, 17 Sep 2009 13:58:26 -0400 > > > > The only example is on p 2-223 of the Guide to SQL Syntax manual for IDS v > > 11.50xC4. If you have a different version of the manual, the page may be > > different, look up the PUT clause in the index and scroll down about a page > > or so from the beginning of that section for an example. The documentation > > of PUT that's linked from the CREATE TABLE statement has no examples. Oh, > > if you also want to place the table in a specific dbspace, the IN <dbspace> > > clause has to precede the PUT column IN... clause. > > > > Art > > > > Art S. Kagel > > Oninit (www.oninit.com) > > IIUG Board of Directors (art@iiug.org) > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > > do not reflect on my employer, Oninit, the IIUG, nor any other organization > > with which I am associated either explicitly or implicitly. Neither do > > those opinions reflect those of other individuals affiliated with any entity > > with which I am affiliated nor those of the entities themselves. > > > > On Thu, Sep 17, 2009 at 1:26 PM, Alberto Romeu Pessonio Filho < > > arfilho@orizonbrasil.com.br> wrote: > > > > > Art: > > > > > > Perfect!!! I created the table. > > > > > > No words to tell you how grateful I am!!! > > > > > > I'd like to thank Bogdam Botez and Everett Mills, as well. > > > Great Forum!!! > > > > > > Unfortunately, I've searched all manuals of IDS I have (and I have about > > > 40 manuals), but I didn't find any example of how to create a table > > > using BLOBS. Maybe, I didn't see at the moment, because I was in a > > > hurry. Any hint of a specific document / white paper, etc... that I can > > > use as a reference to work with datablades on IDS and Image Datablade > > > Module? > > > > > > Thank you all, > > > Alberto Pessonio > > > Orizon Brasil > > > > > > www.orizonbrasil.com.br > > > > > > -----Mensagem original----- > > > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art > > > Kagel > > > Enviada em: quinta-feira, 17 de setembro de 2009 14:11 > > > Para: ids@iiug.org > > > Assunto: Re: Creating a table with BLOB in a SBSpace [17073] > > > > > > It will work that way, but if you want to use a specific sbspace, you > > > need > > > to use the PUT clause. I was just having a senior moment there. See my > > > corrected post. > > > > > > Art > > > > > > Art S. Kagel > > > Oninit (www.oninit.com) > > > IIUG Board of Directors (art@iiug.org) > > > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > > and > > > do not reflect on my employer, Oninit, the IIUG, nor any other > > > organization > > > with which I am associated either explicitly or implicitly. Neither do > > > those opinions reflect those of other individuals affiliated with any > > > entity > > > with which I am affiliated nor those of the entities themselves. > > > > > > On Thu, Sep 17, 2009 at 12:38 PM, Everett Mills < > > > Everett.Mills@nationalbeef.com> wrote: > > > > > > > > -----Original Message----- > > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf > > > Of > > > > Alberto > > > > > Romeu Pessonio Filho > > > > > Sent: Thursday, September 17, 2009 11:21 AM > > > > > To: ids@iiug.org > > > > > Subject: Re: Creating a table with BLOB in a SBSpace [17070] > > > > > > > > > > Art: > > > > > > > > > > The error has changed now... > > > > > > > > > > Look: > > > > > > > > > > MODIFY: ESC = Done editing CTRL-A = Typeover/Insert CTRL-R = > > > > > Redraw > > > > > > > > > > CTRL-X = Delete character CTRL-D = Delete rest of line > > > > > > > > > > -- 10 to 20 of 20 ----- imagem@df06_d ---------- Press CTRL-W for > > > Help > > > > > -------- > > > > > > > > > > NU_SEQUENCIAL INTEGER , > > > > > > > > > > ID_STATUS_ANEXO_GUIA INTEGER , > > > > > > > > > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > > > > > > > > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > > > > > > > > > ID_PRESTADOR INTEGER , > > > > > > > > > > ID_OPERADORA INTEGER , > > > > > > > > > > ID_MAQUINA INTEGER , > > > > > > > > > > NM_SERVICO VARCHAR(100) , > > > > > > > > > > ID_THREAD INTEGER , > > > > > > > > > > IMAGEM BLOB IN sbs_photospace01 ) > > > > > > > > > > EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > > > > > > > > > 201: A syntax error has occurred.> > > > > > > > > > The cursor stopped before "IN sbs_ photospace01". I don't know if > > > I'm > > > > > wrong, but... in my opinion, I can't put just one column inside a > > > > > SBSpace; I must store the entire table, opposite a Blobspace... Is > > > > that > > > > > right? > > > > > > > > I haven't used BLOB columns, but if I'm reading the manual correctly, > > > > for a BLOB column, you leave the IN clause off and the engine assigns > > > > the sbspace used on the fly as you store your images are saved. So try > > > > > > > this, instead: > > > > > > > > CREATE TABLE TB_ANEXO_GUIA1 > > > > ( > > > > ID_ANEXO_GUIA INTEGER NOT NULL,> > > > CD_GUIA_PRESTADOR VARCHAR(20) NOT N

↪ replying to Alberto Romeu

Nilesh Ozarkar — Fri, 18 Sep 2009 14:53:08 — source: IIUG Forums & Mailing Lists

Here are the links to the IDS documentation... Large-object data types - http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=3D/co= m.ibm.sqls.doc/sqls986.htm IDS Info Center - http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp - Nilesh - = From: "Alberto Romeu Pessonio Filho" <arfilho@orizonbrasil.com.= br> = To: ids@iiug.org = = Date: 09/17/2009 12:28 PM = = Subject: RES: Creating a table with BLOB in a SBSpace [17075] = = Sent by: ids-bounces@iiug.org = = Art: Perfect!!! I created the table. No words to tell you how grateful I am!!! I'd like to thank Bogdam Botez and Everett Mills, as well. Great Forum!!! Unfortunately, I've searched all manuals of IDS I have (and I have abou= t 40 manuals), but I didn't find any example of how to create a table using BLOBS. Maybe, I didn't see at the moment, because I was in a hurry. Any hint of a specific document / white paper, etc... that I can= use as a reference to work with datablades on IDS and Image Datablade Module? Thank you all, Alberto Pessonio Orizon Brasil www.orizonbrasil.com.br -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art Kagel Enviada em: quinta-feira, 17 de setembro de 2009 14:11 Para: ids@iiug.org Assunto: Re: Creating a table with BLOB in a SBSpace [17073] It will work that way, but if you want to use a specific sbspace, you need to use the PUT clause. I was just having a senior moment there. See my corrected post. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinion= s and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 17, 2009 at 12:38 PM, Everett Mills < Everett.Mills@nationalbeef.com> wrote: > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Alberto > > Romeu Pessonio Filho > > Sent: Thursday, September 17, 2009 11:21 AM > > To: ids@iiug.org > > Subject: Re: Creating a table with BLOB in a SBSpace [17070] > > > > Art: > > > > The error has changed now... > > > > Look: > > > > MODIFY: ESC =3D Done editing CTRL-A =3D Typeover/Insert CTRL-R =3D > > Redraw > > > > CTRL-X =3D Delete character CTRL-D =3D Delete rest of line > > > > -- 10 to 20 of 20 ----- imagem@df06_d ---------- Press CTRL-W for Help > > -------- > > > > NU_SEQUENCIAL INTEGER , > > > > ID_STATUS_ANEXO_GUIA INTEGER , > > > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > > > ID_PRESTADOR INTEGER , > > > > ID_OPERADORA INTEGER , > > > > ID_MAQUINA INTEGER , > > > > NM_SERVICO VARCHAR(100) , > > > > ID_THREAD INTEGER , > > > > IMAGEM BLOB IN sbs_photospace01 ) > > > > EXTENT SIZE 102400 NEXT SIZE 102400 lock mode row; > > > > 201: A syntax error has occurred.> > > > The cursor stopped before "IN sbs_ photospace01". I don't know if I'm > > wrong, but... in my opinion, I can't put just one column inside a > > SBSpace; I must store the entire table, opposite a Blobspace... Is > that > > right? > > I haven't used BLOB columns, but if I'm reading the manual correctly,= > for a BLOB column, you leave the IN clause off and the engine assigns= > the sbspace used on the fly as you store your images are saved. So tr= y > this, instead: > > CREATE TABLE TB_ANEXO_GUIA1 > ( > ID_ANEXO_GUIA INTEGER NOT NULL, > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > CD_CARTEIRINHA VARCHAR(30) , > COD_OPERADORA_ANS VARCHAR(6) , > NM_ARQUIVO VARCHAR(255) , > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > NU_TAMANHO_ARQUIVO BIGINT , > NU_SEQUENCIAL INTEGER , > ID_STATUS_ANEXO_GUIA INTEGER , > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > ID_PRESTADOR INTEGER , > ID_OPERADORA INTEGER , > ID_MAQUINA INTEGER , > NM_SERVICO VARCHAR(100) , > ID_THREAD INTEGER, > IMAGEM BLOB)> > > Tks, > > > > Alberto. > > > > De: Art Kagel [mailto:art.kagel@gmail.com] > > Enviada em: quinta-feira, 17 de setembro de 2009 13:06 > > Para: Alberto Romeu Pessonio Filho > > Assunto: Re: Creating a table with BLOB in a SBSpace [17064] > > > > Yes, what I didn't notice is that you are trying to put the entire > table > > into the sbspace. Tables live in regular dbspaces, you would place > ONLY > > the BLOB column into the sb_space. So, that should be: > > > > CREATE TABLE TB_ANEXO_GUIA1 > > ( > > ID_ANEXO_GUIA INTEGER NOT NULL, > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > CD_CARTEIRINHA VARCHAR(30) , > > COD_OPERADORA_ANS VARCHAR(6) , > > NM_ARQUIVO VARCHAR(255) , > > DS_EXTENSAO_ARQUIVO VARCHAR(3) , > > NU_TAMANHO_ARQUIVO BIGINT , > > NU_SEQUENCIAL INTEGER , > > ID_STATUS_ANEXO_GUIA INTEGER , > > DT_INCLUSAO DATETIME YEAR TO FRACTION(5) , > > DT_ULTIMO_PROCESSAMENTO DATETIME YEAR TO FRACTION(5) , > > ID_PRESTADOR INTEGER , > > ID_OPERADORA INTEGER , > > ID_MAQUINA INTEGER , > > NM_SERVICO VARCHAR(100) ,> > ID_THREAD INTEGER > > , > > IMAGEM BLOB IN sbs_photospace01 > > ) > > IN some_normal_dbspace EXTENT SIZE 102400 NEXT SIZE 102400 lock mod= e > > row; > > > > Art S. Kagel > > Oninit (www.oninit.com <http://www.oninit.com>; ) > > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org> ) > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > and do not reflect on my employer, Oninit, the IIUG, nor any other > > organization with which I am associated either explicitly or > implicitly. > > Neither do those opinions reflect those of other individuals > affiliated > > with any entity with which I am affiliated nor those of the entitie= s > > themselves. > > > > On Thu, Sep 17, 2009 at 12:00 PM, Alberto Romeu Pessonio Filho > > <arfilho@orizonbrasil.com.br> wrote: > > > > Hi Art!!! > > > > Ok, but i changed the datatype from BYTE to BLOB and the error stil= l > > remain. > > > > SQL: New Run Modify Use-editor Output Choose Save Info Drop > > Exit > > Modify the current SQL statements using the SQL editor. > > > > ----------------------- imagem@df06_d ---------- Press CTRL-W for Help > > -------- > > > > CREATE TABLE TB_ANEXO_GUIA1 > > ( > > ID_ANEXO_GUIA INTEGER NOT NULL, > > CD_GUIA_PRESTADOR VARCHAR(20) NOT NULL, > > CD_CARTEIRINHA VARCHAR(30) , > > COD_OPERADORA_ANS VARCHAR(6) , > > NM_ARQUIVO VARCHAR(255) , > > DS_EXTENSAO_ARQUIVO VARCHAR(3) ,> > NU_TAMANH

Creating a table with BLOB in a SBSpace

Related threads

Glossary

Your privacy choices