Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2014-10-16 07:18 AM

Reading image file(BLOB file) and insert into netezza via talend

Hi,
Please help me, I am stuck badly. I want to store images in netezza DB via talend. How can I do that? Netezza does not supports BLOB and CLOB, but any chance of using varchar(64000) and getting through??
I tried reading the image file as string using tFileInputRaw, but receiving following error while inserting using tNetezzaOutput:
"ERROR:  Unterminated quoted string
Exception in component tNetezzaOutput_2
org.netezza.error.NzSQLException: FATAL 1:  Socket command type 
at org.netezza.internal.QueryExecutor.getNextResult(QueryExecutor.java:276)"
Labels (3)
Labels
220 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2014-11-02 10:50 PM
Author

Hi,
Please take a look at:http://stackoverflow.com/questions/13613120/error-while-saving-binary-image-from-database-to-folder
Best regards
Sabrina
220 Views
0 Likes