With the StyleSet Editor, you can easily index CLOB and BLOB fields. For information on using the StyleSet Editor with the ODBC Gateway, see the Verity K2 ODBC Gateway Guide. The Exchange gateway uses NT Challenge/Response for authentication.

The next version of the ANSI/ISO SQL standard defines some new datatypes, commonly referred to as the SQL3 types. The primary SQL3 types are: STRUCT: This is the default mapping for any SQL structured type, and is manifest by the java.sql.Struct type. REF: Serves as a reference to SQL data within the database. Can be passed as a parameter to a SQL statement. Mapped to the java.sql.Ref type.

Create a ColdFusion page called "showImage.cfm" and pass it paramaters to uniquely identify an image. The CF page then sets the content type to, for example, "image/gif", then return the binary data. <\img src="ShowImage.cfm?ImageID=3456"> Microsoft also has an article about serving images from a BLOB field using SQL server. The example is in ASP, but the theory is the same for ColdFusion

A BLOB (Binary Large OBject) is essentially an array of bytes (byte[]), stored in the database. You extract the data in two steps: Call either getBinaryStream() or getBytes() in the extracted Blob object to retrieve the java byte[] which is the Blob object. Note A Blob is essentially a pointer to a byte array (called LOCATOR in database-talk), so the java.sql.Blob object essentially wraps a byte pointer. Thus, you must extract all data from the database blob.

No. Propel will automatically start and commit the transaction if you are using PostgreSQL and are performing a query which involves a LOB column. Yes, in so much as PDO supports them. You can add any PDO configuration properties to your runtime-conf.xml; however, it is probably worth first checking to make sure that PDO does adequately support the feature you wish to use. We've learned through use and user reports that PDO doesn't always work very consistently ..

We are facing a performance problem concerning BLOBs and CLOBs. Much time is consumed when loading data into the BLOB or CLOB using JDBC Driver. It's true that inserting data into LOBs using JDBC Thin driver is slower as it still uses the DBMS_LOB package and this adds the overhead of a full JDBC CallableStatement execution for each LOB operation. With the JDBC OCI and JDBC server-side internal drivers, the inserts are faster because native LOB APIs are used.

Handling BLOB data with the DBI is very straight-forward. BLOB columns are specified in a SELECT statement as per normal columns. However, you also need to specify a maximum BLOB size that the <I>database handle</I> can fetch using the LongReadLen attribute. dbh is a connected database handle $sth = $dbh->prepare( "SELECT blob_column FROM blobby_table" ); $sth->execute; dbh is a connected database handle ### Set the maximum BLOB size... $dbh->{LongReadLen} = 16384; ### 16Kb.

Yes. All you have to do is to have the database export the information in a form suitable for uploading. This is a spreadsheet-type file of the type mentioned above. EDO Software Services will supply examples of the format required. One of the advanced features of EDO Retail is support for a "product matrix". This means that a small table, like a mini-spreadsheet, can be created for a product item, specifying the size/colour combinations that are available.

There are 10 standard reports you can run from the database. Most of these can also be sent to a file which can be imported to a word processor to be edited. Five books have been produced in Rhode Island using just this technique.

Typically, a Kaleidescape System will download approximately 100 MB of data per week to keep the Kaleidescape Movie Guide and Music Guide current. Upload varies, depending on the number of Players and other factors, but should be approximately 10 MB per week. Kaleidescape releases KEAOS upgrades a few times per year; a KEAOS release is less than 50 MB and is downloaded automatically by your Kaleidescape System.

Data can be uploaded as often as you like. The site has been used in the past for uploads as frequently as 5 minutes.

Once you have collected your data and had it reviewed by one of the stewards, you will be given a DATAMP account. This allows you to log into the DATAMP server and access a set of pages for stewards only. On the steward page there are a number of links to allow you to manage your steward account (changing passwords, etc), analyze your patent data, and edit/upload patent data.

The database contains venture-funded transactions as far back as January 1, 2003. There are thousands of transactions, venture investors, technology companies and service firms, with hundreds more added each month across all high technology and life science sectors.

Please note: Background information on the creators and the X-titles editorial offices is based on over a decade's worth of interviews, articles, and personal questions, and as such is not directly attributed here. Now that some of Marvel's staff members are on Usenet, they are welcomed to correct and amend any of the answers listed below.