(Willie Favero) Service Oriented Architecture (SOA) touches everything today, including DB2. If you need to keep up with what’s happening with SOA and Data, I have a couple of IBM resources you should check out.
Author: SSWUG Research
Build Date Generators and Manipulate Date and Time Data in SQL
(Alex Kozak) Sometimes you need to generate sequences of date and/or time values. For example, take a data warehouse that has a multidimensional structure and stores the measures and dimensions in fact and dimension tables. Since one of the dimensions is almost always the time dimension, you would n
Writing Managed Triggers using C#
(Laishram Priyokumar) With the integration of the CLR with SQL Server 2005, we can create database objects using modern object-oriented languages like VB.NET and C#.
Creating Crystal Reports Using the Push Method in .NET
(kmckisic) In our development careers, many of us are and will be called upon to integrate either a stand-alone application or a web application to Crystal Reports. For must of these applications, you will not have access to a relational database where you could simply attach your report. So, there
Using Symmetric Encryption in a SQL Server 2005 Database
(Erich Peterson and Siqing Li) As the attacks in which hackers use become more and more sophisticated, and the programs in which they attack become increasingly complex, encryption is becoming the last line of defense in database management system (DBMS) security. A previous article of ours, An Over
11i: Expire All User Passwords
Occasionally, there is a need to expire all application user passwords in Oracle Applications 11i. Oracle now provides a script to expire all users passwords in 11i.ATG_PF.H RUP4. The script is located in $FND_TOP/patch/115/sql/AFCPEXPIRE.sql. It can be executed using SQL*Plus or as the concurren
Guide to Advanced Linux Command Mastery, Part 2
(Arup Nanda) In Part 1 of the series, you learned some useful commands not so widely known and some of the often used commands but not-so-well-known parameters to do your job more efficiently. Continuing on the series, now you will learn some slightly more advanced Linux commands useful for Oracle u
IBM Issues Patch For DB2 ‘Viper’ Security Flaw
(Paul McDougall) The flaw in one of the latest releases could allow local users to write to, or alter, any file on a company’s system.
ABAP Workbench Tools
(Arindam Ghosh) For editing Repository Object one may need different kinds of tools; ABAP Workbench contains the tools that are required for editing Repository objects. This article examines the various tools used for ABAP workbench.
Mobile Ajax for workers on the edge
(Rich Seeley) Ajax may provide the glue holding together the virtual corporation with its growing number of mobile workers toiling on the edge of the business, tethered by sometimes tenuous wireless connections, according to the Clipper Group Inc.