I did a search for CLOBs in this forum and found nothing, which isn't very encouraging, but I'll ask anyway. I am trying to figure out how to send a CLOB to a stored procedure. The Stored procedure is in IBM DB2 on a mainframe, written in COBOL, and we are using DB2Connect as our driver, and using ADO and the OLE-DB provider for ODBC on the VB side.
It looks as though I should be able to create a CLOB parameter in an ADO Command, but it blows up when it tries to bind the parameter, with an Invalid Conversion error. If we try to send anything greater than 32704 bytes (32K size minus 64 bytes), it gives us an error. I know that DB2Connect says you can't send a parameter greater than 32K, but with CLOBS, I thought it may be possible using AppendChunk, so that it would somehow know to send the data a chunk at a time.
Does anyone have any experience working with CLOBs or BLOBs in VB (doesn't necessarily have to be against DB2) that could give some suggestions to try? Any ideas would be appreciated.
It looks as though I should be able to create a CLOB parameter in an ADO Command, but it blows up when it tries to bind the parameter, with an Invalid Conversion error. If we try to send anything greater than 32704 bytes (32K size minus 64 bytes), it gives us an error. I know that DB2Connect says you can't send a parameter greater than 32K, but with CLOBS, I thought it may be possible using AppendChunk, so that it would somehow know to send the data a chunk at a time.
Does anyone have any experience working with CLOBs or BLOBs in VB (doesn't necessarily have to be against DB2) that could give some suggestions to try? Any ideas would be appreciated.
