Confusion on LONG data type support from SQLDBC
Like we know MaxDB 7.6.3 onwards is not going to support CLOB/BLOB and we have to use data types LONG BYTE/LON ASCII etc.
What confuses me though is the content of SQLDBC_C.h file present with the community edition of MaxDB 7.6.3, mainly functions like:
SQLDBC_DLLEXPORT SQLDBC_Retcode SQLDBC_LOB_close(SQLDBC_LOB* hdl);
SQLDBC_DLLEXPORT SQLDBC_Retcode SQLDBC_LOB_putData(SQLDBC_LOB* hdl, void *paramAddr, SQLDBC_Length *paramLengthIndicator);
SQLDBC_DLLEXPORT void SQLDBC_LOB_delete_SQLDBC_LOB(SQLDBC_LOB *lob);
Are these functions present to support LONG types ?? Also one more thing i would highly appreciate is, if someone can point me to some example programs which handle the LONG data types.
A working program with things like insert and select and data reading for the LONG would definitely help to clear most of the doubts in my mind.
Regarding the memory size:
For buffer-based host variables: The indicator will tell after the operation how much data in bytes was available was before the operation. One can use getObject afterwards to get the rest.
SQLDBC_LOB is an object. No size is needed, but the getLength method will tell you the size of the LOB/LONG.
The 41 bytes is the internal length in the handle transmission from SAP MaxDB server to client, and has no use at all here ...