JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2 (H06.25+, J06.14+)

5 Working with BLOB and CLOB Data

• “Architecture for LOB Support” (page 54)

• “Setting Properties for the LOB Table” (page 55)

“Specifying the LOB Table” (page 55)◦

◦ “Reserving Data Locators” (page 55)

• “Storing CLOB Data” (page 55)

“Inserting CLOB Columns by Using the Clob Interface” (page 56)◦

◦ “Writing ASCII or MBCS Data to a CLOB Column” (page 56)

◦ “Inserting CLOB Data by Using the PreparedStatement Interface” (page 56)

◦ “Inserting a Clob Object by Using the setClob Method” (page 57)

◦ “Inserting a CLOB column with Unicode data using a Reader” (page 57)

◦ “Writing Unicode data to a CLOB column” (page 57)

• “Reading CLOB Data” (page 57)

“Reading ASCII Data from a CLOB Column” (page 57)◦

◦ “Reading Unicode data from a CLOB Column” (page 58)

• “Updating CLOB Data” (page 58)

“Updating Clob Objects with the updateClob Method” (page 58)◦

◦ “Replacing Clob Objects” (page 59)

• “Deleting CLOB Data” (page 59)

• “Storing BLOB Data” (page 59)

“Inserting a BLOB Column by Using the Blob Interface” (page 59)◦

◦ “Writing Binary Data to a BLOB Column” (page 60)

◦ “Inserting a BLOB Column by Using the PreparedStatement Interface” (page 60)

◦ “Inserting a Blob Object by Using the setBlob Method” (page 60)

• “Reading Binary Data from a BLOB Column” (page 60)

• “Updating BLOB Data” (page 61)

“Updating Blob Objects by Using the updateBlob Method” (page 61)◦

◦ “Replacing Blob Objects” (page 61)

• “Deleting BLOB Data” (page 61)

• “NULL and Empty BLOB or Empty CLOB Value” (page 62)

• “Transactions Involving Blob and Clob Access” (page 62)

• “Access Considerations for Clob and Blob Objects” (page 62)