Re: How to INSERT/UPDATE data type "text" in Informix IDS11.7
for these:
create table "informix".emp
(emp_name text);
create table "informix".emp1
(emp_name1 BYTE IN blob1);
check the manual you can use java and use a binary stream or use
locator stuff ex in
$INFORMIXDIR/demo/esqlc/blobload.ec
for:
create table "informix".emp1
(emp_name1 BLOB)
PUT emp_name1 IN (blob1);
you have to have an sbspace
eq
onspaces -c -S sbspace -p <somepath>/<somefile> -o 0 -s 1000000 -Df"LOGGING=ON"
then:
create table tessie ( a clob);-- make sure SBSPACENAME sbspace inonconfig is set...
insert into tessie values
(filetoclob( '/opt/informix/demo/esqlc/blobload.ec','server'));
the insert can also be done using java, esqlc 4gl ... check the
manual.
Superboer
On 2 aug, 15:53, karthik rajan <karthikrajan1...@gmail.com> wrote:
> Hi ,
>
> I am facing a error while inserting the data type "text" in IDS 11.7
> In many sceneraio i am getting different errors.
> I tried in DBACCESS/ISQL application as i know it dont works ,but
> eventhough i tried from the PHP application i am getting the same
> error ,but every thing works in the open admin tools.
>
> Could any from the group help me to resolve this issue .
>
> informix@HR-Server:~> onstat -
>
> IBM Informix Dynamic Server Version 11.70.UC2E -- On-Line -- Up
> 00:00:34 -- 152348 Kbytes
>
> informix@HR-Server:~> onstat -d
>
> IBM Informix Dynamic Server Version 11.70.UC2E -- On-Line -- Up
> 00:01:05 -- 152348 Kbytes>
> Dbspaces
> address number flags fchunk nchunks pgsize flags
> owner name
> 4ae7c818 1 0x60001 1 1 2048 N BA
> informix rootdbs
> 4c6e21c8 2 0x40001 2 1 2048 N BA
> informix datadbs
> 4c6e2338 3 0x42001 3 1 2048 N TBA
> informix temp1dbs
> 4c6e24a8 4 0x42001 4 1 2048 N TBA
> informix temp2dbs
> 4c6e2618 5 0x42001 5 1 2048 N TBA
> informix temp3dbs
> 4c6e2788 6 0x42001 6 1 2048 N TBA
> informix temp4dbs
> 4c6e28f8 7 0x40001 7 1 2048 N BA
> informix logdbs
> 4c6e2a68 8 0x40001 8 1 2048 N BA
> informix phydbs
> 4c6e2bd8 9 0x60011 9 1 2048 N BBA
> informix blob1
> 9 active, 2047 maximum
>
> Note: For BLOB chunks, the number of free pages shown is out of date.
> Run 'onstat -d update' for current stats.
>
> Chunks
> address chunk/dbs offset size free bpages
> flags pathname
> 4ae7c988 1 1 0 1250000 712430 PO-
> B-- /informix/chunks/rootdbs
> 4c6e2d48 2 2 0 10240000 9868205 PO-
> B-- /informix/chunks/datadbs
> 4c6e3018 3 3 0 512000 511947 PO-
> B-- /informix/chunks/temp1dbs
> 4c6e3200 4 4 0 512000 511947 PO-
> B-- /informix/chunks/temp2dbs
> 4c6e33e8 5 5 0 512000 511947 PO-
> B-- /informix/chunks/temp3dbs
> 4c6e35d0 6 6 0 512000 511947 PO-
> B-- /informix/chunks/temp4dbs
> 4c6e37b8 7 7 0 10240000 10239947 PO-
> B-- /informix/chunks/logdbs
> 4c6e39a0 8 8 0 1024000 1023947 PO-
> B-- /informix/chunks/phydbs
> 4c6e3b88 9 9 0 1024000 ~1019951 1024000
> POBB-- /informix/chunks/blob1
> 9 active, 32766 maximum
>
> NOTE: The values in the "size" and "free" columns for DBspace chunks
> are
> displayed in terms of "pgsize" of the DBspace to which they
> belong.
>
> Expanded chunk capacity mode: always
>
> CASE -1
>
> create table "informix".emp
> (emp_name text);
>
> INSERT INTO emp (emp_name)
> VALUES
> (CAST('super' AS text));>
> 9634: No cast from char to text.>
> CASE -2
>
> create table "informix".emp
> (emp_name text);
>
> INSERT INTO emp (emp_name)
> VALUES
> ('super');>
> 617: A blob data type must be supplied within this context.>
> CASE -3
>
> create table "informix".emp1
> (emp_name1 BYTE IN blob1);
>
> INSERT INTO emp1 (emp_name1)
> VALUES
> ('super');>
> 617: A blob data type must be supplied within this context.>
> CASE-4
>
> create table "informix".emp1
> (emp_name1 BLOB)
> PUT emp_name1 IN (blob1);
>
> INSERT INTO emp1 (emp_name1)
> VALUES
> (FILETOBLOB('super'));>
> 9821: Space (blob1) is not an sbspace.>
> But blob1 is an sbspace
> informix@HR-Server:~> onstat -d | grep -i blob1
> 4c6e2bd8 9 0x60011 9 1 2048 N BBA
> informix blob1
> 4c6e3b88 9 9 0 1024000 ~1019951 1024000
> POBB-- /informix/chunks/blob1
>
> informix@HR-Server:~> onstat -c | grep -i blob1
> SBSPACENAME sbspace,blob1>
> If i am getting any help from peoples it will be great as it very
> urgent.