Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. essiprojects

    VARCHAR greater than 256 in a PROCEDURE

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

    Hi, I have a table like this:

    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...
  3. essiprojects

    Hi, I have a table like this:

    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.
  4. essiprojects

    VARCHAR greater than 256 in a PROCEDURE

    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...
  5. essiprojects

    Hi, I have a table like this:

    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...
  6. essiprojects

    Hi, I have a table like this:

    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...
  7. essiprojects

    Hi, I have a table like this:

    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...
  8. essiprojects

    Hi, I have a table like this:

    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...
  9. essiprojects

    dbaccess connection from a different machine

    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...

Part and Inventory Search

Back
Top