(Steve Callan) 1521. 1810. 2481. 7778. These are just a few of the port numbers Oracle uses in networking. Everyone knows 1521 is the typical port number used by a listener, but how sacrosanct is that? In other words, do other vendors know not to use 1521 for their applications because Oracle “owns”
Other News
DB2 V8 Application Development cert prep, Part 6 of 7: Advanced programming
(Drew Bradstock) In this tutorial you’ll learn advanced programming skills for writing applications that interface with the DB2 Universal Database. Topics include dynamic and static SQL, use of UDTs, compound SQL, concurrency considerations, distributed units of work, parameter markers, Unicode, and
Getting in Touch with XML Contacts
(John E. Simpson) I am trying to develop an address book kind of application. The contact information will be maintained in XML format. Is there any standard DTD for contacts?
Inside the SQL Server 2000 User Mode Scheduler
(Ken Henderson) Up through version 6.5, SQL Server™ used the scheduling facilities in Windows® to schedule worker threads, switch between threads, and generally handle the work of multitasking. This worked reasonably well and allowed SQL Server to leverage the hard-learned lessons regarding Windows
Troubleshooting .NET Applications
(Karthik Ravindran) Instrumenting and tracing XSLT transformations by treating XSLT as a regular programming language can provide very useful diagnostic data to help analyze and troubleshoot problems.
Best Practices Analyzer
(Michael Otey) If you’re a new SQL Server administrator or a part-time DBA who isn’t familiar with SQL Server, you’ll find Microsoft’s new administration tool, the SQL Server 2000 Best Practices Analyzer, invaluable. The product is available for download at http://www.microsoft.com/downloads/details
Working with the Registry
(Dinesh Asanka) I was looking for a function which will return me the country list. I found that list if countries in the registry. List of the countries resides in the SOFTWAREMicrosoftWindowsCurrentVersionTelephonyCountry List. Therefore My task was reduced to read this registry. But unfort
Raising The Bar: DB2 for OS/390 & z/OS V8 64-Bit Exploitation
(Julian Stuhler) As I’m sure everyone reading this will know by now, DB2 for z/OS Version 8 (hereafter referred to simply as “V8”) has finally become available on 26th March 2004. V8 is a very significant release of DB2 – not only in terms of the new functionality delivered to the user, but also in
Creating Primary and Unique Keys in XML Schemas
A primary key defines a column in a table as unique and required (null values are not allowed), whereas a unique key defines a column in a table as unique and optional (null values are allowed).
The path to an executable DB2 program
(Craig Mullins) Could you please explain the difference between a package and a plan, the process of precompilation, compilation and running a COBOL DB2 program as well as a COBOL CICS DB2 program? (R)