(Bill Hamilton) This article is a discussion of how to access Oracle stored procedures (named SQL programming blocks) and functions (which are programming blocks that return a single value) using ADO.NET. You connect to an Oracle database using managed data providers, including the Microsoft .NET
Other News
FIX: Cannot Execute SELECT COUNT(*) Against DB2 on Mainframe Using Four-Part Name
When you execute a SELECT COUNT(*) statement to retrieve the count of all records in a table against a linked DB2 server on a mainframe that is using it’s four-part name, the following error message occurs: Server: Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing a query fo
Bulk Binds and Collects in PL/SQL – Part – 1
(Amar Kumar Padhi) This article begins a discussion of how to work with collections. Previous versions of Oracle had limitations for collection usage in regards to SQL statement processing. Bulk Bind and Collect features were introduced to reduce the SQL processing overhead by efficient use of colle
IBM DB2 Performance Expert for z/OS Version 2
(Paolo Bruni) DB2 Performance Expert for z/OS is the most reliable tool for monitoring and tuning your DB2 for z/OS environments. In addition to a wide range of comprehensive reports, the tool analyzes performance online and recommends changes for DB2 performance-related settings. It is comprised of
BUG: You receive an error message when you try to deny access to a dimension member for a cube role by using a custom rule in Analysis Manager
When you try to deny access to a dimension member by defining a custom rule in a cube role in Microsoft SQL Server 2000 Analysis Services, you may receive an error message that is similar to the following: Dimension security syntax error: Set name xxxxx.xx is not valid. Do you still want to use
SQL Server Security: Dealing with Anti-Virus Programs
(Brian Kelley) With the recent slate of “virus” attacks plaguing us, a question that has come up fairly often is how to handle anti-virus programs running on the same system as SQL Server. If you tried to do an Internet search on SQL Server and anti-virus best practices you’ve probably been left
IDUG 2004 – Europe
Registration is now live. Register before 17 September to save! The International DB2 Users Group (IDUG) invites you to the premiere European DB2 education event: IDUG 2004 – Europe. The conference will run Monday – Thursday, 11-14 October, 2004 at Prague, Czech Republic. Experience four days of
Secrets of the System.Xml.Schema Namespace
(Dare Obasanjo) Every once in a while, I see questions on newsgroups or mailing lists about how to perform some task involving XML Schema that is provided by the classes in the System.Xml.Schema namespace, but is unobvious as to how to perform the task with the namespace. Over time I’ve come up with
Debug XML Web services in VS.NET
(William Sempf) XML Web services are touted by Microsoft as the next big thing. But until recently, developers were hampered in their efforts to effectively develop them, placing the future of the new protocol in some doubt. Fortunately, Visual Studio .NET has made the development and consumptio
Introduction to MSSQL Server 2000 Analysis Services: Another Approach to Local Cube Design and Creation
(William Pearson) In this article, we will explore a second approach to the creation of a local cube. While we will rely again upon the PivotTable report as our design and development tool, this time we will focus more on the use of Microsoft Query (“MS Query”), and begin with a relational database