(James Koopmann) This article is the first in a three part series that will take you through the process of creating VARRAYs and dealing with them in Oracle tables.
Other News
Functions in the GROUP BY
You may encounter situations where you would like to include a function in a GROUP BY statement. For example, let’s say that you have a database with tables that have TIMESTAMP columns. A number of summary reports are produced against these tables, but at the DATE level as opposed to the TIMESTAMP l
Architects Of Change
(Kim Moutsos) After three years under construction – and a year of pre-ship buzz – DB2 UDB for z/OS v.8 is ready for the big “reveal.” DB2 Magazine talks to the product’s lead architect for a preview of the changes.
A survey of XML standards: Part 4
(Uche Ogbuji) The world of XML is vast and growing, with a huge variety of standards and technologies that interact in complex ways. It can be difficult for beginners to navigate the most important aspects of XML, and for users to keep track of new entries and changes in the space. XML is a basic sy
Web services programming tips and tricks: SOAP attachments with JAX-RPC
(Russell Butek) JAX-RPC supports SOAP with attachments. This tip describes how you can use JAX-RPC APIs to send MIME attachments.
Separating Comma Separated Strings
(Ramesh Periyasamy) This function will split an input string separated by commas into a string enclosed with single quotes. This is helful in applying conditions in dynamic SQL.
ASP Authentication Using XOR Encryption
(Valko Yotov) This article explains how to control application access by validating the user’s login and password against a SQL 2000 database. Once validated, the user gets a one time pad Access Code generated by SQL 2000 server, which is different and unique for every login – Access Code changes on
FIX: Negative 0 (zero) Causes ODBC SQL Server Driver Error
If a SQL Server query returns a negative zero, and the client application binds the results as a SQL_C_DOUBLE, the following error is reported to the client: [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
IBM Offers Bevy Of Products, Programs For ISVs
(Rochelle Garner) Let no one say that IBM doesn’t court independent software vendors. At its PartnerWorld conference in Las Vegas, IBM unveiled a cavalcade of programs, products and projects aimed at ISVs that target midsize businesses (fewer than 1,000 employees) in specific industries. Big Blu
DB2 UDB and SOAP: Database Web Services Follow-up with DataSnap
(Bob Swart) This article shows how to add authentication to DataSnap applications using a special Login method; points out that the importance of combining this with SSL certificates for increased security; and describes how to deploy the DataSnap server application on a Web server machine.