Re: Bad int8 external representation "" (SQL-HY000)(DBD: st_execute/SQLExecute err=-1)

It's a numeric field and you are trying to insert an empty string rather
than undef (equivalent to null).

When you queried the other database and had the values in memory....not
written to a file... they stayed undef. When you split the row from the
file, you have empty strings rather than undef or null.

You also need to be chomping.

On 4/19/06, Peter Loo <loopeter@xxxxxxxxx> wrote:

No Ron. I did not chomp the record, but I am quite certain that it is
not the issue. The field it is complaining about is blank. The odd
thing is that the column it is going into is allowed for NULL values.
I don't know what else to do, but will certainly give chomp a try.

Yes, I am only testing with one record.

Thanks.

Peter

--- Ron Savage <ron@xxxxxxxxxxxxx> wrote:

On Tue, 18 Apr 2006 11:44:50 -0700, Loo, Peter # PHX wrote:

Hi Peter

[unixODBC]ERROR: copy: line 1, Bad int8 external representation ""
(SQL-HY000)(DBD: st_execute/SQLExecute err=-1)

Line 1, eh? First attempt to insert data? Did you try chomp-ing the
line?

--
Cheers
Ron Savage, ron@xxxxxxxxxxxxx on 19/04/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company





Peter Loo
Worldwide Consulting, Inc.
Phoenix, Arizona
U.S.A.




--
--------------------------------------------------------------------------------------------------------------
The darkest places in hell are reserved for those who maintain their
neutrality in times of moral crisis.
Dante Alighieri (1265 - 1321)

They who would give up an essential liberty for temporary security, deserve
neither liberty or security.
Benjamin Franklin

Our lives begin to end the day we become silent about things that matter.
Martin Luther King

Our government can't be bought. The oil companies will never give it up at
any price.
My opinion
--------------------------------------------------------------------------------------------------------------

Relevant Pages

  • Re: Use of uninitialized value Error
    ... but then a null in the paramater was the same as just declaring ... now gives $email a defined value: the empty string. ... First, it calles the param() function, passing ... returns undef if the argument it receives was not passed to the CGI ...
    (comp.lang.perl.misc)
  • Re: Oracle schema names: sqlplus v Perl
    ... $sth->execute or return undef; ... Also, if nothing gets written to STDOUT, then it's probably bailing on ... They who would give up an essential liberty for temporary security, ...
    (perl.dbi.users)
  • Re: regex and parsing config file directives..
    ... If $_ matches persist-key, then it cannot ... So both $1 and $2 are undef. ... $2 to the empty string ... equality test succeeds, and $_ becomes $1 - that is to say, undefined. ...
    (perl.beginners)
  • Re: Perl on AS400
    ... and you are right the problem state in the conversion ... > 26, undef ... > constants definition module. ...
    (comp.lang.perl.misc)
  • Re: Help with uninitialized value warning
    ... unintialized warnings simply alert you that you're trying to use ... the undef value), which is often not what you want. ... If you find it odd that the comparison succeeds, ... is equal to an empty string. ...
    (comp.lang.perl.misc)