Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: Strange DBI/DBD::ODBC behaviour (right truncation of data on ODBC call)

by jfroebe (Parson)
on Oct 21, 2019 at 18:59 UTC ( #11107780=note: print w/replies, xml ) Need Help??


in reply to Strange DBI/DBD::ODBC behaviour (right truncation of data on ODBC call)

You may need to set the StringColumnLength connection parameter to a higher value. see ERROR: "Informatica ODBC 10170 String data right truncation on data from data source: String data is too big for the driver's data buffer" while running the session with PowerExchange for Cassandra for Cassandra Target in PowerCenter. It appears to be an ODBC driver issue not a DBI one imo

Jason L. Froebe

Tech Blog

  • Comment on Re: Strange DBI/DBD::ODBC behaviour (right truncation of data on ODBC call)

Replies are listed 'Best First'.
Re^2: Strange DBI/DBD::ODBC behaviour (right truncation of data on ODBC call)
by jahero (Pilgrim) on Oct 22, 2019 at 09:14 UTC

    Hi Jason!

    Thanks for the pointer (and the time it took to find that link).
    At the first glance, it does not seem to be the solution - ODBC driver in question (Teradata) does not seem to support such attribute, nor did I find anything with approximately the same meaning. I will, however, investigate, and let you know what I found.

    Regards, Jan

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (2)
As of 2021-10-15 19:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My first memorable Perl project was:







    Results (68 votes). Check out past polls.

    Notices?