I have to save blob data to solidDB, but it doesn't work as expected. As you know, solidDB cannot accept blob data, so I convert blob attribute into rstring by convertFromBlob() built-in function.
<Before the conversion : blob>
<After the Conversion : rstring>
After the conversion, I insert records into solidDB table by ODBCAppend operator (of course, the associated column type is rstring) . I checked the result and found as follows (the associated column name is GNHEADER):
[streamsadmin@myhost Test_Blob_Solid]$ solsql -e "select * from mytable" "my_solid_db" solid solid IBM solidDB SQL Editor (teletype) - Version: 22.214.171.124 Build 2011-10-14 Copyright Oy International Business Machines Ab 1993, 2011. SOURCEDEVICEID UDPFWMESSAGEID GNHEADER -------------- -------------- -------- 1234 4d2.13d1ec66ba8 1234 4d2.13d1ec66f90 1234 4d2.13d1ec67377 3 rows fetched.
GNHEADER column seems empty...
To make sure, I retrieved those records by ODBCRun and converted GNHEADER from rstring to blob by convertToBlob() function and output tuples to a file.
As you can see, GNHEADER values have been missing.
What I mentioned above is incorrect as a way to handle blob attribute?
Could you please tell me the proper way to save blob data to solidDB by SPL application?
I appreciate your help in advance.