Search results for query: *

At the end I used char. I think that you cannot use text.

Hi, Thank you for your response, but in the project that I'm doing, I cann't use 4GL. I have to use PL/SQL, because I'm working in an remote machine (from a client). Until now I was looking for an error and I think that the problem is in concat operation when concats the attribute retrieved...

Hi, Do you know why I cann't use CHAR data type without that it truncates the String? Do you know how I can resolve it? Thank you.

Hi, I have a PROCEDURE where I have to use a String variable. This String cannot be a varchar, because it is small. I need something like LVARCHAR, any type greater than 256 bytes. I have tried to use TEXT, but I got the error: 608: Illegal attempt to convert Text/Byte blob type. Does...

Hi, I don't know if I have some limitation or not, but I cann't. I tried to define as text but it wasn't possible too. I defined with text, but I don't know how to do to concat with the new values. For exemple, how to do: insert into A values (id, b1.name || b2.name); I suppose that I have...

Hi, I have done the trim when I have done the insert. The problem is that there are more than 255 characters and I don't have extra blanks. My problem is that the field name of table A doesn't allow to insert a field greater than 255 characters. When I have insert one field greater than 255 it...

Hi, I've got table like this: create table B ( id integer, name varchar(255) ); The table doesn't have primary key. My procedure compacts the table B in table A where name is a multivalued field. For exemple, B ---------------------------- id...

Hi, I have a table like this: create table A ( id int, name char(4000) ); I have a procedure where I assign values to field name, but when the assigned value is greater than 255 characters, the name is truncated. Does anybody know...

Hi, I have an informix database in a linux machine. On this, as server, I have defined: /etc/services sqlexec3 1536/tcp $INFORMIXDIR/etc/sqlhosts ol_segades3_shm onipcshm segades3 sqlexec3 As client, I have defined...