(Trudy Pelzer) In this article, I’ll give a preliminary description of a new MySQL feature for scheduling and executing tasks. In version 5.1.6, MySQL has added support for events. That is, you can now say: “I want the MySQL server to execute this SQL statement every day at 9:30am, until the end of
Author: SSWUG Research
How to Install 32-bit Oracle on an x86-64 Platform
(Marc Fielding) I couldn’t find this install documented anywhere on Metalink or the Internet, so here are some instructions on how to do it. It’s written for Oracle 9 and RHEL3, but should apply to Oracle 10 and RHEL4 as well.
What’s Up with XSL Formatting Objects?
(Ed Tittel) The eXtensible Stylesheet Language, aka XSLT, is actually a collection of specifications for ways to transform and render XML based documents. XSL Formatting Objects (XSL-FO) is designed specifically to take XML content and format it for hard copy printing or other forms of fixed-size pa
Asked & Answered
(Robert Catterall) What’s your recommendation for performing DB2 v.7 traces running under z/OS V1R4 in a production environment? Our tracing, implemented via zPARMs, consumes precious CPU cycles and real memory and also fills up the SYS1.MANx datasets with type 100-102 records in the SMF infrastruc
Using MySQL, Joins
(Keith Brown) In this Virtual Workshop we will look at retrieving data from a relational database structure, i.e. with multiple tables, using the SQL JOIN Syntax. Most databases have multiple tables to avoid repeating data. i.e. why enter the details of a customer over and over again.
Improving Application Startup Time
(Claudio Caldato) Visual Studio is a wonderful development environment, whose IntelliSense, integrated debugging, online help, and code snippets help boost your performance as a developer. But just because you’re writing code fast doesn’t mean you’re writing fast code.
OC4J – The ‘Other’ Oracle Application Server
(Steve Callan) How does extensible markup language relate to the J2EE standalone version of Application Server? If “extensible markup language” sounds unfamiliar to you, perhaps you know it better by its acronym of XML. XML matters not to just to the J2EE version of Application Server, but to all ve
You may not be able to apply SQL Server 2000 64-bit post SP4 hotfix build 8.0.2156 or a later build
After you use Microsoft Windows Installer 2.0 to apply a Microsoft SQL Server 2000 post Service Pack 4 (SP4) hotfix that is earlier than build 8.0.2156, you may not be able to apply SQL Server 2000 post SP4 build 8.0.2156 or a later build. Typically, this problem occurs when the following conditions
Leverage data partitioning for scalability and high performance on Linux
(Fraser McArthur and Samuel Poon) Learn the ins and outs and explore the performance and scalability advantages of the IBM DB2 Universal Database Data Partitioning Feature (DPF) in DB2 UDB for Linux, UNIX, and Windows. Then, walk through the steps to install and configure DB2 with DPF on SUSE Linux
Implement MVC in custom SWT components
(Tejas R Parajia) The MVC architecture (or design pattern) is a graphical user interface (GUI) design style that consists of three parts: model, view, and controller. MVC decouples presentation from data as well as presentation from operations on that data.