Thursday, December 25, 2008

Sometimes it pays to read the instructions…

First, some background. I got myself a new Dell XPS M1530 laptop for Christmas. One of the accessories I ordered with it was a Kesington sd200v docking station.

Wednesday, December 10, 2008

Reading and writing a blob in chunks

At least with Oracle using the DBMS_LOB package. The issue with using SELECTBLOB and UPDATEBLOB is that you have to store the entire blob in memory. That could create an issue if you're trying to process extremely large amounts of data. Fortunately, there are options to pass the data in smaller, more bite size chunks.

Tuesday, December 02, 2008

Some issues with PBTrace

One of the new features added beginning with PowerBuilder 10.2 was the ability to toggle database tracing on and off by setting the PBTrace parameter to either 0 or 1 in the DBParm attribute of the transaction object. reference