The “Working with LONG, LONG RAW and VARCHAR2(2000) Oracle Datatypes” white paper is intended to clarify the handling of the Oracle datatypes LONG, LONG RAW and VARCHAR2(2000) when they are used with Microsoft Visual Basic and Remote Data Objects (RDO). A sample project is attached that illustrates
Other News
Free IDUG Technical Webcasts
The International DB2 Users Group (IDUG) is pleased to partner with The Fillmore Group and five industry experts to deliver free webcasts on a variety of technical subjects. These real-time webcasts will be delivered one per month beginning in September. Each session will run approximately 90 mi
DB2 Technical FAQ’s
FAQs on everything from data types to lock types to altering tables in DB2.
Banking on a Standard: IFX for the Retail and Commercial Banking Arenas
(Mike Haehn) One of the basic challenges of XML developers is formulating best practices and design guides for defining their XML content. In the financial industry, the Interactive Financial eXchange (IFX) Forum has been working for over seven years to develop a business message specification to sa
Using a BLOB data type in a CMP Entity Bean
(Debu Panda) I got an email from a customer who wanted to use BLOB data type in their CMP entity bean. They store images in BLOB data types in Oracle database and want to map their CMP entity bean field to a BLOB data type. Manipulation of CLOB and BLOB from J2EE applications is a challenging task.
Finding Object Definition in SQL Server 2005
(Vinod Kumar) Any database requirement would be to view the created objects definition. And SQL Server is no different here. And in the SQL Server 2000 world we used to use the simple system stored procedure as sp_helptext to view the definition. For all backward compatibility this command still
Scanning the network for SQL Server
(Muthusamy Anantha Kumar) In a large IT department, it can be difficult to locate where new SQL Server installations were made and how many of those SQL Servers were patched, etc. This article explains how to scan the entire network to find which boxes have SQL Server instances running and how to id
Monitoring Drive and Database Free Space
(Mark Nash) It’s 13:30 AM and you get a call from the Applications On-Call person. Application XYZ is down, looks like an SQL Server problem. You find that a drive or database is out of space, causing the SQL Server to crash. Now the difficult part, find some free space and hope the SQL Server will
Turning On Pivot Tables
(Jonathan Gennick) Anyone who works with SQL knows that the results of a SELECT statement are returned in rows and columns. Most people also know that you can easily generate additional columns of data in a result by writing expressions that operate on data that actually is stored in a table. For ex
How To Get XML Representation Of an ADO Recordset in Visual Basic
When you want an XML representation of a recordset you can use the new ADODB.Stream object to retrieve a string with the XML. In ADO 2.5 it is not necessary to save on a disk using the save method to retrieve the XML string generated by the recordset.