Choose Language Hide Translation Bar
Highlighted
vince_faller
Super User

pulling large blobs from sql database

I'm trying to pull blob that ends up being larger than 65536 in the jmp column.  When I pull through ODBC, I only get the 65536.  

Is this a limitation of JMP columns? Possibly ODBC?

 

Is there a way other than making n tables and foring through each one to concat to a final  list?  If blobs are in multiple columns, this seems to get unwieldy.  

 

Any suggestions?

Vince Faller - Predictum
1 REPLY 1
Highlighted
AlexS
Level III

Re: pulling large blobs from sql database

I appreciate this is a late response but I found setting the column To_Char in SQL helped.

Alex is the name, Power BI/ SQL /JMP is my game
Article Labels

    There are no labels assigned to this post.