Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Using perl dbi and Sybase IQ doing insert with placeholder getting datatype error

by ww (Archbishop)
on Sep 10, 2015 at 17:31 UTC ( [id://1141579]=note: print w/replies, xml ) Need Help??


in reply to Using perl dbi and Sybase IQ doing insert with placeholder getting datatype error

This is a question better addressed to a SYBASE (IQ server) oriented group. <insert> If the insights from </insert> runrig <insert> and Herveus </insert> has offered a possible approachdon't nail the explanation, then you may be dealing but even that deals with a SYBASE issue.

And, in the big picture, creating your temp table with a single (varchar(25)) field for your output looks a lot like byte-paring or premature optimization. You've said as much, in effect, in describing your workaround -- a temp table with two fields. So, while your hope of understanding your error is highly commendable, I suspect <insert> that if the replies above don't explain adequately, </insert> the root issue is within SYBASE, not Perl.

EDITS above: after seeing Herveus' note which tends to undermine my notion that the problem may be with the server s/ware.


++$anecdote ne $data

--
  • Comment on Re: Using perl dbi and Sybase IQ doing insert with placeholder getting datatype error
  • Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1141579]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others romping around the Monastery: (3)
As of 2024-04-19 03:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found