Re: Fw: 617 error
Hi Darren,
it is not possible to insert char data into text or byte fields using
"insert into ... values(...)".
As you already figured out you can load data from a file "load from ...
insert into ..." .
You can also write a program (ESQL/C, Visual Basic, what ever) to do
this. You will find an example in the CSDK/demo/esqlc directory.:
blobload.ec
The functions Filetoblob, Filetoclob, etc. manipulate smart large
objects (datatype BLOb and CLOB) which are stored in a smart blob space.
TEXT and BYTE types are simple large objects.
Good luck,
Marion
Darren_Jacobs@carmax.com wrote:
>I've found a bit more on this. It seems a work around would be to unload
>from one table and load into the other. Also, would the filetoblob be
>pretty much the same thing?
>
>TIA
>
>----- Forwarded by Darren Jacobs/7001/Carmax on 03/16/2006 11:36 AM -----
>
> Darren_Jacobs@car
> max.com
> Sent by: To
> informix-list-bou informix-list@iiug.org
> nces@iiug.org cc
>
> Subject
> 03/16/2006 11:23 617 error
> AM
>
>
>
>
>
>
>
>
>
>
>Greetings,
>
>I have a user that needs to insert a char into a text datatype. The
>following 617 error is being received. I've looked into cast's but not
>sure if it will work. The sql statement is below. I know I've seen
>chatter on this before but do not recall the solution.
>
>Any help would be greatly appreciated.
>
>9.40 FC2w4
>HPUX 11.11
>
>Thanks
>
>
>
>-617 A TEXT or BYTE data type must be supplied within this context.
>
>This statement assigns a value that is not a simple large object to a BYTE
>or
>TEXT column or assigns a BYTE or TEXT column to a column that is not a
>simple
>large object. Neither action is supported. BYTE and TEXT values must be
>assigned as whole units to columns of the same type. Check that the
>statement
>specifies the columns that you intended.
>
>insert into ps_cx_age_cmnt
>(business_unit,
>cust_id,
>item,
>cx_comment_date,
>cx_oprid,
>comment_source,
>cx_caf_sup_review,
>cx_perm_message,
>cx_cmx_sup_review,
>cx_descrlong,
>cx_initials)>select
>business_unit,
>cust_id,
>item,
>accounting_dt,
>"CARMAX",
>"C",
>" ",
>" ",
>" ",
>cx_comments, -- (This is the character field trying to insert into
>cx_descrlong, which is a text field)
>"N/A"
>from ps_cx_penditem
>where cx_comments <> ' ';
>
>_______________________________________________
>Informix-list mailing list
>Informix-list@iiug.org
>http://www.iiug.org/mailman/listinfo/informix-list
>
>
>