(Benoît Marchal) In this tip, Benoît discusses the different solutions available for passing binary data (typically files) to a Web service. The evolution of Web service protocols has gone from supporting very simple requests with simple parameters to fully supporting modern, object-oriented lan
Other News
Return Hours Worked
(Srikanth Cherla) This function returns the number of hours worked between 9 a.m. to 9 p.m. for ‘N’ number of days.
Reviewing Web Architecture: Conclusions
(Kendall Grant Clark) In this seventh and final installment of my series of XML-Deviant columns about the W3C TAG’s Architecture of the World Wide Web (AWWW) document, I conclude my examination of the third key architectural principle, data formats, which I have been calling “representation”. Wh
A Visual Tour of SQL Server Yukon
(Suhil Srinivas) This article has been written with keeping in mind of the large number of developers who do not have access to the SQL Server beta 1. Often, I feel that there are plenty of developers who hear and read about the new yet to be released products but have not means to look at them. Alt
Subtleties of Data-Type Precedence
(Brian Moran) A reader sent in a T-SQL query because it didn’t work as he expected. He was unable to concatenate 0 with the WHEN ‘1’ branch of the CASE statement. The T-SQL code is supposed to explicitly convert the integer value ‘2004-09-24’ to a char data type, but the result remains an integer va
Performing Bulk Load of XML Data
XML Bulk Load is a stand-alone COM object that allows you to load semistructured XML data into Microsoft SQL Server tables. You can insert XML data into a SQL Server database by using an INSERT statement and the OPENXML function; however, the bulk load utility provides higher performance when you ne
Advanced Oracle & Java
You have been introduced in the previous Oracle laboratory to the basics of JDBC. In the next sections, we will discuss two more advanced topics: how to run PL/SQL code from Java—and conversely, how to run Java code from PL/SQL. The two issues we are going to address during this laboratory have a l
Super-Fast XML Wrapper Generation in DB2: A Demonstration
(Vanja Josifovski, Sabine Massmann, and Felix Naumann) The XML Wrapper is a new feature of the federated database capabilities of DB2/UDB v8. It enables users and applications to issue SQL queries against XML data from a variety of sources, including files and web services. The XML Wrapper assumes h
Review of Lumigent Log Explorer v4
(Christoffer Hedgate) One of the best known third-party products in the SQL Server arena is Log Explorer from Lumigent Technologies. I am not saying every DBA has it in his toolbox, but most of us have heard about it. It is the only tool (that I know of at least) that connects directly to the transa
DB2 Everyplace workshop (England)
Are you an ISV or IBM Business Partner wanting to establish a mobile solution in your enterprise? Are you interested in IBM’s mobile technology with DB2 Everyplace? If so, this 3-day workshop is for you!