How to INSERT/UPDATE data type "text" in Informix IDS11.7
karthik rajan
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.
Superboer
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