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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problems to update byte value in a table informix

I need help ... I have to update a table with a string of type byte. Paste the string in the TMAP by the cast: Byte.valueOf (dg1651dv161sd51 ..."), but when I try to upgrade gives the following error:
Exception in component tMap_5
java.lang.NumberFormatException: For input string: "504b0304140002000800074f5a3d75465ac3b ....
The field of the table that I update is byte, so realizao cast.
I hope I can teach. Thanks.
Labels (3)
3 Replies
Anonymous
Not applicable
Author

Hello
There exist some chars such 'a' ,'b' in these string "504b0304140002000800074f5a3d75465ac3b ....", you must remove these rows or do some processing before convert it to byte using Byte.valueOf(String s)
Best regards
Shong
Anonymous
Not applicable
Author

nice post
Anonymous
Not applicable
Author

thanks for the share guys 0683p000009MACn.png
0683p000009MACn.png
0683p000009MACn.png
0683p000009MACn.png
0683p000009MACn.png
0683p000009MACn.png