JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

5 Working with BLOB and CLOB Data
• “Architecture for LOB Support” (page 55)
• “Setting Properties for the LOB Table” (page 55)
“Specifying the LOB Table” (page 56)◦
◦ “Reserving Data Locators” (page 56)
• “Storing CLOB Data” (page 56)
“Inserting CLOB Columns by Using the Clob Interface” (page 56)◦
◦ “Writing ASCII or MBCS Data to a CLOB Column” (page 57)
◦ “Inserting CLOB Data by Using the PreparedStatement Interface” (page 57)
◦ “Inserting a Clob Object by Using the setClob Method” (page 58)
◦ “Inserting a CLOB column with Unicode data using a Reader” (page 58)
◦ “Writing Unicode data to a CLOB column” (page 58)
• “Reading CLOB Data” (page 58)
“Reading ASCII Data from a CLOB Column” (page 58)◦
◦ “Reading Unicode data from a CLOB Column” (page 59)
• “Updating CLOB Data” (page 59)
“Updating Clob Objects with the updateClob Method” (page 59)◦
◦ “Replacing Clob Objects” (page 60)
• “Deleting CLOB Data” (page 60)
• “Storing BLOB Data” (page 60)
“Inserting a BLOB Column by Using the Blob Interface” (page 60)◦
◦ “Writing Binary Data to a BLOB Column” (page 61)
◦ “Inserting a BLOB Column by Using the PreparedStatement Interface” (page 61)
◦ “Inserting a Blob Object by Using the setBlob Method” (page 61)
• “Reading Binary Data from a BLOB Column” (page 61)
• “Updating BLOB Data” (page 62)
“Updating Blob Objects by Using the updateBlob Method” (page 62)◦
◦ “Replacing Blob Objects” (page 62)
• “Deleting BLOB Data” (page 62)
• “NULL and Empty BLOB or Empty CLOB Value” (page 63)
• “Transactions Involving Blob and Clob Access” (page 63)
• “Access Considerations for Clob and Blob Objects” (page 63)
54 Working with BLOB and CLOB Data