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.

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 in
onconfig 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... (AT) gmail (DOT) com> wrote: