(David Clark) Though it’s not as common a combination as PHP and MySQL, PHP and Microsoft SQL Server can be a powerful team. You can query SQL Server databases easily and effectively using the PEAR database abstraction layer, just as you would a MySQL database. But once you start trying to use one o
Other News
Introduction to DataSets with Visual Basic .NET
(Rod Stephens) Loading a DataSet from a database requires much less code than building one inline, though the code is a bit more complicated. Program FromDB shows how you can load a DataSet from a database. Program FromDB uses the code shown in Listing 2 to load its DataSet. The program begins w
Leveraging IT Assets
(Anupam Singh) XML is establishing itself as the standard for exchange of information across enterprises. However, the technology that allows enterprise-class applications to deal with XML processing is still not clearly formulated. This causes most enterprise customers to implement their own archit
Simple Object Access Protocol (SOAP)
(Brian Travis and Mae Ozkan) The Simple Object Access Protocol (SOAP) is a standard that has provided a simple solution to a complex problem. The problem is that integrating systems is difficult. That’s not really news, but it is a fact that many I.T. professionals are well aware of. The main area o
Debugging Java Stored Procedures on DB2 UDB for z/OS
(Peggy Rader) The IBM Distributed Debugger provides a GUI interface for debugging Java stored procedures on DB2 Universal Database for Linux, UNIX, and Windows. This option is not available for debugging DB2 interpreted Java stored procedures on DB2 for z/OS. There are two alternatives that you can
Sample Asynchronous Oracle to DB2 Data Replication–Needs description
Extnsive fast tips and ER diagram on how to set up replication between DB2 and Oracle.
MQSeries for OS/390 V5.2: CF and DB2 issues, part 1
(Ruud van Zundert) Although IBM strives to make the whole product family look and feel the same, there are always going to be differences due to the underlying operating systems. This article concentrates on the differences on the OS/390 side of MQSeries, and in particular on the Coupling Facility (
The Trigger-Happy DBA
(Steve Callan) Who is the trigger-happy DBA? No, I do not mean the DBA who is pulling his hair out over a developer’s mistake (“I truncated all my tables. Why can’t you simply do a rollback for me?”), or the DBA fighting management’s insistence on using export as the primary backup and recovery stra
DOM for Web Services, Part 2
(Faheem Khan) In the first article of this series, I discussed web service usage models and described XML processing requirements in web services. I also introduced W3C Document Object Model (DOM) and two of its popular implementations, MSXML and Xerces. This second article discusses MSXML in de
Enable Logical Object Representation in Your Database
(Sergey Savouchkine) The relational database management system (RDBMS) is based on the relational model, which is simply represented through the relations of rows and columns in two-dimensional tables. Meanwhile, the object-oriented DBMS (ODBMS or OODBMS) offers everything needed for object represen