[Info-ingres] E_CO0039 Cannot convert column to tuple format when encountering Infinity

[Ingres Forums]

I have an ascii unload of a database which is loading fine except for
one table on which I get the error 
"E_CO0039 COPY: Error processing row 2737.  Cannot convert column
'before_image_float' to tuple format"

The error seems to be when the data includes this
"0.Infinity000000000000000000000000000000" - I haven't seen this before.
Does anyone know what it is and  how I can load the data? 

These are the create and copy in statements:

create table TABA(
col1 integer not null not default,
col2 integer not null not default,
col3 integer not null not default,
col4 i1 not null not default,
col5 integer,
col6 float,
col7 varchar(25) not null not default
)
with noduplicates,
nojournaling,
page_size = 2048,
security_audit=(table,norow)
\p\g

copy TABA(
col1= c0tab,
col2= c0tab,
col3= c0tab,
col4= c0tab,
col5= c0tab with null(']^NULL^['),
col6= c0tab with null(']^NULL^['),
col7= varchar(0)nl,
nl= d0nl)
from 'TABA.USER'

Thanks


-- 
jackie.mclellen at harris.com
------------------------------------------------------------------------
jackie.mclellen at harris.com's Profile: http://community.actian.com/forum/member.php?userid=9734
View this thread: http://community.actian.com/forum/showthread.php?t=16347